cancel
Showing results for 
Search instead for 
Did you mean: 

How to integrate MSSQL server with SAP CRM via XI? Please help!

Former Member
0 Kudos

Hi Experts,

I have a requirement where I have to pull the data from MSSQL server and send it to SAP CRM.

What are the different options avaiable with or without adapter to send data from MSSQL server to XI?

As per my understanding I have following options:

1. JDBC driver.

MSQL ---> JDBC adapter ---> XI

2. Create webservice for the XI outbound interface (Sender interface) and call it from MSSQL stored procedure.

MSQL ---> SOAP adapter ---> XI

2. Create webservice for the XI outbound interface (Sender interface) and call it from a .Net program.

MSQL ---> DotNet application --> SOAP adapter ---> XI

Which option is the best?

Please help.

Thanks

Gopal

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Kindly refer:

/people/ted.teng/blog/2005/12/28/use-sql2005-to-connect-and-present-sap-on-sharepoint-business-scorecard-manager-150-part-i

Hope this might be of some use to you...........

Former Member
0 Kudos

Hi,

If Your Sender Application is able to Expose their application as Web Service means it is better to make a Web service call From Sender to to XI and send the data to XI.

Otherwise Use JDBC Adapter to pull the data from Dbase & there by send it to XI

SOAP Adapter can handle large Messages & SOAP Attachments also

Choose as per your Convinient

Regards

Seshagiri

Edited by: N V Seshagiri on Sep 22, 2008 10:48 AM