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:

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
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
visual basic .net
dot net
sean mackenzie