Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Missing feature (waiting for QV support):
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.
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
I think this URL parameter syntax should used on any vendor..
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
Does the JDBC Connector DLL works with QV 11?
and how i install it
thanks
Hi,
as same as described above. Just copy the files into the QV program folder and make the settings for PATH and CLASSPATH.
- Ralf
can anybody give an example to do JDBC connecton with DB2. thanks
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
Thanks for your reply.
I am new to qlikview, could you please tell me the step .
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
The commercial version of our QlikView JDBC Connector will have an UI featuring easy configuration: