Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
alexhug
Contributor
Contributor

Connecting to Navision with NTLM via Webservice (WSDL) failed

Hello, 
I'm setting up an integration for Microsoft Dynamics NAV (Navision).
Direct connection to the MS-SQL database works fine and fast.
We also have to connect to NAV via webservices (in order to run some business logic). Important: the webservice authentication scheme uses NTLM. 
The corresponding WSDL is valid, can be imported into Talend w/o any problems or any SOAP client. The SOAP client is aware of NTLM authentication scheme, login credentials are correct. Can also be checked by pasting the endpoint URL to a web browser.
But I can not connect to the Webservice from Talend, I receive an authentication error:
Exception in component tWebService_1: org.apache.cxf.binding.soap.SoapFault: The login failed when connecting to SQL Server XXXX.
I tried all combinations of "Use NTLM" checkbox, Domain, Username, Domain+Username, ... but connection always fails.
I also tried with ntlmauth.dll, but no result (Windows log in credentials are different from Webservice)
Is there a way to let Talend talk to NAV via Webservices?
System information:
Windows Server 2012 R2
Talend 6.2.1, 6.3.0 (tried both)
JDK 1.8 (x64)
Bg Alex
Labels (3)
1 Reply
Anonymous
Not applicable

Hi,
Have you already checked tSoap component to achieve your goal to see if it works well? Which  calls a method via a Web service in order to retrieve the values of the parameters defined in the component editor.
Best regards
Sabrina