Access table using ABAP program in other database

[Former Member]

Dear SAP Expert,

We have requirement that related to SAP interface.

Our SAP system run on Oracle database 11g (Unix).

Illustration: SAP system = A non SAP system = B

We need to access a table using ABAP program (from SAP system A) in other database (system B) that are not necessarily SAP database. The non-SAP system using SQL Server 2008 (Windows).

What is the best practice for this interface

Do we need database link? If yes, please help to inform me the details step to configure it.

Thanks and Regards

[nabheetscn]

One way is to use the concept of DBCON where we can use native sql..Please search sdn you will get many links for the same...Otherwiese if you have PI also involved than PI can does this work very easily for you

Nabheet

[abdulbasit]

It is not possible to use DBCON table to connect from Unix/Oracle to Windows/SQL Server.

You need to find an intermediate system like PI. If you have a Java Engine installed in your landscape, you can also use this system.

*SAP* >-- web service --> *J2EE Engine* -- JDBC --> SQL Server

[nabheetscn]

Thanks Abdul for the info:)

Nabheet

[Former Member]

Dear Abdul,

Many thanks for your helpfull answer.

How about if we use ODBC mehtod on the client computer? Is it possible?

Thanks and Regards

[abdulbasit]

Can give a little more detail about your solution ? I didn't understand what you mean exactly.

Do you want to use a client computer as an intermediate system, or you want use the ODBC method on the client computer who uses the application ?

[Former Member]

Dear Abdul,

Thanks for the response

Sorry, exactly use the ODBC method on the client computer who uses the application.

Please advice.

Regards

[abdulbasit]

Hi,

I'm not sure if you can use sap gui to make this connection. You still need to write an intermediate program. In that case, you need to deploy this software to all clients which is not meaningful.

The best way in your case seems that, find an intermediate system that you can write a web service and connect to sql server through this service and call this service from ABAP program. You can use an existing Java engine or any other web server in your landscape.

Regards,

Abdulbasit.

[Former Member]

Hi Friend,

You try using an intermediate system..passing your input required to fetch the data..and PI should call the respective query to retrive record..once the full flow is completed you should get the return through some table in the calling program.

else.

ask the other system guy to write a function with select query and ask him to expose as RFC and that RFC we have to call it as RFC in our program to get the required values and only thing we need here is a proper connector in place.

Regards

S.Janagar

[AnjaneyaBhardwaj]

Do you have a PI system ? If yes it is easy to achieve synchronusly or Asynchonusly ..If not, do you have a connection defined between your system and data base system or not .If you have a connection that is existing then you can use the Native SQL to communicate with that DS. You need to have one of these before you use Database table ....