Direct Database Access

[Former Member]

We are running SAP myERP 2004. The database is Oracle.

I need to extract data from the Oracle database and populate some tables in SQL Server 2000.

Could someone advice how I can access the Oracle database directly? Thanks.

[Former Member · Accepted solution]

Hi Justin,

Talk to your BASIS and get access to the Oracle database. You would need the Oracle frontend on your system and then it is normal way of accessing the tables.

If your tables are transparent you can also access the tables from the SAP GUI from SE11 by giving the table name.

Bye

Dinesh

[Former Member]

Hi Justin,

This following forum links might be useful for your scenario...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.highlightedcontent?documenturi=...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.highlightedcontent?documenturi=...

Thanks,

Raj

Message was edited by: Raj

[Former Member]

Justin Tan,

My be you want to check help on ABAP EXEC SQL..

EXEC SQL.

• My SQL Query for Oracle..

ENDSQL.

Regards,

Hari

[Former Member]

Justin Tan,

My be you want to check help on ABAP EXEC SQL..

EXEC SQL.

• My SQL Query for Oracle..

ENDSQL.

Regards,

Hari

[Former Member]

Thanks. If I use EXEC SQL, is it possible for ABAP to connect to SQL Server and populate the table?

[Former Member]

I do not know for SQL server.. But I have done for Oracle it works fine..

Regards,

Hari