topic Re: How can I integrate Qlik Sense with SAS through ole db connection in App Development

How can I integrate Qlik Sense with SAS through ole db connection

Anonymous — Thu, 21 Jun 2018 22:33:10 GMT

Hi.

I would like to know how I should generate an ole db connection between qlik sense and SAS, this connection must be by the IOM method, I have searched for information about it but it only refers to ODBC connection, I do not know if I really have to install the SAS client in Qlik Sense server or just have to do some internal configuration of some service so I can connect.

Thank you for your support

Re: How can I integrate Qlik Sense with SAS through ole db connection

rwunderlich — Thu, 21 Jun 2018 23:36:07 GMT

If you are going to connect using IOM, I believe at a minimum you must install the SAS itech client

Client Installation

I'm guessing you will also need to install the SAS OLEDB provider

SAS Downloads: SAS Providers for OLE DB

-Rob

Re: How can I integrate Qlik Sense with SAS through ole db connection

dosborne — Thu, 21 Nov 2019 06:15:49 GMT

Hi,

Did you have any luck with this ? i am trying to use SAS OLE DB local provider to read a SAS file. I managed to create a connection and connect USING LIB CONNECT.

I cant see how to code the load statement though. I have tried:

LIB CONNECT TO 'E--more-SAS (username)';

LOAD *
FROM [lib://E--more-SAS (username)/file_name.sas7bdat];

but the load statement doenst know what sort of file it is.

Thanks