topic Re: Access table using ABAP program in other database in Application Development and Automation Discussions

Access table using ABAP program in other database

Former Member — Mon, 09 Jan 2012 11:46:36 GMT

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

Re: Access table using ABAP program in other database

nabheetscn — Mon, 09 Jan 2012 11:50:31 GMT

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

Re: Access table using ABAP program in other database

abdulbasit — Mon, 09 Jan 2012 12:10:04 GMT

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

Re: Access table using ABAP program in other database

nabheetscn — Mon, 09 Jan 2012 12:12:16 GMT

Thanks Abdul for the info:)

Nabheet

Re: Access table using ABAP program in other database

Former Member — Tue, 10 Jan 2012 07:19:06 GMT

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

Re: Access table using ABAP program in other database

abdulbasit — Tue, 10 Jan 2012 07:23:18 GMT

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 ?

Re: Access table using ABAP program in other database

Former Member — Tue, 10 Jan 2012 11:38:34 GMT

Dear Abdul,

Thanks for the response

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

Please advice.

Regards

Re: Access table using ABAP program in other database

abdulbasit — Tue, 10 Jan 2012 11:50:09 GMT

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.

Re: Access table using ABAP program in other database

Former Member — Fri, 24 Feb 2012 06:40:26 GMT

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

Re: Access table using ABAP program in other database

AnjaneyaBhardwaj — Fri, 24 Feb 2012 11:38:30 GMT

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 ....