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 Apache Derby / Java DB; big data environments) directly within QlikView. A direct database connection may prevented a complex exchange and integration of external files.  JDBCConnector

 


It is possible now, for example, to integrate data from Hadoop Hive into QlikView:


Datenintegration-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/Publisher.

 

Possible QlikView data sources:

  • Hadoop HDFS, Hive and Hive2
    (Cloudera, Hortonworks, MapR, Amazon EMR)
  • Cloudera Impala
  • Apache HBase (via Phoenix)
  • Apache Cassandra CQL
  • Amazon Redshift
  • SAP S4/HANA ERP/BW
  • SAP HANA DB
  • SAP ERP/BW (via SAP JCo)
  • hybris Virtual JDBC
  • HP Vertica
  • Kx Systems Kdb+ (supports Q programming language)
  • SAS Data Using the Integrated Object Model (IOM)
  • Microsoft Windows SQL Azure
  • Google Cloud SQL
  • Neo4j Graph Database (supports Cypher graph query language)
  • MongoDB (via UnityJDBC)
  • OrientDB document graph NoSQL dbms
  • Apache Derby / Java DB, H2
  • encrypted CSV files (via CsvJdbc)
  • COBOL files (via HXTT Cobol)
  • FoxPro / DBF (via HXTT DBF)
  • Pentaho Kettle Transformation Steps (via Carte Service)
QlikView-JDBC-Connector-Derby_400


The QlikView JDBC Connector supports QlikView Direct Discovery coming with QlikView Version 11.2 (dependent on data sources SQL capability and JDBC driver implementation).


TIQ Solutions develops custom and optimized JDBC drivers for several use cases (such as HDFS, FasterHive or Beeswax JDBC driver) based on its own JDBC Toolbox. Learn more about this on our GitHub account:
https://github.com/TIQSolutions


Are you interested in our solution? Don’t hesitate to call us or use the contact form!

Download JDBC Connecctor