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.
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.
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:
Are you interested in our solution? Don’t hesitate to call us or use the contact form!