• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Accessing SQL Server from Linux

#1 2012-05-11 20:27:53

gmorey
Member
Registered: 2011-04-14
Posts: 44

Accessing SQL Server from Linux

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

Offline

#2 2012-05-14 04:05:50

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Accessing SQL Server from Linux

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


Only Paranoid Survive.

Offline

#3 2012-05-14 14:40:12

gmorey
Member
Registered: 2011-04-14
Posts: 44

Re: Accessing SQL Server from Linux

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?

Offline

#4 2012-05-14 16:39:37

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1121

Re: Accessing SQL Server from Linux

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

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Accessing SQL Server from Linux

Board footer

Powered by FluxBB