topic Re: Connect Azure SQL in QlikView

Connect Azure SQL

segalla — Mon, 18 Jul 2011 14:30:31 GMT

Dear, how can I connect in Azure SQL?

Connect Azure SQL

rbecher — Tue, 10 Apr 2012 15:08:20 GMT

..with our QlikView JDBC Connector: http://jdbcconnector.com and the MS SQL JDBC 4 driver.

Just see an exapmle here: http://twitpic.com/9099lj

- Ralf

Re: Connect Azure SQL

aritting — Wed, 16 Aug 2017 19:06:28 GMT

or using ODBC

Azure SQL databases currently support

ADO.NET
JDBC
ODBC
PHP

Re: Connect Azure SQL

aritting — Wed, 16 Aug 2017 21:06:03 GMT

Here is a QlikView connect statement example to an Azure SQL Database:

you need to have ODBC Driver 13 for SQL Server installed on the machine. I prefer to have the entire connection string in my code rather than an ODBC name but instead of what I have below you could have ODBC CONNECT TO DSNAMETHATYOUCREATEDINODBC;

OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=True;User ID=YOURUSERID;Extended Properties="DRIVER=ODBC Driver 13 for SQL Server;SERVER=YOURDATABASEHOST.database.windows.net;UID=YOURUSERID;Trusted_Connection=No;APP=Microsoft® Windows® Operating System;WSID=YOURPCNAME;DATABASE=YOURDATABASE;ApplicationIntent=READONLY;";Initial Catalog=DataWarehouse] (XPassword is YOURENCRYPTEDPASSWORD);