QlikView JDBC Connector

[rbecher]

Hi all,

the product JDBC Connector reached end-of-life because it's technically outdated. Support of it ends 2018-12-31.

The successor product is the TIQ Java Service Connector and can be obtained here:

https://www.tiq-solutions.de/en/tiq-java-service-connector/

Best regards,

Ralf

--------------------------------

Hi everyone,

this is a demo version of our JDBC Connector for QlikView. It will enable a lot of non-ODBC/OLEDB sources for loading data into QlikView.

Also, it would give much more performance on QV 9 loads (Oracle, mysql etc.) and could speed up on complex network environments (like VPN, firewalls, WAN).

Please try it out and give us some feedback!

Installation instructions:

• install the JDBC Connector and config the JDBC driver (mostly a .jar file)
• connect with JDBC URL (e.g. jdbc:oracle:thin:@localhost:1521:ex)
• example connect statement for Oracle (will be included by connect popup):
  CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:oracle:thin:@localhost:1521:ex;XUserId=SbKdMaFNRLOA;XPassword=aWELJaFNRbTA;";

Missing feature (waiting for QV support):

• no select option for database/owner on table wizzard

Thanks to my colleague Sven "Benno" Uhlig who brought up this idea and implementation!

Ralf

UPDATE:

This is a new version which supports DDL and DML statements too. You will get a result set if a DML statement was executed with the update count.

Just try script calls like this:

DATA:

SQL CREATE TABLE test2 (col1 INT)

;

SQL insert into test2 (col1) values (1)

;

SQL update test2 set col1=2

;

SQL drop table test2

;

UPDATE:

New version comes with an installer and config dialogs. See also: http://www.tiq-solutions.de/display/enghome/ENJDBC for a list of possible JDBC sources.

[s_uhlig]

Hi,

since the semicolon is used by qlikview you have to use the syntax

 jdbc:derby:[subsubprotocol:][databaseName][?attribute=value[&attribute=value]*]

in contrast to Derby JDBC database connection URL.

Additional you should incude the derbyclient.jar as described in the Network Server Manual .

Regards

Sven

[rbecher]

I think this URL parameter syntax should used on any vendor..

[s_uhlig]

At least the query part should be seperated by question mark and multiple parameters have to use the ampersand for separation. This is because the connector parses the query part on its own for compatibility reasons across different driver vendors and because the semicolon can't be used as mentioned above.

Regard

Sven

[#5]

Does the JDBC Connector DLL works with QV 11? 

and how i install it

thanks

[rbecher]

Hi,

as same as described above. Just copy the files into the QV program folder and make the settings for PATH and CLASSPATH.

- Ralf

[#7]

can anybody give an example to do JDBC connecton with DB2. thanks

[rbecher]

Hi,

you should use the DB2 universal JDBC 4.0 driver (com.ibm.db2.jcc.DB2Driver).

The connection URL is like this: jdbc:db2//server:port/database

- Ralf

[#9]

Thanks for your reply.

I am new to qlikview, could you please tell me the step .

[rbecher]

You need to do all steps from the Installation instructions as described above.

I can send you further instructions via email. Contact me: ralf.becher@tiq-solutions.de

[rbecher]

The commercial version of our QlikView JDBC Connector will have an UI featuring easy configuration: