Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Contributor II
Contributor II

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