topic How to connect the External Database through ABAP Program in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833167#M921770 <HTML><HEAD></HEAD><BODY><P>Hi Frndz,</P><P></P><P> 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.</P><P></P><P>Thanks,</P><P>Arunprasad.P</P></BODY></HTML> Tue, 20 May 2008 07:00:42 GMT Former Member 2008-05-20T07:00:42Z How to connect the External Database through ABAP Program https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833167#M921770 <HTML><HEAD></HEAD><BODY><P>Hi Frndz,</P><P></P><P> 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.</P><P></P><P>Thanks,</P><P>Arunprasad.P</P></BODY></HTML> Tue, 20 May 2008 07:00:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833167#M921770 Former Member 2008-05-20T07:00:42Z Re: How to connect the External Database through ABAP Program https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833168#M921771 <HTML><HEAD></HEAD><BODY><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5179376"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5337696"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5345350"></A></P><P></P><P>Reward points..</P></BODY></HTML> Tue, 20 May 2008 07:04:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833168#M921771 Former Member 2008-05-20T07:04:15Z Re: How to connect the External Database through ABAP Program https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833169#M921772 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> Check the link</P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5290539"></A></P><P></P><P></P><P>Regards</P><P>Kiran Sure</P></BODY></HTML> Tue, 20 May 2008 07:05:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833169#M921772 Former Member 2008-05-20T07:05:41Z Re: How to connect the External Database through ABAP Program https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833170#M921773 <HTML><HEAD></HEAD><BODY><P>Steps</P><P></P><P>1. Create an entry in tnsnames.ora for the remote oracle DB</P><P>2. Test sqlplus user/pass@remote </P><P>3. create a synonym which points to a table at remote DB check docs.oracle.com</P><P>4. user ABAP code execute SQL to insert data into local synonym which inturn updates the remote DB.</P><P></P><P>Reward points..</P></BODY></HTML> Tue, 20 May 2008 07:05:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-connect-the-external-database-through-abap-program/m-p/3833170#M921773 Former Member 2008-05-20T07:05:59Z