Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
lawrance
Creator II
Creator II

Connect QlikView OLEDB to SQL anywhere

Hi All,

How to connect QliKView OLEDB to SQL anywhere.

Thanks,

Lawrance A

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

1) Download and install the SAP SQL AnyWhere client software:

       SAP SQL Anywhere Database Client Download - SAP SQL Anywhere - SCN Wiki

2) In the load script press CONNECT:

2018-06-29 16_19_43-QlikView x64 - Evaluation Copy - [C__Program Files_QlikView_Examples_Documents_M.png

3) Select "SQL Anywhere OLE DB Provider 17"

4) Click Next >>

5) Fill in the relevant connection properties:

2018-06-29 16_20_04-Edit Script [C__Program Files_QlikView_Examples_Documents_Movies Database.qvw_].png

6) Click OK

7) Click SELECT to select the data you want to retrieve.

View solution in original post

4 Replies
Anonymous
Not applicable

petter
Partner - Champion III
Partner - Champion III

1) Download and install the SAP SQL AnyWhere client software:

       SAP SQL Anywhere Database Client Download - SAP SQL Anywhere - SCN Wiki

2) In the load script press CONNECT:

2018-06-29 16_19_43-QlikView x64 - Evaluation Copy - [C__Program Files_QlikView_Examples_Documents_M.png

3) Select "SQL Anywhere OLE DB Provider 17"

4) Click Next >>

5) Fill in the relevant connection properties:

2018-06-29 16_20_04-Edit Script [C__Program Files_QlikView_Examples_Documents_Movies Database.qvw_].png

6) Click OK

7) Click SELECT to select the data you want to retrieve.

lawrance
Creator II
Creator II
Author

Thanks for your response. Let me check and provide the update.

Thanks,

Lawrance A

petter
Partner - Champion III
Partner - Champion III

You're welcome - happy to help