obtaining data from SQL Server

[Former Member]

I want to fetch data from SQL Server 2000 database using abap programming and insert it into SAP Database or guide me if any concept is there in SAP to solve this.

[Former Member]

hi,

Check this out

Regards,

Santosh

[Former Member]

thnx 4 ur reply......but i want to directly fetch the data from sql server 2000 database to sap database without using

lasmw & bdc.......can i use BAPI?? or is thr any other concept available in SAP(like idoc,ale etc)....plz clarify my query

[Former Member]

Look at this thread:

[Former Member]

can u give me some more clarified answer wihth code...

[Former Member]

The final post in the above thread has the sample code for retrieving the data from the external database. Add a statement to append the fields to an internal table defined like your transparent table immediately after the FETCH statement.

Once you have data in your internal table, inssert the records into the transparent table using:

INSERT dbtab FROM TABLE itab

where dbtab is your SAP table and itab is the internal table defined like dbtab.

[Former Member]

hello...can i automatically fetch data from sql server to SAP & viceversa....i want tat if the sql server database is updated ...it automatically insert data to SAP database also......tell me if we have to use any SAP concept like BAPI etc.

[Former Member]

In this case, how is the SQL Server database being updated? What application is doing the update?

[Former Member]

I think it is posiible - but you have to use Business Connector or XI.

BR< Jacek