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.
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:
Microsoft Excel - simply use Kognitio as a standard ODBC data source.
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.
Installing Kognitio Console will (optionally) install ODBC drivers in Windows environments.
There are a variety of ways of executing SQL from a command line: