Skip to main content

 

ThoughtSpot

About the JDBC Driver

Overview

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

Feature

Java Database Connectivity (JDBC) is a Java standard API that allows applications to interact with databases in a standard manner. ThoughtSpot has JDBC support via a JDBC driver we provide.

When to use JDBC

JDBC can be used whenever you want to connect to ThoughtSpot to insert data programmatically from a Java program or application. You should begin by using the ThoughtSpot Loader for initial data loads and then use JDBC for incremental loads. This is because the ThoughtSpot Loader is generally faster than JDBC.

Performance Considerations

These are some general recommendations for maximizing the performance of JDBC:
  • Insert in batches rather than doing single inserts at a time using the PreparedStatement::addBatch() and PreparedStatement::executeBatch commands.
  • If you need to upload a lot of data, consider running multiple connections with batch inserts in parallel.
  • Was this article helpful?