Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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