Loading Data from SQL Server to Oracle Database Using ODBC Connection Step 1: Creating an ODBC connection: n To create an ODBC connections go to -> Control Panel -> Administrative Tools . n Double Click on Data Sources (ODBC) . n Choose System DSN tab. n Click Add button. n Choose SQL Server and click Finish button. n Choose name of Connection and select server. n Click Next> . n Enter sa users password . n Click Next > . n Click “ Change the default database to:” option and select the database from which you want to fetch data to oracle. n Click Next > , n Click Test Data Source to test the connection. n If successful the following the system will show some window like the following. n Click ...