topic Re: Accessing SQL Server from Linux in Talend Studio

Accessing SQL Server from Linux

Anonymous — Fri, 11 May 2012 19:27:53 GMT

What is required by Talend in order to access Microsoft SQL Server from Linux?

Re: Accessing SQL Server from Linux

Anonymous — Mon, 14 May 2012 03:05:50 GMT

Hi
I think this is no matter with OS.
Just create metadata->Connections or use components about SQL Server.
Then configure all parameters correctly, such as Login, Password, Server, Port, DB, Schema and so on so forth.
Feel free to ask any questions if you encounter some errors.
Regards,
Pedro

Re: Accessing SQL Server from Linux

Anonymous — Mon, 14 May 2012 13:40:12 GMT

I need to clarify my question. When a Talend job is exported, a .sh script is created. Part of the job connects to a SQL Server database. My actual question is -- if I run the .sh script from Linux, is there anything else required to make the SQL Server connection, since I am running the script from Linux?

Re: Accessing SQL Server from Linux

janhess — Mon, 14 May 2012 15:39:37 GMT

You need to use SQL server validation rather than Windows validation of login in your database.