https://community.qlik.com/t5/Talend-Studio/Iterate-over-multiple-identical-database-sources/m-p/2348966#M116014 <P>I have an ETL job (jobs) that run against a database that I have as a dbConnection in the metadata.</P><P></P><P></P><P>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...</P><P></P><P></P><P>Thanks!</P><P></P><P></P><P>Frank</P> Fri, 15 Nov 2024 22:02:32 GMT fjblau 2024-11-15T22:02:32Z https://community.qlik.com/t5/Talend-Studio/Iterate-over-multiple-identical-database-sources/m-p/2348966#M116014 <P>I have an ETL job (jobs) that run against a database that I have as a dbConnection in the metadata.</P><P></P><P></P><P>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...</P><P></P><P></P><P>Thanks!</P><P></P><P></P><P>Frank</P> Fri, 15 Nov 2024 22:02:32 GMT https://community.qlik.com/t5/Talend-Studio/Iterate-over-multiple-identical-database-sources/m-p/2348966#M116014 fjblau 2024-11-15T22:02:32Z https://community.qlik.com/t5/Talend-Studio/Iterate-over-multiple-identical-database-sources/m-p/2348967#M116015 <P>Hello</P><P>If we understand your requirement very well, tContextLoad component is what you are looking for.</P><P>Please refer to this online documentations about: <A href="https://help.talend.com/r/en-US/8.0/context/tcontextload" alt="https://help.talend.com/r/en-US/8.0/context/tcontextload" target="_blank">TalendHelpCenter: tcontextload</A> and <A href="https://help.talend.com/r/en-US/8.0/context/context-scenario" alt="https://help.talend.com/r/en-US/8.0/context/context-scenario" target="_blank">TalendHelpCenter: context-scenario</A></P><P>Best regards</P><P>Sabrina</P><P>&nbsp;</P> Mon, 06 Mar 2023 05:29:30 GMT https://community.qlik.com/t5/Talend-Studio/Iterate-over-multiple-identical-database-sources/m-p/2348967#M116015 Anonymous 2023-03-06T05:29:30Z