Quickstart Guide TIQ Java Service Connector

TIQ Java Service Connector (for Qlik)

Introduction

TIQ Solutions´ TIQ Java Service Connector enables analytics and reporting with the Business Intelligence (BI) tools Qlik® Sense and QlikView® for data sources and services based on Java Database Connectivity (JDBC) or other Java interfaces. It handles data that is stored in a variety of formats, including standard relational (SQL) and NoSQL databases as well as Java and cloud applications.

The TIQ Java Service Connector is able to translate SQL dialects and even NoSQL languages like Cypher to ensure compatibility between your Qlik application and the data source. Therefore it is no simple ODBC/JDBC translater so it keeps the functions and the performance given via JDBC and there is no separate exchange via data files necessary. The contained services provide access to all data sources compliant to JDBC and to MongoDB natively. For a consistent user experience the dialogues of the TIQ Java Service Connector are integrated in Qlik Sense and QlikView.

As the successor of the JDBC Connector the TIQ Java Service Connector provides for the first time an integration into Qlik Sense and into QlikView 12 without restrictions. Still professional users are able to configure the connection details and the behaviour of the Java Virtual Machine (JVM). For a quick start your profiles of the JDBC Connector can be migrated. The TIQ Java Service Connector does not see itself as a simple update, but was developed from scratch. The accompanying new service concept allows flexible expansion for all Java interfaces.

The TIQ Java Service Connector supports both 32-bit and 64-bit applications for high-performance computing environments on Microsoft Windows and can be licensed for the corresponding standalone and server versions of Qlik Sense and QlikView.

Benefits

  • Extensive performance for analytics due to the JDBC connection
  • Smaller tool chain, because of the native integration into Qlik tools
  • Integration of NoSQL data sources which do not provide SQL (e.g. Neo4j using Cypher)
  • Integration of data sources which do not provide an ODBC or OLE DB driver
  • Supports SQL databases like PostgreSQL, Oracle Database, MySQL and kdb+
  • Supports NoSQL databases like MongoDB and OrientDB
  • Supports 32- and 64-bit applications
  • FREE 14-day trial period!

About this guide

The following information enables you to connect with a data source and run your connector immediately after installation. This Quickstart Guide covers the following topics:

  • Installation of the TIQ Java Service Connector
  • Add and configure a database profile
  • Connecting and load your data into Qlik
  • Specification of the TIQ Java Service Connector
  • Troubleshooting
  • Frequently Asked Questions (FAQ)

 

Installation

Requirements

Before you start, please ensure that you have an installed Java Runtime Environment version 8 or later (JRE or SDK is possible). You need at least 40 MB of free disk space and administrator access to the computer.

Installation of the TIQ Java Service Connector

After requesting the TIQ Java Service Connector on the TIQ Solutions website you will get a weblink to access the download. After downloading the connector extract the ZIP file and install the connector via double-click “TIQJServSetup.exe”. Follow the guided Installation Setup. Whether you need the connector for Qlik Sense or for QlikView you can select optionally. You also have the choice to migrate your former JDBC Connector profiles. It is recommed to create a shortcut for the Windows Start Menu. After that, select “Run the TIQ Java Service Connector (for Qlik)” to start the TIQJServ Configurator. 

Installation Setup of the TIQ Java Service Connector

Configuration

Once the TIQ Java Service Connector is installed you can start the TIQJServ Configurator respectively via the last dialogue of the Installation Setup Routine, the Windows® Start Menu shortcut or navigate directly to the folder “Program Files (x86)”. If you have not used JDBC Connector before you have to create a new profile for your database. Otherwise you can reuse your old profiles of the JDBC Connector which were migrated during the installation process by default.

Create a profile for your database in 3 steps

  1. Tab “Profiles”: press “Create Profile”, name it (e.g. “MySQLx64”) and press “OK”. Select your new profile afterwards and you will see a change in the header of the Configurator, so you will know everytime on which profile you are working.
  2. Next is to specify the Java Classpath/JDBC driver via tab “Java Classpath”. Add a JDBC driver library or a file via the corresponding button. Please ensure that the Java Classpath is correct and check the following.

Ready to start Qlik!

1. Create a profile for your database

TIQJServ

2. Specify Java Classpath/JDBC driver

TIQ Java Service Connector for neo4j

Connecting via Qlik

Now that the profile for your database is prepared you can connect to it and load your data into Qlik.

Qlik Sense

Start Qlik Sense, create and open a new app or open an existing app in the Sense Hub. In a new app you have the choice to access the TIQ Java Service Connector via “Add data from…” or via the “Script editor”. In an existing app you can access the TIQ Java Service Connector via the “Data load editor” in the navigation menu on the top.

Connect via “Add data from files and other sources”

  1. After pressing “Add data from…” you can choose the 32-bit or the 64-bit TIQ Java Service Connector, depending on your application.
  2. The Connect dialog opens and you need to fill in the URL, username and password for your database connection.
  3. Choose the profile, which you have created in the TIQ Java Service Configurator, press “Test Connection” and then you can “Create” your connection.

Choose the connector.

Fill in connection details, test and create.

TIQ Java Service Connector

Select via “Add data from files and other sources”

  1. Once you have created your connection, the data select dialogue opens and you can choose the data you want to load by pressing on the drop down menu.
  2. Choose the relevant tables on the left and the fields on the right side.
  3. By pressing “Add data” your data will be added to your app .

Now your data is loaded and you can start to analyse with Qlik Insights as usually.

Select your data.

TIQ Java Service Connector

Load your data.

Load your data.

Connect via “Script editor”

  1. After pressing “Script editor”, press “Create new connection” and you can choose between the 32-bit and 64-bit TIQ Java Service Connector, which depends on your application.
  2. The Connect dialogue opens and you need to fill in the URL, username and password for your database connection.
  3. Choose the profile, which you have created in the TIQ Java Service Configurator, press “Test Connection” and then you can “Create new connection”.

