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

The ODBC driver supports these data types:
  • INT
  • BIGINT
  • BOOLEAN
  • DOUBLE
  • FLOAT
  • DATE
  • TIME
  • TIMESTAMP
  • DATETIME
  • CHAR
  • VARCHAR
Important: The ETL tool must add a data transformation step if the source column data type does not exactly match the target's, ThoughtSpot's, column data type. The driver does not do any implicit conversions.
  • Was this article helpful?