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

Five Stars

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

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

Accepted Solutions
Five Stars

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

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

All Replies
Moderator

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

Hi,
Could you please show us your Azure MS Sql database metadata setting? How did you set JDBC URL in metadata?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

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

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

Hi siddharthk,

Thanks for your feedback and resolved it by yourself.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.