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

[wangbinlxx]

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

[Anonymous]

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

[David_Beaty]

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.