Choose the connector.

Fill in connection details, test and create.

TIQ Java Service Connector

Select via “Script editor”

  1. Once you have created your connection you get back to the script editor and you need to press “Select data” to get to the load dialogue.
  2. Choose the relevant tables on the left and the fields on the right side. Create your load script by pressing “Insert script”.
  3. Back again in the script editor you need to press “Load data” at the top on the right.

Now your data is loaded and you can start to analyse with Qlik Sense as usually.

Select your data and create script.

TIQ Java Service Connector

QlikView

Start QlikView and create a new app or open an existing app.

Connect

Open the dialogue “Edit Script” and choose the required TIQ Java Service Connector in the drop down menu in the tab “Data”.

  1. Press “Connect” and fill in the URL, username and password for your database connection.
  2. Choose the profile, which you have created in the Configurator and press “Test Connection”.
  3. Then a message will appear that the connection was established successfully and a custom connection query is pasted in the script.

Close the dialogues by pressing “OK”.

Select

  1. Now press “Select” and choose the data you want to load by pressing on the drop down menu.
  2. Choose the relevant Tables on the left side and look at your data on the right side.
  3. By pressing “OK” a load query will be pasted in the script.

Now you can load your data by pressing “Reload” at the top menu and analyse your data with QlikView as usually.

1. Connect to your database.

2. Select your data.

TIQ Java Service Connector Neo4j to QlikView

Specifications

  • QlikView 12 November 2017 (64-bit) and later is supported
  • Qlik Sense Februray 2018 (64-bit)  and later is supported
  • Windows Server 2008 R2 SP1 (64-bit) and later is supported
  • Windows 7 SP1 (64-bit) and later is supported
  • Java 8 and later is supported
  • Complies with the latest JDBC 4.2 specification
  • message and close the connect dialogue. Afterwards open the connect dialogue again and now you can fill in your connection details.

Troubleshooting

Please ensure the following to avoid problems with the TIQ Java Service Connector.

  • Choose the proper Java Runtime Environment/Java Development Kit, e.g. it has to match the connector or JDBC driver (32-/64-bit) you want to use.
  • Choose the proper driver for your data source/database (e.g. release and version of the database).
  • Choose the proper driver for your environment (e.g. operating system and Java version)
  • Ensure that your connection to your data source/database is not blocked (e.g. neither firewall nor anti-virus software blocks the connection).
  • Ensure that you have the necessary permissions to access and operate on the data source/database.
  • Ensure that you update the file paths of you JVM in all your profiles (TIQJServ Configurator) after you have updated your Java Runtime Environment/Java Development Kit.
  • Some Anti-virus software products will do a malware scan or similar at the first start of each connector (32-/64-bit) inside QlikView and Qlik Sense. If that happens please wait a moment until the scan is ready, close the possibly opening error message and close the connect dialogue. Afterwards open the connect dialogue again and now you can fill in your connection details.

Frequently Asked Questions (FAQ)

TIQ Java Service Configurator

“Which JRE is the correct one for my application?”
a. Try to answer the following questions and you will know which JRE you need.
– Which software architecture do you need for your application? >> 32- or 64-bit links to “C.\Program Files (x86)\Java\…” or “C.\Program Files\Java\…
– Which version and what type of operating system do I have? >> Windows Desktop or Windows Server
b. Ensure that you comply with the specification of the TIQ Java Service Connector.

“Which Java Classpath is the correct one for my application?”
a. Does the Java Classpath fit to the database and the correct version of the database?
b. Does the Java Classpath fit to the selected Java version?

“What are the Logging Levels for and how to use them?”
With Logging Levels you can specify how detailed and on which scope you want to log information. The level of detail is descending in the drop-down menu.

Logging Level

Tracemost detailed level to use for development and testing or evaluation for a deep look into the application
Debugdetailed level to use for development and testing or evaluation for an overview of what the application is doing
Infouseful during operation and management of your system
Warnused for known exceptions or other important log events
Errorused to log all unhandled exceptions
Fatalreserved for special exceptions or conditions when errors happen
Offlogging is off

“What is meant with Options at the “Java VM Options” and how to use them?”
Here you can specify the operating principles of your JVM. With “-Xmx64M” for example you can specify the maximum Java heap size to 64 MB. Which option you can use is depending on your version of the JVM and the type of operating system you use.

 

Qlik Sense

“I’m not able to create a connection.”
Ensure that you fill in a “Name” for the connection on the top of the dialog.
Ensure you test your connection via “Test connection”.
Ensure that your URL, username, password and the chosen profile for your database connection is correct. See also FAQ of the TIQ Java Service Configurator.

“I’m not able to create a connection even though the connection test was successful.”
Ensure that you fill in a “Name” for the connection on the top of the dialogue.

“I can’t see any data in the Select dialogue even when I have selected a table.”
Ensure that a table type is selected on the top of the dialogue.
You can also preconfigure the table types in the TIQ Java Service Configurator in the dialogue “Advanced Settings” (e.g. “TABLE”).

 

QlikView

“I’m not able to create a connection.”
Ensure that your URL, username, password and the chosen profile for your database connection is correct. See also FAQ of the TIQ Java Service Configurator.

“I press “Select” but the “Connect” dialogue opens.”
As long as there is no connection established successfully, the “Connect” dialogue opens to complete the configuration of the connection.

“I can’t see any data in the Select dialogue even when I have selected the desired table.”
Ensure that a table type is selected on the top of the dialogue.
You can also preconfigure the table types in the TIQ Java Service Configurator in the dialogue “Advanced Settings” (e.g. “TABLE”).