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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads