Use this procedure to obtain the Microsoft Windows ODBC driver and install it.
Estimated reading time: 5 minutes

ThoughtSpot’s ODBC connection relies on the SimbaEngine X SDK to connect via ODBC or JDBC to ThoughtSpot’s remote data stores. The instructions on this page explain how to configure the Simba ODBC driver on a Windows workstation.

Make sure you have read the overview material in the ODBC driver overview. This workstation is the same machine where you plan to run your ETL activities.

Prerequisites

These instructions include directions to use the ssh command. Make sure your Windows workstation is equipped with a tool such as Putty for making ssh connections to your ThoughtSpot server.

The ODBC driver for Windows requires Visual C++ Redistributable for Visual Studio 2013. You are prompted to install it during installation of the driver if it isn’t already installed.

To check if this Microsoft tool is already installed, search for it on your workstation.

If it isn’t installed, make sure you download and install it before continuing.

Check the ThoughtSpot IP and the simba_server status

Before you begin, you need to know the IP address or DNS name of the server you intend to connect your server to.

  1. SSH as admin or the thoughtspot user to your ThoughtSpot node.
  2. Verify the node IP(s).

    $ tscli node ls
    172.18.231.17
    
  3. Make a note of each IP; there may be more than one.
  4. Verify that the simba_server is running, if it isn’t, work with ThoughtSpot Support to start it.
  5. Exit or close the shell.

Download the driver

On the workstation where you want to connect from, do the following:

  1. Navigate to the Downloads page.
  2. Download the ODBC Driver for Windows driver.
  3. Unzip the file you downloaded at a convenient location on your workstation.

  4. Take a moment to examine the contents of the new directory.

    There are two different Windows ODBC installers included in the file you downloaded.

    • ThoughtSpotODBC (x86).msi for Windows 32-bit
    • ThoughtSpotODBC (x64).msi for Windows 64-bit

Install the driver and supporting software

The installation process installs the Simba driver and adds the ODBC Administrator software to your workstation. You use this software to configure the driver.

  1. Launch the installer for your version of Windows.
  2. Click Next to continue.

  3. Accept the End User License Agreement (EULA), and click Next.
  4. Specify the destination folder where the driver will be installed.

  5. Enter the ThoughtSpot server details, and click Next.

    • For Server(s), provide a comma separated list of the IP addresses of each node on the ThoughtSpot instance.

    • For Database, optionally specify the database to use. If you skip this entry, you’ll need to provide the database each time you connect using ODBC.

  6. Confirm that the install can begin by clicking Install.

  7. You may see a security warning.

  8. Select YES to continue.

    A confirmation message appears when the installation is complete.

  9. Click Finish.

Configure the driver and test your connection

Once installation is complete, you use the ODBC Administrator to configure the ODBC connection on your Windows workstation. For example, you may want to add a default schema or change the server IP address or the default database.

It is recommended to add a default schema. If you don’t specify a default schema, you will need to supply it every time you use the ODBC driver.

At this point, you can test your ODBC connection to ThoughtSpot. It is important to recall that the username/password you use belongs to a ThoughtSpot application user. Typically, this user is a user with data management or administrative privileges on the application.

  1. Before trying the ODBC connection, confirm a username/password that can login into the ThoughtSpot applications.
  2. Confirm the user’s privileges by going to the Data tab.
  3. Return to your workstation.
  4. Locate and open the ODBC Data Source Administrator (64-bit) application.

  5. Choose the System DSN tab.

  6. Select ThoughtSpot and press Configure.

  7. Choose Options.

    The system displays the Options dialog.

  8. Ensure you have the following Custom Property values set:

    Custom Property Value
    SCHEMA falcon_default_schema is the default
    UID The username of a user with data management privilege.
    PWD The password for the username you specify.

    You don’t have to use the default schema, you can specify another. You should at least supply a default schema, otherwise, you must supply Once every time you use the ODBC driver. Moreover, without a schema or if the schema is not present, the ODBC driver returns an error that says the schema could not be found.

    Similarly, adding the UID and PWD properties are not required. If you don’t add them, you are prompted to supply them each time you connect.

    When you are done, your options should look similar to the following:

  9. When you are done, press OK to save your new properties.
  10. Press Test Connection to test your database connection.

  11. Press Cancel to close the DSN Configuration dialog.
  12. Press OK to close the Client Configuration Dialog the dialog.
  13. Press OK to close the ODBC Data Source Administrator (64-bit) application

Now, you are ready to begin using the connection you’ve configured.