Talend Data Integration + Dynamics 2015

[Anonymous]

Hello!
I have a problem connecting Talend Data Integration (Open Studio version) together with Microsoft Dynamics 2015, and I would like to ask the Talend Pros for help...
My company is running On-Premise version of CRM 2015, installed on multiple servers. What I'm trying to do right now is to create a Talend job to export data from said CRM, using tMicrosoftCRMInput component. Unfortunately, after filling the settings required for tMicrosoftCRMInput and starting the job, I'm receiving following error:

INFO: Can not initialize the default wsdl from classpath:wsdl/OrganizationService.wsdl
: org.apache.cxf.ws.policy.AssertionBuilderRegistryImpl - No assertion builder for type {}AuthenticationPolicy registered.
: org.apache.cxf.ws.policy.AssertionBuilderRegistryImpl - No assertion builder for type {}NegotiateAuthentication registered. : org.apache.cxf.ws.policy.AssertionBuilderRegistryImpl - No assertion builder for type {}RsaToken registe

To see the whole post, download it here

[Anonymous]

Hi,
On which build version you got this issue?
Could you please post your job setting screenshot into forum which will be helpful for us to address your issue?
Best regards
Sabrina

[Anonymous]

Certainly, here is my job settings screenshot.
 

Trust certificate is empty, we do not use it from what I know. I'm using Talend 6.1.1 , build version is on the screenshot.
Thank you very much!

[fbt]

Hello,
I have exactly the same issue with TOS 6.2.1 built 20160704_1411, does any one has found a solution ?

[Anonymous]

Sorry to say that, but no... We gave up and found another way to connect and import data to Dynamics.

[fbt]

Witch way did you use, if you can tell me ? I saw an open jira on this issue , but it's on hold for a while...
To be honnest, it's quite a shame this component doesn't work. I used to work with Talend for a while in my previous job, and as I just changed and we're looking for an etl, this failing component isn't a good advertising at all.
Having integrated components for business applications is a great added value, if they don't work it's worse than not having them...

[Anonymous]

You are right, we were rather dissapointed about this product. One could say that this is free software with many other components (which are probably working) and that Dynamics is not the easiest to work with using 3rd party tools, but still it is dissapointing...
Anyway, we dropped Talend and used KingswaySoft Microsoft Dynamics CRM Integration Software plugin for SSIS. The developer license is free, but if you want to use it on production enviroment you have to pay for the license. You can read about it on their website.
There is also another way. Both Talend and KingswaySoft work using package transfer of data, so they have to be fired up by some kind of scheduler (be it SQL job, system scheduler or Talend internal scheduler) to import/export data. If you want to have instant connection and data transfer, you can connect directly to the Dynamics CRM webservice. This requires some coding skills and knowledge about Dynamics CRM webservices, but it is doable. We are preparing such solution right now and it works very good. You can find all necessary information on the MSDN and/or Technet.
Hope this helps. Sorry, but I cannot help You more with Talend. I can only suggest looking at KingswaySoft, I know this one works fine.
Cheers!

[fbt]

Thanks for your answers, I'll have a look to KingswaySoft. Handling webservices from Talend isn't a problem for me, but I'm gonna have to find informations on Microsoft CRM side... Once again, what a shame theses Talend components doesn't work as they should...
I was doing a proof of concept with TOS, but we would have bought TIS for DI if every thing had been all right, but it's a big fail...