2 Replies Latest reply: Jul 20, 2015 9:03 AM by Markus Mortsiefer RSS

    Using a Custom Connect via an Include Statement

    Markus Mortsiefer

      Hallo,

       

      Im using the Qlik ODBC Connector and want to use an include statement for a Custom Connect so that i do not have to maintain the password in each project.

       

      It works fine when im reloading the file from the Desktop App. The problem it does not work when im doing the reload via Publisher.

      When i have the Custom Connect statement in the Script Direclty then the Reload works from Publisher aswell so the connector is installed correctly. I just does not work when using the Include statement

       

       

      Here is the Script

      SET ThousandSep='.';

      SET DecimalSep=',';

      SET MoneyThousandSep='.';

      SET MoneyDecimalSep=',';

      SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

      SET TimeFormat='hh:mm:ss';

      SET DateFormat='DD.MM.YYYY';

      SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

      SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

      SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

       

      $(Include=\\PROJ\test.txt);

       

      LOCATION:

      SELECT

      *

      FROM

      LOCATION; 

       

       

      Statement in the test.txt file

      CUSTOM CONNECT TO 'Provider=QvOdbcConnectorPackage.exe;driver=oracle;host=XXXXXX.com;port=1521;servicename=XXXXX;EnableNcharSupport=1;XUserId=XXXXXX;XPassword=XXXXXX;';