[resolved] Connecting to Azure MS Sql database via Talend metadata fails

[Anonymous]

Hi All
We need to use Talend open studio to extract data out of an Azure Sql Database - do some transformations and then insert it back to an azure Sql database.
If I create a Sql Server connection metadata to Sql Server 2014 database everything is pretty straight forward. However when I modify the connection metadata to point to the Azure database it fails.
I am aware of some post regarding this but nothing is clear in pointing to the right solution.
Anyone has a clear solution or pointers
Regards
Sid

[Anonymous]

Hi,
Could you please show us your Azure MS Sql database metadata setting? How did you set JDBC URL in metadata?
Best regards
Sabrina

[Anonymous · Accepted solution]

This is resolved. Changes the database components from sql server components to JDBC

[Anonymous]

Hi siddharthk,

Thanks for your feedback and resolved it by yourself.

Best regards
Sabrina