Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

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
Not applicable

Re: inject ODBC datasource used for reload from outside

Hi Usman,

we are using (global) include - files to define variables, path settings, connection strings and so on.

cp/paste from Help:

$(Include = filename )

The include variable specifies a file that contains text that should be included in the script. The entire script can thus be put in a file. A user-defined variable.

Example:

$(Include=abc.txt);

I.e. the construction set Include =filename is not applicable.

HtH

Roland

Community Browser