Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL database Connection SAP-ABAP

Former Member

‎2013 Aug 26 11:52 AM

0 Likes
697

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. 

3 REPLIES 3
Read only

Former Member

‎2013 Aug 26 2:53 PM

0 Likes
523

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

Read only

Former Member
In response to Former Member

‎2013 Aug 27 4:54 AM

0 Likes
523

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.

Read only

Former Member

‎2013 Aug 27 5:26 AM

0 Likes
523

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: