Connecting to a different database

[Former Member]

Hi,

I need to retrieve the data from non-sap databse.Its an another ORACLE System.

In our SAP also the back end is Oracle only.

Now i need to retrieve all the data from a table which was in another DB.How to connect that.

Can anyone help me in this regards.

[Former Member]

Hi,

I need to retrieve the data from non-sap databse.Its an another ORACLE System.

In our SAP also the back end is Oracle only.

Now i need to retrieve all the data from a table which was in another DB.How to connect that.

Can anyone help me in this regards.

[SuhaSaha]

You should check the ADBC classes available. (CL_SQL* classes)

The program ADBC_DEMO should be of some help.

BR,

Suhas