Installing Kognitio Console

Console is the Kognitio client tool for:
  1. submitting your SQL queries to Kognitio

  2. basic system administration

  3. runnning interactive kog scripts

Installing Kognitio Console

Choose your operating system for installation instructions

1. Download the installer.

Console for Windows is available to download from the Kognitio Downloads Page .

2. Run the installer.

../_images/console_install_01.png

3. Click Next.

../_images/console_install_02.png

4. Click ‘I Agree’ if you’d like to accept the license agreement.

../_images/console_install_03.png

We recommend that you accept all three check boxes:

Option:

Result:

ODBC Driver

Allow ODBC clients to connect to your database.

Kognitio Command Line Tools

Install the command-line utilities.

Kognitio Console

Install the console itself.

5. Decide who you want to use Kognitio Console.

../_images/console_install_04.png

Click one of the radio buttons and then click Next.

6. Optionally, change the Destination Folder.

../_images/console_install_05.png

Then click Install.

7. Click Finish.

If you are only installing the ODBC driver or the client tools then you are done. You may want to set-up a DSN manually.

The rest of these instructions are for connecting to Kognitio from Console.

8. Set up a Data Source Name (DSN) via Console.

Set up a Data Source Name (DSN) for your Kognitio server.

9. Connect to your Kognitio server.

Click the lightning icon or select File, Connect.

10. Check that you can run some simple SQL.

SELECT value FROM values BETWEEN 1 AND 7;

If you connected successfully, this query should always work.

11. Now run some SQL against your data.

Here’s an example that uses our Retail data:

SELECT COUNT(*) num_items
FROM demo_ret.v_ret_sale;

1. Download the Kognitio Console dmg file.

Console for MacOS is available to download from the Kognitio Downloads Page .

2. Install the pkg file.

Doubleclick on the Kognitio Console dmg file and drag the pkg file it contains into the /Applications folder. Run the pkg file to install it.

Follow the installation instructions, you can choose an installtion path for the software and may also be prompted for an administration password.

3. Start Kognitio Console

Kognitio Console will be available from the /Applications folder. Doubleclick the icon to start the application.

4. Connect to Kognitio

You can connect to a Kognitio system directly by clicking on the lightning icon or select File, Connect then:

  • Select Server - “Specify address and port” and Driver - “Kognitio”

  • Enter the domain name or IP address of your Kognitio system

  • Enter the port number of your Kognitio system. The default is 6550

  • Enter your User ID and password for the Kogntiio system you are trying to connect to.

5. Check that you can run some simple SQL.

SELECT value FROM values BETWEEN 1 AND 7;

If you connected successfully, this query should always work.

6. Now run some SQL against your data.

Here’s an example that uses our Retail data:

SELECT COUNT(*) num_items
FROM demo_ret.v_ret_sale;

Learn More