Explains what the feature is or what its benefits are to the user or customer.
Use this procedure to obtain the Linux ODBC driver and install it.
The installation packages for clients can be downloaded from the Help Center.
- Create a file called /etc/simbaclient.ini and add the following text to it:
- You can download the ODBC driver by going to the Help Center.
If the Help Center is unreachable, you can copy the clients directly from the ThoughtSpot instance by issuing:
- Click Help from the ThoughtSpot Web interface.
- Click Downloads.
- Click ODBC Driver for Linux to download the file
- Unzip and untar the file:
gunzip ThoughtSpot_linux_odbc_<version>.tar.gz tar -xvf ThoughtSpot_linux_odbc_<version>.tar
scp -r admin@<appliance_IP>:/usr/local/scaligent/toolchain/local/simba/odbc/linux .
- Copy the library files from the Lib directory to a safe location on your Linux machine. Add the corresponding path to the LD_LIBRARY_PATH environment variable. For 32-bit users, the library files are located in the directory:
/linux/Lib/Linux_x86For 64-bit users, the library is located at:
- Open the file
/linux/Setup/odbc.iniin the editor of your choice.
- Find the section for the type of Linux you are using (32-bit or 64-bit), by looking at the
Description. Then find the line below it that begins with
ServerList, and replace 127.0.0.1 with a comma separated list of the IP addresses of each node on the ThoughtSpot instance. Leave the port number as 12345.They syntax for
ServerList = <node1_IP> 12345, <node2_IP> 12345 [, <node3_IP> 12345, ...]For example, for the 64-bit ODBC driver:
[ThoughtSpot] Description = ThoughtSpot 64-bit ODBC Driver Driver = ThoughtSpot ServerList = 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/odbc/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 pathIf you need to obtain the IP addresses of the nodes in the cluster, you can run the command
tscli node lsfrom the Linux shell on the ThoughtSpot instance.
- Open the file
/linux/Setup/odbcinst.iniin the editor of your choice.
- Update the the line that starts with
Driverto have the path to the file
libSimbaClient.so(Use the path where you copied the library files).For example, for the 64-bit ODBC driver:
[ThoughtSpot(x64)] APILevel = 1 ConnectFunctions = YYY Description = ThoughtSpot 64bit ODBC driver Driver = /usr/local/scaligent/toolchain/local/simba/odbc/linux/Bin/Linux_x8664/libSimbaClient.so DriverODBCVer = 03.52 SQLLevel = 1
- Save the file. Now you can test your ODBC connection.