Read Legacy Database

[former_member189817]

Hi,

I am into functional side need information about SAP - Legacy integeration.My requirment is I want to pull the data directly from Legacy DB instaed of downloading it as flat file.Similar way wan to writel the data into Legacy DB. Pls anyone suggest me best way interfacing methodolgy for this scenario.

Thanks in Advance,

Velmurugan S

[Clemenss]

Hi Velmurugan,

direct access of external legacy database is possible through native SQL from ABAP using comands like

EXEC SQL. 
  CONNECT TO dbs [AS con] 
ENDEXEC.

Effect

This native SQL statement starts a connection to the database system dbs and makes this the current connection - that is, all the following native SQL statements work with the database system named in dbs. If a connection to the specified database system already exists, then this is used; otherwise, a new connection is set up.

But I would not recommend to do it thisway except for extremely simple purposes.

Usually the permanent interaction between SAP and legacy system should be implemented using IDOC (best) or BAPI.

Regards,

Clemens

[former_member189817]

Hi Clemens Li ,

Thanks for your reply,We alraedy tried this Native SQl using DBCO,But worst thing is our Application server is running on UNIX server which is not supported by SAP. So we are looking for alternate method.Pls tell me any other way to do this.

[former_member189817]

Using third party Software we made Interface between the DBs.