Connect Azure SQL

[segalla]

Dear, how can I connect in Azure SQL?

[rbecher]

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

[aritting]

or using ODBC

Azure SQL databases currently support

• ADO.NET
• JDBC
• ODBC
• PHP

[aritting]

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