Skip to main content

 

ThoughtSpot

About the ODBC Driver

Overview

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

Feature

You can use the ThoughtSpot ODBC driver to bring data into ThoughtSpot from your ETL tool or database.

Prerequisites

ThoughtSpot comes packaged with an ODBC (Open Database Connectivity) driver, so that you can transfer data between ThoughtSpot and other databases. Basic knowledge of ODBC data source administration is helpful when setting up ODBC.

Supported operating systems for the ODBC driver are:
  • Microsoft Windows 32-bit
  • Microsoft Windows 64-bit
  • Linux 32-bit
  • Linux 64-bit
  • Solaris Sparc 32-bit
  • Solaris Sparc 64-bit

Version Compatibility

To ensure compatibility, always use the ODBC driver with the same version number as the ThoughtSpot instance to which you are connecting.

Supported Data Types

When you bring data in to ThoughtSpot using the ODBC driver, any necessary data type conversions are done for you. The ODBC driver supports these data types:
  • INT
  • BIGINT
  • BOOLEAN
  • DOUBLE
  • FLOAT
  • DATE
  • TIME
  • TIMESTAMP
  • DATETIME
  • CHAR
  • VARCHAR
  • Was this article helpful?