Home » RDBMS Server » Networking and Gateways » Oracle and SQL Connection (Linux 6.5)
Oracle and SQL Connection [message #657061] Thu, 27 October 2016 05:20 Go to next message
osama.mansoor
Messages: 9
Registered: October 2016
Junior Member
Hi Experts,

I am not from the field of Database but as per my new assignment i to connect Oracle ERP DB with Microsoft SQL Server 2014 Express, i don't to where to start.

below is the information

Machine Information :

Operating System
Oracle Linux

Operating System Release no
Oracle Linux Server release 6.5

Kernel
3.8.13-16.2.1.el6uek.x86_64

Database Version
Oracle Database 11 g Enterprise Edition Release 11.2.0.2.0 64 Bit

Application Version
EBS R12 12.1.3

Enterprise Business Suit
EBS R12


Now I have an HRMS based application which has Microsoft SQL Server 2014 Express DB now I want to connect this DB with Oracle DB (Having Parent Schema) , Please guide me how can I easily achieve this task.
Re: Oracle and SQL Connection [message #657062 is a reply to message #657061] Thu, 27 October 2016 05:27 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Heterogeneous Network Services.
Re: Oracle and SQL Connection [message #657067 is a reply to message #657062] Thu, 27 October 2016 06:24 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
gazzag wrote on Thu, 27 October 2016 05:27
Heterogeneous Network Services.
Isn't that about how to connect oracle to other databases? I think the OP is coming from the other end.
Re: Oracle and SQL Connection [message #657068 is a reply to message #657061] Thu, 27 October 2016 06:27 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
osama.mansoor wrote on Thu, 27 October 2016 05:20
Hi Experts,

I am not from the field of Database but as per my new assignment i to connect Oracle ERP DB with Microsoft SQL Server 2014 Express, i don't to where to start.

below is the information

Machine Information :

Operating System
Oracle Linux

Operating System Release no
Oracle Linux Server release 6.5

Kernel
3.8.13-16.2.1.el6uek.x86_64

Database Version
Oracle Database 11 g Enterprise Edition Release 11.2.0.2.0 64 Bit

Application Version
EBS R12 12.1.3

Enterprise Business Suit
EBS R12


Now I have an HRMS based application which has Microsoft SQL Server 2014 Express DB now I want to connect this DB with Oracle DB (Having Parent Schema) , Please guide me how can I easily achieve this task.
It's not exactly clear what you have in mind, but it sounds like you want to use your normal client tools that connect to SQL Server, and from there be able to connect to an Oracle database. If that is the case, what you want to do is set up a 'linked server' in the MS SQL database. That is really more of a MSSQL question than an oracle one.
Re: Oracle and SQL Connection [message #657069 is a reply to message #657067] Thu, 27 October 2016 06:29 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Ah, quite right, Ed. I misread and misspoke Embarassed

[Updated on: Thu, 27 October 2016 06:29]

Report message to a moderator

Re: Oracle and SQL Connection [message #657246 is a reply to message #657069] Wed, 02 November 2016 07:23 Go to previous message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
Usually I install the 64-bit oracle client on the ms sql server

Custom install
Components:
Oracle Provider for OLEDB (used by linked server)
Oracle Services for Microsoft Transaction Server (to support distributed transactions)
Oracle NET (tnsnames en sqlnet config)
Optional: sql*plus en sqldeveloper for testing connections

After the install: reboot server (fixes registry)

Then you can configure the oracle-linked server
Provider: OraOLEDB.Oracle
Product name: Oracle
Datasource: your TNS-alias for the oracle DB (configured in tnsnames.ora)

You might want to change the settings of the linked server provider Oracle.Oledb:
Allow inprocess: yes
Optional:
Dynamic Parameter: yes
Nested queries: yes
Supports Like operator: yes

Configure securitymapping on the linked server
Previous Topic: TNS protocol packet
Next Topic: sqlnet.expire_time
Goto Forum:
  


Current Time: Thu Mar 28 04:29:52 CDT 2024