1 Reply Latest reply: Sep 15, 2012 9:13 AM by Roland Kunle RSS

    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

        • 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