October 17, 2016 at 1:18 pm
Can you direct me to a resource that will help me set up a connection from SSIS to ORACLE. I plan to move SQL SERVER Data to ORACE.
October 20, 2016 at 4:59 pm
you will need Oracle drivers installed on your development and production machines. I would look at the drivers from Attunity as they seem to run much faster than the Oracle ones - go figure
You will need to create ODBC connections in ODBC32 (in the Windows/System folder in 32bit architecture and in Windows/SysWOW in 64bit - even though Microsoft decided to keep the application name as ODBC32 - thanks for that :-P)
You should then be able to access the Oracle server through the ODBC connection.
Last time I did this I was pulling data from Progress on Linux to Oracle in the cloud via on-prem SQL server. Not pretty, but effective.
You might need to do some tuning of the ODBC connections for packet size and #records and you will almost certainly need to tune the throughput of the SSIS package
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply