Kognitio DSN configuration on Windows

You can set up a Data Source Name (DSN) to connect to Kognitio. Below are instructions on how to do this directly from Kognitio Console.

DSNs can be used by any BI tool that utilises ODBC to access Kognitio such as Qlik Sense, Tableau or Microsoft Power BI. For these tools you only need to have the Kognitio ODBC driver installed. Then access the “ODBC Data Sources” directly on your system then follow steps 3 to 6 to create your Kognitio DSN.

1. In Console hit the Connect to server icon: connect_icon.

2. Click the dotdotdot_icon icon.

It’s next to the Server drop-down list.

The Connect to server dialog box.

3. Select the User DSN tab and click Add.

The ODBC Data Source Administrator (64-bit) dialog box.

Note

This isn’t a Kognitio dialog box. It’s part of Windows Control Panel.

In Windows, you can navigate to it anytime (even before you install Kognitio):

  1. On the Start menu, click Control Panel.
  2. In Control Panel, click Administrative Tools.
  3. In Administrative Tools, click ODBC Data Sources (64-bit).

In Windows 10, you can hit the Start flag start_icon and type ODBC. Windows should show you the ODBC Data Sources Destop App as a choice.

4. Select the Kognitio WX2 driver.

../_images/console_dsn_03.png

5. Click Finish.

Now you need to supply:

  • Data Source Name: any name that will help you to remember the Kognitio instance you’re connecting to.
  • Description: optional, anything you want.
  • Server address: the IP address of either:
    • your Kognitio on Hadoop edge node(s).
    • or, your Kognitio standalone node(s).

Make sure the default port is set to 6550.

../_images/console_dsn_04.png

Note

The IP address can include the port explicity like this: 10.4.3.143:6550. You can supply a list of IP addresses separated by semicolons like this: 10.4.3.143; 10.4.3.144.

6. Click OK twice.

This returns you to the Connect to server dialog.

7. In the Server drop-down list, select the DSN you just created.

  • Make sure the User id is SYS.
  • Type the password for your Kognitio on Hadoop server.

Remember, the default password for any server is simply the server’s name.

../_images/console_dsn_05.png

If the connection fails, look in the Logs pane for diagnostic messgaes.

To display the Logs pane:

  1. On the View menu, click Panes.
  2. From the Panes list, select Logs.

Once you have successfully connected, Console displays the System pane.