topic Re: populate sql server with data from sap databases:performance tuning in Application Development and Automation Discussions

populate sql server with data from sap databases:performance tuning

Former Member — Tue, 28 Apr 2009 08:03:59 GMT

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.

Re: populate sql server with data from sap databases:performance tuning

Former Member — Tue, 28 Apr 2009 08:38:15 GMT

just a typo PI interface which I intend to use.

Re: populate sql server with data from sap databases:performance tuning

Former Member — Wed, 29 Apr 2009 07:18:39 GMT

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