You are not logged in.
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.
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.
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
Last edited by jeremie (2008-10-03 11:49:02)
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.
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.