topic Re: Create context group for DB connections in Talend Studio

Create context group for DB connections

Anonymous — Mon, 05 Jun 2017 05:32:12 GMT

Hi,

I need to create separate context groups for each of the environments - DEV, SIT, UAT, PROD so that each context group has its own database connection details. I should be able to switch across the environments easily without having to change the DB connection details again & again. Can somebody plz help out here

Re: Create context group for DB connections

TRF — Mon, 05 Jun 2017 08:24:42 GMT

Hi,
In the repository, add a context folder nammed "DB" for example, then create the desired variables such as "username", " password", "server" and so on. Add as many group context as needed (DEV, UAT, PROD) and set the value for each variable in each context.
After saving, open the jobs and drag and drop the new context group into the job context.
This is the basic approach. You can also defined values using an external source based on a file or a database table.

Re: Create context group for DB connections

Anonymous — Mon, 05 Jun 2017 10:03:44 GMT

Thanks for the solution. In the tOracleConnection component what should be selected as the 'Property Type' for using the context variables. Should it be 'Repository' or 'Built-In'?

Re: Create context group for DB connections

TRF — Mon, 05 Jun 2017 20:16:12 GMT

Let "Property Type" to Built-in as soon as you want to use context variables.

Re: Create context group for DB connections

Anonymous — Tue, 06 Jun 2017 09:25:09 GMT

I tried using the "Property Type" to 'Built-in' in tOracleConnection. However there is no way for me to select the corresponding variables from the Context Group for the DB details like - HostName, Port, Schema, etc. Plz help

Re: Create context group for DB connections

TRF — Tue, 06 Jun 2017 10:04:05 GMT

Are the variables created in the context group?

Then, when you want to use them, you just have to enter their name in the corresponding field like "context.serverName" for example.

If you still have the problem, share a capture of the context group variables + a capture of the tOracleConnection component.