topic Re: Connect QlikView to SQL Azure in QlikView

Connect QlikView to SQL Azure

Sun, 01 Jul 2012 08:46:10 GMT

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?

Re: Connect QlikView to SQL Azure

rbecher — Sun, 01 Jul 2012 09:22:35 GMT

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

- Ralf

Re: Connect QlikView to SQL Azure

Sun, 01 Jul 2012 09:34:49 GMT

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

Re: Connect QlikView to SQL Azure

rbecher — Sun, 01 Jul 2012 09:57:14 GMT

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

Re: Connect QlikView to SQL Azure

Sun, 01 Jul 2012 15:15:01 GMT

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)

Re: Connect QlikView to SQL Azure

rbecher — Sun, 01 Jul 2012 18:14:27 GMT

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

Re: Connect QlikView to SQL Azure

Sun, 01 Jul 2012 19:18:21 GMT

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 :

Re: Connect QlikView to SQL Azure

rbecher — Sun, 01 Jul 2012 19:22:24 GMT

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

Re: Connect QlikView to SQL Azure

Sun, 01 Jul 2012 19:38:27 GMT

it works!

Thank you very much for your help

Re: Connect QlikView to SQL Azure

rbecher — Sun, 01 Jul 2012 19:38:27 GMT

Btw, you also have to specify your database:

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

Re: Connect QlikView to SQL Azure

rbecher — Sun, 01 Jul 2012 19:39:00 GMT

Ok, great!

Re: Connect QlikView to SQL Azure

Wed, 04 Jul 2012 10:45:20 GMT

I have some problems with the datas

A simple select on a table returns mixed results.

The result is the combination of all the fields!

Example of select :

SELECT

[ContactId]

,[CustomerId]

,[Lastname]

,[Firstname]

,[Mail]

,[Telephone]

,[AddressLine1]

,[AddressLine2]

,[City]

,[Zip]

,[Country]

,[Comment]

,[CreationDate]

,[CivilityFlag]

,[PhoneHome]

,[PhoneMobile]

FROM [Contacts];

I really don't understand why my data is mixed!!

Connection can explain this?

Re: Connect QlikView to SQL Azure

rbecher — Wed, 04 Jul 2012 14:05:48 GMT

What means mixed in your case? Can you give an example?

Maybe it's better to email me: ralf.becher@tiq-solutions.de