Skip to main content

 

ThoughtSpot

Install the ODBC Driver on Windows

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

Use this procedure to obtain the Microsoft Windows ODBC driver and install it.

The ODBC driver for Windows requires:
  • Visual C++ Redistributable for Visual Studio 2013

You will be prompted to install it during installation of the driver if it isn't already installed.

The installation packages for clients can be downloaded from the Help Center
  1. You can download the clients by going to the Help Center from the ThoughtSpot Web interface, and selecting Downloads.
    There are two different Windows ODBC installers. Choose the installer for your version of Windows:
    • ThoughtSpotODBC (x86).msi for Windows 32-bit
    • ThoughtSpotODBC (x64).msi for Windows 64-bit
    If the Help Center is unreachable, the clients can also be accessed directly through the ThoughtSpot instance. To secure copy (scp) the installers, issue:
    scp -r admin@<appliance_IP>:/usr/local/scaligent/toolchain/local/simba/odbc/windows .
  2. Double click the .msi file you downloaded to start the installation.
  3. You will see a security warning. Select Yes to continue.
    File:Integration_Guides/Data_Integration_Guide/020/010/010/windows_odbc_install.png

    Allow the ODBC Installer to run

  4. Click Next to continue.
    File:Integration_Guides/Data_Integration_Guide/020/010/010/odbc_install_1.png

    The ODBC Installer

  5. Accept the End User License Agreement (EULA), and click Next.
  6. Specify the destination folder where the driver will be installed.
    File:Integration_Guides/Data_Integration_Guide/020/010/010/odbc_install_3.png

    Enter the destination folder

  7. 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.

      If you need to obtain the IP addresses of the nodes in the cluster, you can run the command tscli node ls from the Linux shell 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.
    File:Integration_Guides/Data_Integration_Guide/020/010/010/odbc_install_4.png

    Enter server and database for ODBC

  8. Confirm that the install can begin by clicking Install.
  9. You will see a confirmation message when the installation has finished. Click Finish.
    File:Integration_Guides/Data_Integration_Guide/020/010/010/odbc_install_6_install_completed.png

    Installation was successful

  10. If you need to make changes to the ODBC configuration later, you can Change the ODBC Configuration on Windows.
  • Was this article helpful?