Skip to Content
author's profile photo Former Member
Former Member

ECC 6.0 integration with MS Dynamics CRM 2011 on-demand thru PI

Hi Gurus,

sorry in advance if some of my doubts will appear to you experts as stupid....

Scenario: we're on the way to realize the integration between SAP ECC and Microsoft Dynamics CRM Online (so...in the cloud) using SAP PI 7.11. In our scenario SAP PI will be the client, consuming webservices provided by MS CRM.

Unfortunately during the PI configuration (following SAP HELP instructions) we're facing the following problems:

1. The system (PI, dual-stack installation) has the parameter 'ssl/pse_provider' set to 'ABAP'. Considering that we would like to use SSL with SOAP adapter, questions are:

- Can we use the ABAP stack to maintain the PSEs, or it's mandatory to do it into the AS Java in order to use SSL with SOAP adapter.

- If so, we need to switch the ssl/pse_provider parameter to JAVA. Could this change create some kind of problems?

For information, currently in transaction STRUST we only have a Local node, neither Server nor Client nodes.

2. We have already installed the SAP Cryptographic Library for SSL but:

- In NWA we can't find ICM_SSL_<instance_ID> view or CLIENT_ICM_SSL_<instance_ID> keystore view into the list of Keystore Views.

- We would like to change the default Profile into RZ10 but we Can't find the profile...

- MS CRM (ws server) give us only a public certificate but do we need a private key too or we have to generate it from SAP?

- We need to know if is possible to use the MS 'LIVEID' authentication with SAP PI or SAP ECC.

- Do we need additional modules for the SOAP adapter(maybe an Axis one in order to use soap protocol 1.2)?

Could you please suggest the right configuration and give us some tips about this kind of integration?

Thanks a lot,

MR

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2013 at 06:46 AM

    Hi Mauro,

    Can you please share the information if you have received any regarding the integration with MS Dynamics CRM using PI.

    Thanks In Advance.

    Regards

    Swetha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 01, 2013 at 12:57 PM

    Hi Mauro,

    Looking at your background I thought maybe you could help me out wit this integration question.

    I'm looking for some feedback on how best to integrate Microsoft Dynamics AX (DAX) with SAP CRM. We have a PI server.

    From reading on the net, I see many people are using a middleware product called Scribe or BizzTalk. We already made an investment with SAP PI and we'd like to use it.

    Do you have any references for Microsoft DAX integration with SAP CRM via SAP PI/ XI?

    Thanks in advance!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Ellery,

      according to my poor background, mainly the problem is to deal with a .NET system (CRM) using a Java system (PI), and this complicated by the fact that with CRM on demand you have to manage different step to be performed before integrating the data (including the authentication that is not basic..), meaning that you need to invoke several Web Services before being able to post the data.

      In fact most of the people in "our situation" is using biztalk because MS CRM SDK comes with a set of .NET classes and methods that can be used out of the box by Biztalk to easily manage all the mentioned steps...and even easier with Scribe where all is already available by standard.

      Not impossible to use PI for the integration with MS CRM, but you have to orchestrate (creating proper PI developments) the following steps:

      1. Connection to CRM (passing thru Live/Office365 to get the token..)

      2. Invoke the CRM Discovery Service to get the available CRM Services

      3. Invoke the CRM Metadata Service to get the "WSDL" for the choosen service

      4. In case consume other services to get the situation into CRM and properly manage deltas

      5. finally...Invoke the CRM service to post the data

      Good luck...let me know if you succeed with this...let's say....oppurtunity!

      Ciao

  • author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2013 at 09:32 AM

    Hi Mauri,

    Thanks for your response! Does this also apply to the integration of Microsoft Dynamics AX with SAP CRM on premise via SAP PI/ XI?

    Thanks in advance!

    Ciao - Ellery

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 12, 2014 at 09:05 AM

    Hello,

    has anybody found a solution for consuming the standard webservice of Microsoft Dynamics CRM online (cloud) directly or via SAP PI in the meantime?

    As we want to import data from MS CRM online (cloud) into our SAP BW I have the same problems described above.

    For example it is not possible to create the logical port in the Soamanager based on the WSDL (URL or file) of the addressed system (not the "pre-" disco-URL of MS Office 365); I have taken the WSDL that can be found in the Developer Ressources of the MS CRM system and additionally uploaded the security certificate of the WSDL and the Windows azure security certificate with SE59.

    So my question is, has anybody successfully inplemeted a SAP based solution (directly or via SAP PI, without BizzTalk or Scribe) to consume the standard MS webservices for MS CRM online (cloud).

    Thanks,

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

    • Yes as Santosh mentioned advanto dynamics crm adapter is the best bet for sap pi. This has inbuilt workbench which has most of the predefined schemas for usage.

      Else one more old way I known of is using scribe.

      Scribe I had used very long back where in this acts as a layer between pi and crm. In scribe IIS is installed and it acts as MS Message Queues. PI can connect to scribe using JMS adapter as well by using http adapter.

      Regards

      Senthilprakash

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.