Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

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

View solution in original post


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

View solution in original post

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog