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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple OLEDB Connections?

Hi

I have a Config file where I set an OLEDB connection, data paths and other variables  for a data loader.

Looking for suggestions on the best way if its possible, to define multiple OLEDB connections in the Config file then swap between connections as needed in the loader script.

Thanks in advance.

JHS

1 Reply
Anonymous
Not applicable
Author

Hi ,

You can create a text file will all OLEDB connection information one by one for ex: dev, test and prod.

Use Include clause to reference the txt file with OLEDB connecation. At a time keep one connection is Uncommented and rest commented.

Suppose if you are in test , keep the TEST OLEDB connection un commented.

Script code is as follows:

$(Include=..\..\_DBConnection\DCTserver_Connection.txt);

Hope ths helps .

BR,

Chinna