populate sql server with data from sap databases:performance tuning

[Former Member]

Hello,

I need to populate sql server non sap database with data from sap databases. i have heard that, I can use ri, xi technology. Please help me, if possible provide code to me or some helpful links.

Also. I need to take care of performance issues while populating data. data fetch and insertion should not take extra time

Thanks and Regards,

Sameer.

[Former Member]

Hi,

To populate the data you need to first create all the tables etc. SAP database can be in SQL Server, Oracle, DB2 etc. What exactly you wants to do ? SAP-XI (or PI) is an integration tool that is used for interfacing two application. There are ADAPters in XI using which you can generate XML messages and consume them in your application

[Former Member]

just a typo PI interface which I intend to use.

[Former Member]

Hi,

To populate the data you need to first create all the tables etc. SAP database can be in SQL Server, Oracle, DB2 etc. What exactly you wants to do ? SAP-XI (or PI) is an integration tool that is used for interfacing two application. There are ADAPters in XI using which you can generate XML messages and consume them in your application