Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

populate sql server with data from sap databases:performance tuning

Former Member
0 Likes
426

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
403

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

2 REPLIES 2
Read only

Former Member
0 Likes
403

just a typo PI interface which I intend to use.

Read only

Former Member
0 Likes
404

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