Explains what the feature is or what its benefits are to the user or customer.
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. Information on using the ThoughtSpot Loader is available in the ThoughtSpot Administrator Guide.
To ensure compatibility, always use the JDBC driver with the same version number as the ThoughtSpot instance to which you are connecting.
- 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.