Accessing SQL Server from Linux

One Star

Accessing SQL Server from Linux

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

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
One Star

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?
One Star

Re: Accessing SQL Server from Linux

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog