How to connect the External Database through ABAP Program

[Former Member]

Hi Frndz,

My requirement is that i have one device which has database and i want to access that database through SAP ABAP program....i want to kno the steps how to connect tht sys which is available in network ..... plz give me the step by step solutions or some link.

Thanks,

Arunprasad.P

[Former Member]

Reward points..

[Former Member]

Hi,

Check the link

Regards

Kiran Sure

[Former Member]

Steps

1. Create an entry in tnsnames.ora for the remote oracle DB

2. Test sqlplus user/pass@remote

3. create a synonym which points to a table at remote DB check docs.oracle.com

4. user ABAP code execute SQL to insert data into local synonym which inturn updates the remote DB.

Reward points..