topic Re: How to pull data from external sql server to SAP for verification. in Application Development and Automation Discussions

How to pull data from external sql server to SAP for verification.

Former Member — Sat, 14 May 2005 11:27:09 GMT

Dear all,

how to pull the external data form the sql server

and verify with the sap data while creating dc.

Thanks & Regards

Guhapriyan

Re: How to pull data from external sql server to SAP for verification.

Former Member — Sat, 14 May 2005 15:27:20 GMT

Dear GS,

I assume you need to check some data which is in SQL SERVER with some data in your SAP.

If above is your need, you can get data downloaded from SQL SERVER in ASC or any other format. Taking same data through Upload in SAP you can verify with data in SAP and show what error you get.

Second if you dont want to download and eventhen check, i'll say you to go for BAPI Objects. I dont know much about BAPI, just that you can create a BAPI Object which you can use with other application to interact with SAP.

Hope this helps. For anyting else do msg back.

Raj

Re: How to pull data from external sql server to SAP for verification.

Former Member — Mon, 16 May 2005 18:29:22 GMT

Try the following link has details on how you can connect and query additional databases.

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm">Native SQL-Click Here</a>

Rishi