idoc to third party software

[Former Member]

hi expects,

i have problem importing the data from sap sytem by using idoc to third party software where backend client is having SQL server.please help solving this problem.

[Former Member]

HI Sant Kumar,

Your requirement is not clear. Explain little bit clear.

If my understanding is correct, You want to send the Data from R/3 system to Thirdparty system which is running on SQL Server?

Then you can use Idoc as sender and use the JDBC adapter at the receiver side. For this you need to deploy the Database drivers in the PI Server and use the logon credentials in the Receiver communicaiton channel to update the database.

At the sender side you don't need to create the sender communication channel in XI. You need to do the ALE setting in the R/3 system as well as in the XI System like creating RFC destination , Port Creatin and Partner profile.

Thanks&Regards

Goli Sridhar

[former_member537867]

Hi Kumar,

First for sending IDoc to XI we need to write one ABAP program to trigger the IDoc.We will create the Port and partner profiles based on that the XI takes the IDoc.As per your problem if u hab=ve problem in importing data from SAP try to check the connections working fine like RFC destinations..

For sending IDOCs u can schedule report RSEOUT00.

We will write the update SQL statement in the Receiver Communication channel if u wnt to update the DataBase.

Refer this blog

Recent Enhancements to JDBC Adapter:

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

The above document gives a good insight towards the understanding of the JDBC adapter.

Regards,

Vinod.