Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
segalla
Partner
Partner

Connect Azure SQL

Dear, how can I connect in Azure SQL?

3 Replies
rbecher
MVP & Luminary
MVP & Luminary

..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

Vizlib Head of R&D
aritting
Contributor III
Contributor III

or using ODBC

Azure SQL databases currently support

  • ADO.NET
  • JDBC
  • ODBC
  • PHP
aritting
Contributor III
Contributor III

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);