https://community.qlik.com/t5/Talend-Studio/loop-on-set-of-context/m-p/2295813#M68544 Hi,<BR />The brand new component tContextLoad initializes a context from an input component. The input component may be a file or a database component. The schema has 2 columns : key and value.<BR />You could create one file for each database connection context and iterate with tFileList.<BR /><BR />Hope this helps. Tue, 20 Mar 2007 11:15:32 GMT Anonymous 2007-03-20T11:15:32Z https://community.qlik.com/t5/Talend-Studio/loop-on-set-of-context/m-p/2295812#M68543 Hi all, <BR />I would like to create a job whose purpose is to retrieve data from different databases which have exactly the same tables. The way I found to define a generic connection is to create some context variables such as host, port, database, ... Then in my DB components, I use these context variables to specify the DB connection. Finally, I create one context for each of my database. <BR />Does anyone knows whenever it's possible to create a loop on the contexts of a job? Or do I have to create one tRunJob for each of them and then connect them via main rows? <BR />Third question: can you imagine a better design for the whole problem? <BR />Thanks. Sat, 16 Nov 2024 14:37:34 GMT https://community.qlik.com/t5/Talend-Studio/loop-on-set-of-context/m-p/2295812#M68543 Anonymous 2024-11-16T14:37:34Z https://community.qlik.com/t5/Talend-Studio/loop-on-set-of-context/m-p/2295813#M68544 Hi,<BR />The brand new component tContextLoad initializes a context from an input component. The input component may be a file or a database component. The schema has 2 columns : key and value.<BR />You could create one file for each database connection context and iterate with tFileList.<BR /><BR />Hope this helps. Tue, 20 Mar 2007 11:15:32 GMT https://community.qlik.com/t5/Talend-Studio/loop-on-set-of-context/m-p/2295813#M68544 Anonymous 2007-03-20T11:15:32Z