OraFAQ Forum: Networking and Gateways » Oracle and SQL Connection

Home » RDBMS Server » Networking and Gateways » Oracle and SQL Connection (Linux 6.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle and SQL Connection [message #657061]

Thu, 27 October 2016 05:20

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.

Report message to a moderator

Re: Oracle and SQL Connection [message #657062 is a reply to message #657061]

Thu, 27 October 2016 05:27

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Heterogeneous Network Services.

Report message to a moderator

Re: Oracle and SQL Connection [message #657067 is a reply to message #657062]

Thu, 27 October 2016 06:24

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.

Report message to a moderator

Re: Oracle and SQL Connection [message #657068 is a reply to message #657061]

Thu, 27 October 2016 06:27

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.

Report message to a moderator

Re: Oracle and SQL Connection [message #657069 is a reply to message #657067]

Thu, 27 October 2016 06:29

gazzag
Messages: 1119
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

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

Report message to a moderator

Previous Topic:	TNS protocol packet
Next Topic:	sqlnet.expire_time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 11:13:52 CST 2024