topic Re: tMicrosoftCRM not working with online version in Talend Studio

tMicrosoftCRM not working with online version

andymahieu — Mon, 10 Sep 2012 09:47:20 GMT

The input and output components don't seem to work with the online version of microft CRM 2011.
A security token has to be fetched from microsoft ( https://login.microsoftonline.com/RST2.srf) to access your company's CRM before your can actually access the data.
Does anyone have an example job/subjob for this (if it can work this way) ?
When running the tMicrosoftCRMOutput component, you get the following error.
com.sun.xml.internal.messaging.saaj.client.p2p.HttpSOAPConnection post
SEVERE: SAAJ0009: Message send failed
Exception in component tMicrosoftCrmOutput_1

Re: tMicrosoftCRM not working with online version

Anonymous — Tue, 11 Sep 2012 04:52:00 GMT

Hi,
Here is an example how I connect to the online version of microsoft crm 2011.
and the program fetch the token from https://dev.login.live.com/wstlogin.srf.
what kind of authenication on your microsoft crm?

Re: tMicrosoftCRM not working with online version

andymahieu — Tue, 11 Sep 2012 16:46:32 GMT

We have tried the same input as you did and have debugged because we received an authentication error.
We saw that the web service which is used, is the one from ms crm 2007.
We use Talend Open Studio for data integration (the free version).
We should use the new web service of ms CRM 2011 (because microsoft will throw away the old web service with a release update...)
We should use the https://login.microsoftonline.com/RST2.srf because we work in europe. Maybe the other srf works in the US or other countries.
We got the "error Authentication Failure
at org.talend.mscrm.login.passport.SoapExecutor.execute(SoapExecutor.java:80)"
We tried the same message with the program SOAPUI and saw some more info on the error : "the entered password and the stored do not match"
We were able to connect with a tsoap component to the authentication web service. So in fact, we could now make a job which fills the time into the request xml for the security token, then read the response and use the cipher values from the response in another tsoap to the data web service. But that seems a lot of work if we have to do that for every conversion of every table...
Greetings
Andy

Re: tMicrosoftCRM not working with online version

andymahieu — Thu, 13 Sep 2012 07:52:41 GMT

Hi bchen,
I have tried the same setup as in your example and for me, it doesn't work.
The only difference is, that I have to use a crm4 host (for Europe). I have made a special user to test this and included the specs for it. Could you try this on your setup, please. Maybe you have another version of Talend or the component.
I use Talend 5.2.0.M3 and for the component, I have found this info on the version :
VERSION="0.102" STATUS="ALPHA"
COMPATIBILITY="ALL" AUTHOR="Talend" RELEASE_DATE="20070312A"
STARTABLE="true"
Here are my tMicrosoftCrmInput component values
I don't seem to be able to add images to the post, so I give my values here :
Property Type Built-In
Authentication Type ONLINE
OrganizeName "isocabtest"
Gebruikersnaam (user name) "talendtest@isocabtest.onmicrosoft.com"
Wachtwoord (password) "Talend6116"
Host "isocabtest.api.crm4.dynamics.com"
Time out(second) 60
Entity Account
Schema Built-In
Greetings
Andy Mahieu

Re: tMicrosoftCRM not working with online version

andymahieu — Tue, 18 Sep 2012 16:26:33 GMT

If you use the Microsoft CRM hosted on Office 365, then the 2007 Web Services don't work anymore.

See also
http://technet.microsoft.com/en-us/library/gg334316.aspx
There are a few possibilities to solve this :
- ask Talend for a new version of the component
- create a job in Talend with several tSoap components and handle the XML which go back and forth
- use another tool
- do manual imports/updates in Microsoft CRM
Greetings
Andy Mahieu

Re: tMicrosoftCRM not working with online version

Anonymous — Wed, 19 Sep 2012 09:59:44 GMT

Hi andymahieu
Our developer suggests that please report an issue on on bugtracker. We will test this problem further and see what we can do next. Thank you!

Re: tMicrosoftCRM not working with online version

andymahieu — Fri, 05 Oct 2012 08:50:16 GMT

Hi,
I've entered it on bugtracker on 19/09 but I don't get any response. Does anyone have another solution ?
Greetings
Andy Mahieu
Isocab NV
Belgium