Get data from Azure data warehouse with Qlikview

Haydk — Sat, 16 Nov 2024 18:12:24 GMT

Hello, I have been using qlikview for long time but I am still new to make a connection setting up.

Currently, I have a demand to get data in azure data warehouse. With following the steps below, I can see the name of database inside azure data warehouse which I would like to access. But I cannot make the connection when I try the test connection.

Can anyone advise me how to connect those?

1) Edit script

2) OLE Database and click connect

3) Select 'Microsoft OLE DB Provider for SQL Server'

4) Fill Server name, User name and my password

5) Select the database on the server *As of this point, I can see the name of database I want to access.

6) Click test connection

7) Then error message pops up which says client's "driver version is not supported".
*I have the latest driver for the ODBC driver for SQL server in my pc.
*I can access that database with use of "SQL server management" and my credential above.

Thank you!

Re: Get data from Azure data warehouse with Qlikview

Brett_Bleess — Thu, 03 Sep 2020 14:42:24 GMT

You will need to be sure you have installed proper SQL Server OLE DB connector for Azure environments in order to make the connection. We do not provide a connector for QlikView to connect to Azure storage, so this will have to come from Microsoft. I suspect you are trying to use the built-in OS OLE DB provider for SQL which is an ancient driver and not surprising Azure does not work with it.

Here is an Azure link I found that should help:

https://docs.microsoft.com/en-us/previous-versions/azure/virtual-machines/windows/sqlclassic/virtual-machines-windows-classic-sql-connect

Regards,
Brett

topic Re: Get data from Azure data warehouse with Qlikview in QlikView

Get data from Azure data warehouse with Qlikview

Re: Get data from Azure data warehouse with Qlikview