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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do I share a database connection with sub jobs?

Hi
I want to use a connection in a master job that will be used by all of the sub jobs. In the connection component in the main job I have checked the "Use or register a shared DB connection" and entered a name "Master".
I have added a connection component to a sub job and done the same thing. The database output component uses existing connection and refers to the connection component on the sub job. (See screen shots)
The job runs OK but no data is present in the database. I don?t think I have set up the shared connection correctly.
Any help gratefully received.
Labels (2)
10 Replies
Anonymous
Not applicable
Author

Thanks Guys,
DB connection with child sub jobs is not possible when child sub job is marked to run as independent sub job.
For people looking for How to share Db connection, I have written a small article with example:
http://vikramtakkar.blogspot.in/2013/03/sharing-database-connection-with-child.html
Vikram Takkar
http://vikramtakkar.blogspot.in