Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

inject ODBC datasource used for reload from outside

At the moment the ODBC data-source used to determine from which DB data shall be loaded is hard-coded within the loading script.

I wnat to find a way to inject that from outside to avoid having to change that within every report.

 

A proposed way to to that:

Create configuration file (Key-Value, whatever) that is used to retrieve the ODBC connection to be used. The retrieved connection shall than be used to connect to DB

please guide

regards

Usman

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The simplest way is to put the CONNECT statement in an external text file and use the $(Include) script statement to include the contents in your script.

-Rob