Connecting to Kognitio

Kognitio server clusters are accessed using either ODBC, JDBC or a REST API which between them provide connectivity to all the main BI tools, and the vast majority of query tools.

  • ODBC is installed at a system level

  • JDBC is installed into the application

  • REST API is currently an add-on utility this can be installed on a Kognitio server node or remotely.

Both the Kognitio ODBC and JDBC drivers connect directly to the database and provide high performance connections. Where an application offers both ODBC and JDBC options, you should generally choose the interface that is prefferred by or has been supported longest by the application. In any case you should avoid using JDBC via a JDBC-ODBC bridge.

For demanding workloads (data extracts etc) you should benchmark both methods to determine which performs best for your particular application.

BI tools

Business Intelligence tools provide a graphical interface to your data enabling powerful visualisations and access to data by non-SQL specialists.

Many BI tools contain data import and querying capabilities in addition to their query building and visualisation features but even using server versions they struggle with very large data sets. Fortunately, this is where Kognitio excels and combining Kognitio’s massive compute power with a good BI tools visualisation capability provides a powerful and versatile analytical and reporting platform.

Kognitio’s support of both ODBC or JDBC means you can choose the BI tool that suits your requirement; for example:

Kognitio Console

Kognitio console is our system administration tool that provides SQL submission capabilties in addition to the ability to view system objects such as schemas, tables, views, connectors etc.

It is a GUI application and compatible with Windows, Macintosh and Linux platforms - Install Kognitio Console then set up a connection.

Installing Kognitio Console will (optionally) install ODBC drivers in Windows environments.

Command-line SQL

There are a variety of ways of executing SQL from a command line:

Client Utilities

Data can be imported and exported in a variety of ways - see Client Utilities for options.