Home » RDBMS Server » Networking and Gateways » Oracle to Sql server (12c)
Oracle to Sql server [message #681615] Sun, 09 August 2020 05:10 Go to next message
mdarifdxb20
Messages: 5
Registered: August 2020
Junior Member
i want to build connectivity between sql server and oracle 12 db , like tables from both the databases need to interact like we need to wrtie data from sql server to Oracle and from oracle to sql server. Initially i thought of using ORDS to do this. Do we have a method .
Re: Oracle to Sql server [message #681620 is a reply to message #681615] Sun, 09 August 2020 06:48 Go to previous messageGo to next message
EdStevens
Messages: 1248
Registered: September 2013
Senior Member
If you want MSSQL to act as a client to oracle, you use MSSQL 'shared server'. If you want oracle to act as a client to mssql, you use oracle 'database link'.
Re: Oracle to Sql server [message #681627 is a reply to message #681615] Sun, 09 August 2020 08:33 Go to previous messageGo to next message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
When you say "ORDS", do you mean using REST enabled SQL? The developers I work with love it, but I do not know if it works against a SQL Server.
Re: Oracle to Sql server [message #681635 is a reply to message #681620] Mon, 10 August 2020 22:56 Go to previous messageGo to next message
mdarifdxb20
Messages: 5
Registered: August 2020
Junior Member
I mean it will be both ways, we may have to send data from Sql server to Oracle and from Oracle to Sql server.
It will be two way commuication. For example when there is a new record created in customer master table in oracle table data from oracle table needs to be pushed to sql server table customer info. Similarly when there is a change in payment transaction at sql server table payment_info the same needs to be pushed to Oracle.
Re: Oracle to Sql server [message #681636 is a reply to message #681635] Mon, 10 August 2020 22:57 Go to previous messageGo to next message
mdarifdxb20
Messages: 5
Registered: August 2020
Junior Member
HI John,

Yes i meant the Rest services only. Can i utilize that feature for this purpose.
Re: Oracle to Sql server [message #681638 is a reply to message #681636] Tue, 11 August 2020 01:08 Go to previous messageGo to next message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
Do you know what REST Enabled SQL is?
Re: Oracle to Sql server [message #681645 is a reply to message #681638] Wed, 12 August 2020 05:39 Go to previous message
mdarifdxb20
Messages: 5
Registered: August 2020
Junior Member
No i dont have any idea on this.
Previous Topic: Intermittent Error ORA-28500 + ORA-28511
Next Topic: Database link with proxy user
Goto Forum:
  


Current Time: Sat Sep 19 20:41:19 CDT 2020