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

Highlighted
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.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.