Connect QlikView to SQL Azure

[#1]

I'm looking for help (tutorial) to Qlikivew to Sql Azure.

I tried different tutorial (like http://community.qlik.com/thread/36971), but they are not complete for me.

Is there a real guide to complete this?

[rbecher]

What is the problem? Maybe I can guide you a bit but I dropped my Azure account in the meantime..

- Ralf

[#3]

I did this :

• copy JDBCConnector_x64.dll to QlikView program folder
• extend PATH with C:\Program Files\Java\jre6\bin\server
• extend CLASSPATH with vendor JDBC driver (e.g. C:\Oracle\product\11.1.0\db_1\jdbc\lib\ojdbc6.jar)

Tried to connect with :

CUSTOM CONNECT TO "Provider='C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc4.jar';jdbc:sqlserver://name.database.windows.net:1433/dbname;ssl=true;XUserId=XX;XPassword=ZZ;";

[rbecher]

Delete all old .dll files of the JDBC Connector and download the newest version which has an installer and config dialogs:

http://bit.ly/xYazjT

[#5]

Thank for your help !

I have this error :

No suitable driver found for sqlserver://ZZ.database.windows.net:1433 (Good url?)

(I added Microsoft JDBC driver Microsoft SQL Server 3.0 on JDBC Connector)

[rbecher]

You'll need a class 4 JDBC driver. You can download the one I used here: http://bit.ly/NkXOJd

The connect string is:

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:sqlserver://<your_account>.database.windows.net?databasename=<your_db>;XUserId=<xxx>;XPassword=<yyy>;";

You can use the connect dialog with this URL: jdbc:sqlserver://<your_account>.database.windows.net?databasename=<your_db>;

Hope this helps..

- Ralf

[#7]

Ralf,

Thank's a lot,

Unfortunately don't work for me..

Same error :

No suitable driver found for ZZ.database.windows.net

String like this :

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;ZZ.database.windows.net;XUserId=ZZ;XPassword=ZZ;";

JDBC connector :

[rbecher]

Wrong URL, you have to use a URL like this:

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:sqlserver://ZZ.database.windows.net;XUserId=ZZ;XPassword=ZZ;";

[#9]

it works!

Thank you very much for your help

[rbecher]

Btw, you also have to specify your database:

jdbc:sqlserver://<your_account>.database.windows.net?databasename=<your_db>;