Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Connect QlikView to SQL Azure

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?

12 Replies
MVP
MVP

Re: Connect QlikView to SQL Azure

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

- Ralf

Not applicable

Re: Connect QlikView to SQL Azure

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

MVP
MVP

Re: Connect QlikView to SQL Azure

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

Not applicable

Re: Connect QlikView to SQL Azure

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)

MVP
MVP

Re: Connect QlikView to SQL Azure

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

Not applicable

Re: Connect QlikView to SQL Azure

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 :

1.PNG2.PNG

MVP
MVP

Re: Connect QlikView to SQL Azure

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

Not applicable

Re: Connect QlikView to SQL Azure

it works!

Thank you very much for your help

MVP
MVP

Re: Connect QlikView to SQL Azure

Btw, you also have to specify your database:

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

Community Browser