JDBC Connector

[vc_row el_class=”container”][vc_column][vc_btn title=”QlikView” style=”classic” shape=”square” color=”btn-light-orange-blue” i_icon_fontawesome=”fa fa-angle-double-left” add_icon=”true” link=”url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fproducts%2Fqlikview%2F|title:QlikView||” css=”.vc_custom_1512300793122{margin-top: 2px !important;margin-bottom: 6px !important;}”][/vc_column][/vc_row][vc_row el_class=”container” css=”.vc_custom_1511526434126{margin-bottom: 35px !important;}”][vc_column offset=”vc_col-lg-6 vc_col-md-6″][tiq_text_box tiq_text_box_css_class=”product-description product-word-break”]With the QlikView JDBC Connector, we provide 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.

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 supports QlikView Direct Discovery coming with QlikView Version 11.2 (dependent on data sources SQL capability and JDBC driver implementation).[/tiq_text_box][/vc_column][vc_column css=”.vc_custom_1511526541592{padding-left: 30px !important;}” offset=”vc_col-lg-6 vc_col-md-6″][vc_single_image image=”5497″ img_size=”full”][vc_column_text]The QlikView JDBC Connector can be licensed for QlikView Desktop and QlikView Server/Publisher.[/vc_column_text][vc_btn title=”Request” style=”classic” shape=”square” color=”btn-light-orange-blue” size=”lg” i_align=”right” i_icon_fontawesome=”fa fa-angle-right” add_icon=”true” css=”.vc_custom_1539933757342{margin-top: -44px !important;}” el_class=”product-download” link=”url:https%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fcontact%2F|title:Contact||”][/vc_column][/vc_row][vc_row el_class=”background-color-grey product-feature”][vc_column][vc_row_inner el_class=”container”][vc_column_inner][tiq_text_box tiq_text_box_title=” Possible QlikView data sources:”][/tiq_text_box][/vc_column_inner][/vc_row_inner][vc_row_inner el_class=”container”][vc_column_inner][vc_column_text]

• Amazon Redshift
• Apache Cassandra CQL
• Apache Derpy / Java DB, H2
• Apache HBase (via Phonix)
• BMC Remedy ITSM
• Cloudera Impala
• COBOL Dateien (via HXTT Cobol)
• encrypted CSV Dateien (via CsvJdbc)
• FoxPro / DBF (via HXTT DBF)
• Google Cloud SQL
• Hadoop HDFS, Hive und Hive2
  (Cloudera, Hortonworks, MapR, Amazon EMR)
• HP Vertica
• Hybris Virtual JDBC
• Kx Systems Kdb+ (supports Q programming language)
• Microsoft Windows SQL Azure
• MongoDB (via UnityJDBC)
• Neo4j Graph Database (supports Cypher graph query language)
• OrientDB document graph NoSQL dbms
• Pentaho kettle Transformation Steps (via Carte Service)
• SAP HANA DB
• SAP R/3 ERB/BW (via SAP JCo)
• SAP S4/HANA ERP/BW
• SAS Daten über Integrated Object Model (IOM)

[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row el_class=”container” css=”.vc_custom_1511528936563{margin-top: 93px !important;margin-bottom: 61px !important;}”][vc_column offset=”vc_col-lg-8 vc_col-md-8″ el_class=”service-section-two-content-padding-right”][tiq_text_box tiq_text_box_css_class=”product-text-box-margin” tiq_text_box_title=” Custom and optimized JDBC drivers”]We develop 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.

As implementation partner of Qlik we have gathered many years of experience in the integration and development of Mashups, Extensions and Node.js services for QlikView.[/tiq_text_box][tiq_image_text_columns tiq_image_text_columns_images=”5442,6720,5440,5443″ tiq_image_text_columns_urls=”https://www.qlik.com;
https://www.qlik.com/us/solutions/customers/qlik-luminaries;
http://qlikdevgroup.com/;” tiq_image_text_columns_text=”Over 10 years Qlik Implementationspartner;
Qlik Luminary Member;
Qlik Dev Group Leader;
Part of Qlik Think Tanks;” tiq_image_text_columns_only_title=”Why choosing TIQ Solutions for Qlik”][/vc_column][vc_column offset=”vc_col-lg-4 vc_col-md-4″][tiq_business_card tiq_business_card_image=”5374″ tiq_business_card_margin_bottom=”30″ tiq_business_column_alignment=”” tiq_business_card_alignment=”” tiq_business_card_title=”Your contact person” tiq_business_card_name=”Ralf Becher” tiq_business_card_profession_name=”QLIK CONSULTANT & QLIK LUMINARY” tiq_business_card_background_color=”business-card-grey” tiq_business_card_link=”url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fbusiness%2Fteam%2Fralf-becher%2F|title:Ralf%20Becher||”][vc_btn title=”Let us advice you” style=”classic” shape=”square” color=”btn-dark-orange-blue” align=”center” i_align=”right” i_icon_fontawesome=”fa fa-angle-right” button_block=”true” add_icon=”true” link=”url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fcontact%2F|title:contact||” el_class=”consult-now-button” css=”.vc_custom_1512157007569{margin-top: -4px !important;}”][/vc_column][/vc_row][vc_row el_class=”background-color-gradient remove-article-spacing”][vc_column][vc_row_inner el_class=”container margin-top-bottom”][vc_column_inner][vc_column_text]

[/vc_column_text][contact-form-7 id=”5031″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]