topic Re: [resolved] Connecting to Azure MS Sql database via Talend metadata fails in Talend Studio

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

Anonymous — Tue, 13 Jan 2015 11:50:40 GMT

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

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

Anonymous — Wed, 14 Jan 2015 02:32:32 GMT

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

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

Anonymous — Mon, 26 Jan 2015 20:22:42 GMT

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

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

Anonymous — Tue, 27 Jan 2015 07:26:45 GMT

Hi siddharthk,

Thanks for your feedback and resolved it by yourself.

Best regards
Sabrina