[resolved] [V5.6.2_20150508_1414] tMicrosoftCrmInput online

One Star

[resolved] [V5.6.2_20150508_1414] tMicrosoftCrmInput online

Hi,
I'm using Talend Open Studio for integration V5.6.2_20150508_1414.
I want to use the tMicrosoftCrmInput component with a online CRM Dynamics database.
I can to connect in a database in "ON_PREMISE" mode, but not in "ONLINE" mode.
In the parameters fields, I put :
Type : ONLINE
Version : V2011
Organisation : orga4bc3228
User : name@AMELIS.onmicrosoft.com
Pass : Password
Discovery service endpoint :
I tested differents url :
https://disco.crm4.dynamics.com/XRMServices/2011/Discovery.svc
https://testdeveloppement.api.crm4.dynamics.com/XRMServices/2011/Organization.svc
https://testdeveloppement.crm4.dynamics.com/XRMServices/2011/OrganizationData.svc

But the result is still error :
Démarrage du job Test3 a 14:25 06/08/2015.
connecting to socket on port 3624
connected
Exception in component tMicrosoftCrmInput_1
java.net.ConnectException: Connection timed out: connect
at java.net.TwoStacksPlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.<init>(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at org.talend.ms.crm.sdk.OnlineAuthenticationPolicy.DownloadWsdlInToString(OnlineAuthenticationPolicy.java:221)
at org.talend.ms.crm.sdk.OnlineAuthenticationPolicy.initialize(OnlineAuthenticationPolicy.java:105)
at org.talend.ms.crm.sdk.OnlineAuthenticationPolicy.<init>(OnlineAuthenticationPolicy.java:38)
at org.talend.ms.crm.MSCRMClient.getOnlineConnection(MSCRMClient.java:115)
at projectname.test3_0_1.Test3.tMicrosoftCrmInput_1Process(Test3.java:4569)
at projectname.test3_0_1.Test3.runJobInTOS(Test3.java:6468)
at projectname.test3_0_1.Test3.main(Test3.java:6325)
disconnected

My parameters fields are correct ?
Thanks for your help.

Accepted Solutions
One Star

Re: [resolved] [V5.6.2_20150508_1414] tMicrosoftCrmInput online

Hi,
The problem was the network.
With 3G connection, it's works !
Thank's for your help.

All Replies
Moderator

Re: [resolved] [V5.6.2_20150508_1414] tMicrosoftCrmInput online

Hi,
Have you already checked component reference about: TalendHelpCenter:tMicrosoftCrmInput?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] [V5.6.2_20150508_1414] tMicrosoftCrmInput online

Hi,
Yes, but examples are only ON_PREMISE mode.
This mode works.
Best regards.
Seventeen Stars

Re: [resolved] [V5.6.2_20150508_1414] tMicrosoftCrmInput online

Mode ONLINE means you use the Microsoft hosted CRM. Is this the case in your environment?
The error message is quite clear, it says the network TCP/IP connection cannot be established, means it is for sure a misconfiguration or network infrastructure problem.
One Star

Re: [resolved] [V5.6.2_20150508_1414] tMicrosoftCrmInput online

Hi,
The problem was the network.
With 3G connection, it's works !
Thank's for your help.
Moderator

Re: [resolved] [V5.6.2_20150508_1414] tMicrosoftCrmInput online

Hi lecraverf,
Could you please mark this topic as resolved? You can click the "Set this topic as resolved" link which is right underneath your initial post.

Many thanks!
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch