Talend community forum / How to switch DB connections for all jobs in project at once?

zootal · 2012-04-26 00:51:06

I have a project with about a dozen jobs. Each job has several tMSSqlInput/Outputs, and I use a Db connection in my repository for all of these. This is handy for when I change Db connection properties - different server, update password, etc. I just up the Db connection in my repository, and all of my jobs are updated. Very nice.

I have two Db connections - one for development, and one for test - and I may add some more for different testing phases.

Is it possible to change the Db connection all of my jobs use instead of updating the Db connection? It would be nice to switch from one to the other to the next and back instead of updating the same Db connection over and over again.

pedro · 2012-04-26 07:47:22

Hi

Sorry. I know what you mean.
But this feature is not supported by Talend.

For any new feature, you might report it on BugTracker.

Or you can configure Context as the following image.

Regards,
Pedro

Uploaded Images

janhess · 2012-04-26 10:12:24

Use contexts for the connections and change the data in the file that the contexts are read from. RThat way all connections change at once.

Announcement

Unanswered posts

#1 2012-04-26 00:51:06

How to switch DB connections for all jobs in project at once?

#2 2012-04-26 07:47:22

Re: How to switch DB connections for all jobs in project at once?

#3 2012-04-26 10:12:24

Re: How to switch DB connections for all jobs in project at once?

Board footer