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

[Former Member]

Dear all,

how to pull the external data form the sql server

and verify with the sap data while creating dc.

Thanks & Regards

Guhapriyan

[Former Member]

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

[Former Member]

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