0 Replies Latest reply: Apr 14, 2017 1:19 PM by John Zarbock RSS

    How to connect QlikSense to SAS SPDS by ODBC?

    John Zarbock

      We have a functioning LIBNAME for SAS and SPDS.  There are two tables in SPDS we should see from QlikSnese; but, we see nothing.  Does anyone have a sample script which would connect?

       

      ODBC CONNECT32 TO MY_SPDS;

      LOAD FlightNum, Year;

      SQL SELECT *

      FROM SASQLIK.AIRLINE;

       

      The above gives error:

       

      Started loading data

       

      The following error occurred:

       

      CONNECTs other than LIB CONNECT are not available in this script mode.

       

      The error occurred here:

       

      ODBC CONNECT32 TO ***

       

      Data has not been loaded. Please correct the error and try loading again.