Connecting Talend to Azure SQL Database

[AManohar]

Hi,

I'm trying to connect to Azure SQL DB from Talend 7.3 studio.

Need some help on how to connect to Azure .

Regards,

Anitha

[Anonymous · Accepted solution]

Hello @Anitha Manohar​ ,

As Azure SQL database is one type of SQL Server db. so that you can consider it as the DB Type of 'Microsoft SQL Server' ,

Go to the Azure SQL database /Connection strings/JDBC page like the below.

Fetch the server/login/password ... information form above string.

Then in the talend studio, Create a Medata/DB connectoins , select 'Microsoft SQL Server' Db Type, fill the related db server/login/password ... like the below

BTW: you need to whitelist studio machine ip to allow public access in the Azure SQL Server /Security/Networking firewall rules like the below

Best regards

Aiming

[Anonymous]

Great post, thumbs up！@achen

[micber]

why is it so freaking slow?