SQL database Connection SAP-ABAP

[Former Member]

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. 

[Former Member]

Hi Parpid,

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

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

BR

Paul

[Former Member]

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.

[Former Member]

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: