topic Re: Read Legacy Database in Application Development and Automation Discussions

Read Legacy Database

former_member189817 — Sat, 15 Aug 2009 11:05:50 GMT

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

Re: Read Legacy Database

Clemenss — Sun, 16 Aug 2009 14:13:07 GMT

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

Re: Read Legacy Database

former_member189817 — Wed, 02 Sep 2009 09:20:48 GMT

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.

Re: Read Legacy Database

former_member189817 — Mon, 05 Oct 2009 11:55:39 GMT

Using third party Software we made Interface between the DBs.