Talend community forum / How to have the same job on multiple databases engines ?

kvocat · 2008-10-03 11:34:37

Tags: [context, database, mssql, oracle, PostgreSQL]

Hi !

My problem seems to be trivial. We have a lot of databases engines (DB400, Postgresql, Oracle, MSSqlServer). On these engines we have the "same" databases with "same" tables...
The goal is to launch one job (for example an insert) changing just the properties.

Is it possible ? How to do that ?

Thanks a lot for your help.

Kim

cahsohtoa · 2008-10-03 11:46:19

I think that's not so easy than changing properties.
You can copy/paste your job and put the input/output component near the current input/output component and then move the arrow to go to the newest component. After that delete the other component.
Otherwise you can try to use a generic JDBC component.

jeremie · 2008-10-03 11:47:19

Hi,

It's possible with an external delimited files or DB table with information of connection and properties.
Charge the information, iterate them with tFflowToItarate.
You can retreive all information of row in global variable "row1.field" and take them into context variable to tRunJob link to the actual job.
A job all in one (and subjob)

It's an idea

Best Regards

Jeremie

Last edited by jeremie (2008-10-03 11:49:02)

kvocat · 2008-10-03 14:36:43

Hi !

In other words, how can I change my parameters to access different DB ? Is it possible to store Server, DatabaseName, Table, User... in a property file and modify it to launch the same job on different servers ?

Thanks a lot.

kim

jeremie · 2008-10-03 15:05:20

Hi !

yes you can use contex and context variable : create a context group in reposytory.
create all context like connection
create and take value for context variable in each context
import variable and context in the job.

when you export job script chose the context to execute the job on the server : it create a context file.

jeremie

kvocat · 2008-10-03 15:24:43

Hi !

Thanks !

I will test that ! Have you a little example about that ?

Have a nice week-end.

Kim

Announcement

Unanswered posts

#1 2008-10-03 11:34:37

How to have the same job on multiple databases engines ?

#2 2008-10-03 11:46:19

Re: How to have the same job on multiple databases engines ?

#3 2008-10-03 11:47:19

Re: How to have the same job on multiple databases engines ?

#4 2008-10-03 14:36:43

Re: How to have the same job on multiple databases engines ?

#5 2008-10-03 15:05:20

Re: How to have the same job on multiple databases engines ?

#6 2008-10-03 15:24:43

Re: How to have the same job on multiple databases engines ?

Board footer