Skip to main content

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

QlikView JDBC Connector

cancel
Showing results for 
Search instead for 
Did you mean: 
rbecher
MVP
MVP

QlikView JDBC Connector

Attachments

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)
Comments
vijetas42
Specialist
Specialist

do we have JDBC driver for Windows XP 64 bit?

0 Likes
benoithervochon
Partner - Contributor III
Partner - Contributor III
0 Likes
llxq_123
Explorer
Explorer

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

0 Likes
DV_Reddy
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
BuTbka
Contributor III
Contributor III

Hello, are there any alternatives?

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