Featured Post

Applying Email Validation to a JavaFX TextField Using Binding

This example uses the same controller as in a previous post but adds a use case to support email validation.  A Commons Validator object is ...

Tuesday, May 20, 2014

Talend to MS SQL with Windows Authentication

To connect a Talend integration job to MS SQL Server using Windows Authentication, use the tOleDbInput component rather than the tMSSqlInput.  You'll need to put some DLLs on the system running Talend.

Connecting Talend to MS SQL Server using Windows Authentication removes the need to store a username / password along with the Talend job.  However, to do this, you'll need to add some DLLs to your system.  Visit this link and download the referenced .dll files to a folder

Introduction to using .NET in Talend Open Studio

You'll then configure the Run tab in Talend to set the JVM system property "java.library.path".

JVM Parameters Referencing DLLs for tOleDbInput
The folder D:\\janet-dlls_40 contains the .dll files from the download.

Next, you'll configure a connection string for the SQL Server instance.  Note that there is no username / password in the job as is common with other datasource components.

Connection String Used in tOleDbInput
Here is the same connection string presented in the above image

"Provider=sqloledb;Data Source=ASUS-PC\\SQLEXPRESS; Initial Catalog=bekwamdb;Integrated Security=SSPI;"

I recommend testing Windows Authentication using SQL Server Management Studio prior to working with Talend.  If there's a misconfiguration of the connection string, you won't get much information back.  Looking at Management Studio
  • Data Source is Server Name
  • Initial Catalog is Database

No comments:

Post a Comment