Iterate over multiple identical database sources

[fjblau]

I have an ETL job (jobs) that run against a database that I have as a dbConnection in the metadata.

But now the same job needs to run against multiple instances of the schema, just with different database names. Can I put the database names into a table (and possibly usernames/pw too) and then iterate over them with the same job? I suspect there is a way to do this with contexts, but I thought I would see if someone else has solved this already...

Thanks!

Frank

[Anonymous]

Hello

If we understand your requirement very well, tContextLoad component is what you are looking for.

Please refer to this online documentations about: TalendHelpCenter: tcontextload and TalendHelpCenter: context-scenario

Best regards

Sabrina