How to use connection created in Talend Cloud in Talend Studio?

Highlighted
Seven Stars

How to use connection created in Talend Cloud in Talend Studio?

Hi 

 

In Talend Cloud, I can create connection following this link. https://help.talend.com/reader/4ghjK9KsJCzsAAqMsfGL3g/Are5DmWDvv52AAyx7yZX4w 

 

How can I utilize the Cloud configured connection in a Talend Studio job? The goal is not hard coding credentials in the code. Previously I load credentials from the encrypted external file.

 

Thanks,

Bin

Moderator

Re: How to use connection created in Talend Cloud in Talend Studio?

Hello,

Sorry for our silence. We do our best to answer as many posts as possible.

We have redirected your issue to talend cloud experts and then come back to you as soon as we can.

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.
Nine Stars

Re: How to use connection created in Talend Cloud in Talend Studio?

Hi,

If this is a connection, for an application not listed, select the application  as "Custom", then add a short name for the application type  say "SQLServer". Add all of the required attributes for a SQL Server connection, along with the values you need - all this in TMC.

 

In studio, create context variables called "connection_SQLServer_{property}", example connection_SQLServer_Server. Add all of these to the connection component. Once you published the job to the cloud, and go back to TMC to run it, the Configuration section will request the Connection details, select the one you set up. This should then pass the values in to the job and the job can make the connection.

 

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend Cloud Available on Microsoft Azure

An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources

Watch Now

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog