1 Reply Latest reply: Aug 12, 2014 3:28 AM by Alexandr Rodionov RSS

    ETL Problem With Direct Query

    Pradeep Kumar Pandey

      While using Direct Query in ETL with Qlikview 11.2 SR6 I am getting the error. Please help

      Error snapshot and qvw are attached.

       

       

      P.K.Pandey

        • Re: ETL Problem With Direct Query
          Alexandr Rodionov

          Hi!

          Using SAP connector as a datasource you need to set following environment variables:

          SET DirectFieldColumnDelimiter=' ';

          SET DirectIdentifierQuoteChar=' ';

           

          Here is the quote from Reference manual:

          "For SAP, Direct Discovery can be used only with the QlikView SAP SQL Connector, and it requires the following parameters in SET variables:

          SET DirectFieldColumnDelimiter=' ';

          SET DirectIdentifierQuoteChar=' ';

          SAP uses OpenSQL, which delimits columns with a space rather than a comma, so the above set statements

          cause a substitution to accommodate the difference between ANSI SQL and OpenSQL."