Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load Mulitple collections or Multiple Tables at once

Hello All,

Currently i am using tMongoDBConnection to connect mongodb server, and then, tMongoDBInput component to get the particular collection data with writing mongo queries. 

Like wise i did created connections to mysql and ms sql servers and then using tDBinput im getting particular table data once with writing sql queries.

 

My question is, 

there are more than 20 collections from mongo and 20+ sql tables from mysql and mssql that have to work on.

So it is creating too much clutter when i use tMongoDBInput for each collections and tDBInput for each table.

 

So is there any way out that, i can use single input component and load multiple collections from mongodb, and muliple tables from mysql or mssql.

 

Any suggestions please.

Regards,

Mohan V.

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@Moe , Are you working with enterprise Talend, you can leverage the dynamic date type option. and check the below link to pass to subjob.

 

https://help.talend.com/reader/1RJ7TatgS73nP1RPGjT50w/RGvRFDFE3zpmX_rYN63gUw