Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group

QlikView JDBC Connector

MVP & Luminary
MVP & Luminary

QlikView JDBC Connector

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.

Labels (1)
Attachments
Comments
Specialist
Specialist

do we have JDBC driver for Windows XP 64 bit?

0 Likes
Partner
Partner
0 Likes
Explorer
Explorer

what do you mean by 'config the JDBC driver (mostly a .jar file)'? where is this file?

0 Likes
Contributor
Contributor

I'm not able to connect to Athena using the new TIQ JAVA service connector.  The old JDBCconnector worked without issues but the newer version doesn't. Any ideas?

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2011-09-16 03:28 PM
Updated by: