topic Re: SQL database Connection SAP-ABAP in Application Development and Automation Discussions

SQL database Connection SAP-ABAP

Former Member — Mon, 26 Aug 2013 10:52:36 GMT

Hi Expert.

We have create Z program but now We want to connect and read data

to another system database which is created in .NET platform.

Said enhancement sequence is :

1) connection of other system database ex.(.NET platform).

2) Read data from that Database and save in SAP Internal Table.

Regards.

Pradip Patel.

Re: SQL database Connection SAP-ABAP

Former Member — Mon, 26 Aug 2013 13:53:42 GMT

Hi Parpid,

connection from ABAP to the external DB can be done via dblink. Take a look here:

http://scn.sap.com/message/5179376

Paul

Re: SQL database Connection SAP-ABAP

Former Member — Tue, 27 Aug 2013 03:54:04 GMT

Hi Paul,

Thanks for reply. Here I am confuse, Actually I want to connect other database from SAP ABAP program and read data from that data base and insert in to SAP Z table.

If possible then explain with Example.

Regards.

Pradip Patel.

Re: SQL database Connection SAP-ABAP

Former Member — Tue, 27 Aug 2013 04:26:03 GMT

Have you considered connecting to the other system via webservices? That way you don't need to worry about the database and will just connect on the application level. Then if the .net application moves to another database, you are not affected.

Once the webservice is exposed from the .net application, you can use the following doc to step you through the process: