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|
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|
"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