How to connect internal Oracle DB on SAP and external MS SQL DB (DB link)

[former_member311323]

We are using SAP on AIX Operating System, and Database is configured as Oracle DB in the SAP System.
There is MS SQL database additionally. We want to connect Oracle DB on SAP and additional MS SQL DB.
How to connect to MS SQL Database and Oracle DB on SAP System?
Actually I checked DB library files on the SAP System, and I found library files just for Oracle DB. I tried to find library files for MS SQL DB on AIX Operation System to connect the DB. However, The answers about my questions on websites were No MS SQL DB library files for AIX Operating System.

1. No library files for MS SQL DB on AIX Operating System?
2. Are there any other solution for DB link connection between internal Oracle DB on SAP and external MS SQL DB ?

The following is our SAP system structure and MS SQL DB structure map.

[former_member189725]

You can install a dialog instance on windows for the  system with CI on AIX , follow the SAP note Note 1148109 - Heterogeneous Inst.(Appl. Server Windows, DB Unix)

for this.

On the dialog instance , have the MS SQL server DBSL along with the SAP kernel on Windows OS. Then you can connect to the external SQL server using the database connectivity feature.

Regards

Ratnajit

[Former Member]

Hallo,

maybe this thread regarding transaction DBCO and SQL server helps?

http://scn.sap.com/thread/1794452

Regards,

Thomas.