Home » RDBMS Server » Networking and Gateways » Connect SQL Database from Oracle (Oracle 11g)
Connect SQL Database from Oracle [message #662908] Mon, 15 May 2017 07:53 Go to next message
dineshkumar18
Messages: 28
Registered: September 2016
Junior Member
Dears ,

I need to load some data from MSSQL database to Oracle.

Could you please guide me the steps to be followed to establish the connectivity please Cool
Re: Connect SQL Database from Oracle [message #662909 is a reply to message #662908] Mon, 15 May 2017 07:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
dineshkumar18 wrote on Mon, 15 May 2017 05:53
Dears ,

I need to load some data from MSSQL database to Oracle.

Could you please guide me the steps to be followed to establish the connectivity please Cool

Do you desire to push the data from SQL Server to Oracle

or

Do you desire to pull the data to Oracle from SQL Server

From which database is the data transfer initiated?
Re: Connect SQL Database from Oracle [message #662910 is a reply to message #662909] Mon, 15 May 2017 07:59 Go to previous messageGo to next message
dineshkumar18
Messages: 28
Registered: September 2016
Junior Member
Need to Pull the data from SQL to Oracle.

Re: Connect SQL Database from Oracle [message #662911 is a reply to message #662910] Mon, 15 May 2017 08:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://lmgtfy.com/?q=oracle+connect+to+sql+server
Re: Connect SQL Database from Oracle [message #662913 is a reply to message #662911] Mon, 15 May 2017 08:18 Go to previous messageGo to next message
dineshkumar18
Messages: 28
Registered: September 2016
Junior Member
Black Swan : I could do the above search in Google.
Please let me know the one which you have tried and succeeded.
Re: Connect SQL Database from Oracle [message #662925 is a reply to message #662913] Mon, 15 May 2017 13:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A similar question was asked recently; have a look, it contains link to Maaher's detailed description. Although it talks about MS Access and Oracle Forms, steps you need to take are the same (you just wouldn't do the Forms part). Hopefully, you'll make it work.
Re: Connect SQL Database from Oracle [message #662937 is a reply to message #662908] Tue, 16 May 2017 06:33 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
dineshkumar18 wrote on Mon, 15 May 2017 07:53
Dears ,

I need to load some data from MSSQL database to Oracle.

Could you please guide me the steps to be followed to establish the connectivity please Cool
Oracle Transparent Gateway.

You might find this useful in understanding how it works and how the pieces fit together: http://edstevensdba.com/oracle-heterogeneous-communication/oracle-transparent-gateway/
Previous Topic: Oracle for Linux Access SQLserver Through dblink issue
Next Topic: TNS Packet Length
Goto Forum:
  


Current Time: Thu Mar 28 09:27:34 CDT 2024