topic Re: DATABASE LINK FOR SQL SERVER in Application Development and Automation Discussions

DATABASE LINK FOR SQL SERVER

Former Member — Mon, 12 Sep 2005 02:53:21 GMT

Hi all,

We are running SAP 4.7C with oracle database. For other oracle (non-sap) we are using DBCO to get/put data. Now we have to do the same in SQL server also. In addition to SAP standard table we are sending data of customer table (Z & Y series). Can anybody guide me how to send / receive data using bapi/rfc or some other method.

regards

balakumar

Re: DATABASE LINK FOR SQL SERVER

Former Member — Mon, 12 Sep 2005 03:09:31 GMT

Hi!

See OSS notes 178949 and 738371.

Regards,

Maxim.

Re: DATABASE LINK FOR SQL SERVER

Former Member — Mon, 12 Sep 2005 04:14:10 GMT

Thanks Maxim,

I have gone thru the notes. But both the notes are insisting the OS should be window base. But we are using unix base oracle not window base.

Regards

balakumar

Re: DATABASE LINK FOR SQL SERVER

Former Member — Mon, 12 Sep 2005 05:24:53 GMT

Hi!

For using native-SQL with MSSQL database you have to make your database requests from application server resides on windows platform. So, your basis people have to set up one more windows-based application server instance. There is no impact on backend R/3 database.

Regards,

Maxim.