topic Re: Connecting Talend to Azure SQL Database in Talend Studio

Connecting Talend to Azure SQL Database

AManohar — Fri, 15 Nov 2024 21:42:41 GMT

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

Re: Connecting Talend to Azure SQL Database

Anonymous — Thu, 08 Jun 2023 07:11:34 GMT

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

Re: Connecting Talend to Azure SQL Database

Anonymous — Fri, 09 Jun 2023 02:54:34 GMT

Great post, thumbs up！@achen

Re: Connecting Talend to Azure SQL Database

micber — Wed, 24 Apr 2024 16:35:02 GMT

why is it so freaking slow?