Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear, how can I connect in Azure SQL?
..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
or using ODBC
Azure SQL databases currently support
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);