Skip to main content

 

ThoughtSpot

Install the ODBC Driver on Linux

Overview

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

Feature

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

The installation packages for clients can be downloaded from the Help Center
  1. You can download the clients by going to the Help Center Help Icon from the ThoughtSpot Web interface.
    If this Help Center is unreachable, the clients can also be accessed directly through the ThoughtSpot Analytic Search Appliance
    scp -r admin@<appliance_IP>:/usr/local/scaligent/toolchain/local/simba/odbc/linux .
  2. Copy files from the lib directory to a safe location and add the corresponding path to LD_LIBRARY_PATH environment variable in your configuration.
    For 32-bit users, the library is located in the copied directory at:
    /linux/ThirdParty/icu/icu-53.1/Linux_x86/lib
    For 64-bit users, the library is located at:
    /linux/ThirdParty/icu/icu-53.1/Linux_x8664/lib
  3. Open the file odbc.ini in the editor of your choice. Find Servers in the file and replace 127.0.0.1 with the IP address of each node on the ThoughtSpot Analytic Search Appliance, leaving the port number as 12345.
    They syntax for Servers is:
    Servers = <node1> 12345, <node2> 12345 [, <node3> 12345, ...]
    For example:
    [ThoughtSpot]
    Description = ThoughtSpot 32-bit ODBC Driver
    Driver = ThoughtSpot
    Servers = 192.168.2.249 12345, 192.168.2.148 12345, 192.168.2.247 12345
    Locale = en-US
    ErrorMessagesPath = /usr/local/scaligent/toolchain/local/simba/linux/ErrorMessages
    UseSsl = 0
    #SSLCertFile = # Set the SSL certificate file path. The certificate file can be obtained by extracting the SDK tarball
    #LogLevel = 0 # Set log level to enable debug logging
    #LogPath = # Set the debug log files path
    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 Analytic Search Appliance.
  • Was this article helpful?