How to Extract Data from SQL Server Using vb.Net, SqlClient, and ConfigurationManager
This video is aimed at data analysts who are already doing some coding and want to understand how to retrieve data from SQL Server and integrate it with data from other sources. In this case we'll integrate our SQL Server data with Oracle data in an ADO.Net dataset.
We'll refer to our previous video where we also extracted some Oracle data:
Many analysts are not familiar with the ConnectionManager reference, and why you should put your connection strings in the app.config settings file. Not only can it make your deployment more secure, but it can also make re-deployment a breeze as you don't have to make any code changes when you move it to another environment. Just change the config file!
This video also demonstrates how custom data integrations sometimes work. It shows how you get data from two very different platforms into one format in one dataset, so they can be transformed, and then ultimately loaded into a data warehouse or other database. While we only looked at some simple field information in this video, this technique can be used for very large, complicated transformations that could be loaded back into, say, another SQL Server database using SQLBulkCopy from data tables in the application.
If you're interested in seeing how to encrypt the connection strings section of your project config file, or how to use SQLBulkCopy to push DataTable data into a warehouse without having to loop through and insert each row, please let me know in the comments section below, and I'll make videos on those topics.
Follow us on social media:
Get Microsoft Office including Access:
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
How to Extract Data from SQL Server Using vb.Net SqlClient ConfigurationManager
vb.net sqlclient tutorial
vbnet sqlclient dynamic sql
vbnet sqlclient configurationmanager
integrate oracle and sql server data
vbnet sqlclient dataadapter dataset
odbc vs sqlclient
vbnet datatable datarow
visual basic .net (programming language)
vb.net programming
vb net
visual basic .net
dot net
vb.net console sqlclient datatable
sean mackenzie
Watch video How to Extract Data from SQL Server Using vb.Net, SqlClient, and ConfigurationManager online without registration, duration 09 minute 21 second in high hd quality. This video was added by user Sean MacKenzie Data Engineering 01 April 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 394 once and liked it 5 people.