QlikView Connector JDBC

With the QlikView JDBC Connector, TIQ Solutions provides QlikView users the opportunity to connect JDBC data sources (eg databases available without ODBC / OLEDB drivers such as Derby / Java DB; big data environments) directly within QlikView. A direct database connection may prevented a complex exchange and integration of external files.

It is possible now, for example, to integrate data from hadoop / hive into QlikView.

Furthermore, properties of the JDBC driver are configurable in the connection URL. Especially for installations of QlikView Version 9, a significant reduce of loading time can be achieved with the appropriate use and configuration of the JDBC driver instead of ODBC / OLEDB.

Example: jdbc:oracle:thin:@sampleserver:1521:dbname?defaultRowPrefetch=1000

An additional functionality of the QlikView JDBC Connector is the improved support for writing back informations into connected databases.
Within the QlikView script the execution of DML statements (eg insert / update / delete) returns a result set with the number of changed rows.
Hereby it is now possible, for example, to integrate QlikView into workflow processes with a write-back of status information.

The QlikView JDBC Connector can be licensed for QlikView Desktop and QlikView Server.

Possible JDBC data sources:

Derby / Java DB
encrypted CSV files
Hadoop Hive
Microsoft Windows SQL Azure
COBOL files

A list of JDBC drivers and vendors you can find under http://www.sqlsummit.com/JDBCVend.htm.

QlikView Connector JDBC

Demo

Contact

TIQ Solutions GmbH

Callback

Search