Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reuse same script to get data from multiple sources

I am developing an App that is extracting data from a financial system. There are 3 different databases for 3 business entities. I want to reuse the same script for each data source as they have an identical schema.

I am thinking of writing the common LOAD/SELECT statements in an include file and load it three times.  Something like the following:

ODBC CONNECT32 To [<connection string 1>];

$(Include=script.txt);

ODBC CONNECT32 To [<connection string 2>];

$(Include=script.txt);

ODBC CONNECT32 To [<connection string 3>];

$(Include=script.txt);

Is this a sensible approach?  Is there any best practice for handling this situation?

0 Replies