Connecting and Updating External Database from SAP

[Former Member]

Connecting and Updating External Database from SAP

How can i connect SAP Database to External database?

How can i update external databas from SAP withouting using BI/BW, Workflow or Net Weaver?

If anyone know please let me inform.

Thanks in Advance.

Jahnavee Trivedi

[Former Member · Accepted solution]

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.

I have done this in the past, it works great.

It requries, DBA skills + ABAP programming

-AJ