ThoughtSpot logo
Cloud
Software ThoughtSpot
Everywhere Seekwell -->

Cloud

    • About this release
      • Release notes
      • Accessibility
      • Deprecated and removed features
      • Release life cycle
    • Getting started
      • Requirements and support
      • Activate your account using IAMv2
      • User onboarding experience
      • Finding your way around
      • Web notifications
      • ThoughtSpot browser access
      • Your user preferences
      • Use tags to organize
    • Free Trial
      • What’s new
      • Load CSV files
    • ThoughtSpot for…​
      • Business Users
        • Business user onboarding
        • Home page
        • Search Answers
        • Search Data
        • New answer experience
        • New Liveboard experience
        • Using Liveboards and Answers
        • Collaborative Liveboards
        • Using Parameters
        • Search Assist
        • AI-suggested searches
        • Natural language search
        • Best practices
        • Ask Sage
        • ThoughtSpot Sync
          • Sync data to Gainsight
          • Sync data to Google Sheets
          • Sync data to HubSpot
          • Sync data to Microsoft Teams
          • Sync data to Redshift
          • Sync data to Salesforce
          • Sync data to ServiceNow
          • Sync data to Snowflake
          • Sync data to Slack
          • Sync data to Zoho
        • Privileges
        • Google Sheets add-ons
        • Google Slides add-on
      • Analysts
        • Analyst onboarding
        • Connect to data
        • Join tables
        • Create Worksheets in Setup
        • Create Worksheets
        • Search Assist Coach
        • Sage Coach
        • Visualize search results
        • Create Answers in Setup
        • Create a Liveboard
        • Liveboard note tiles
        • Glean integration
        • Collaborative Liveboards
        • Linked Liveboard filters
        • Selective Liveboard filters
        • Mandatory Liveboard filters
        • Liveboard cross filters
        • Personalized Liveboard views
        • Create Parameters
        • Custom groups
        • SpotApps
          • Deploying SpotApps
            • Databricks Storage and Performance SpotApp
            • DEI Workforce Diversity SpotApp
            • Facebook Ads SpotApp
            • GBQ Performance and Consumption SpotApp
            • Google Ad Analysis SpotApp
            • Google Analytics SpotApp
            • HubSpot Email Marketing SpotApp
            • Jira Issue Management SpotApp
            • Jira Sprint Management SpotApp
            • LinkedIn Ads SpotApp
            • Okta Application Management SpotApp
            • Procurement Vulnerability Analysis for SAP SpotApp
            • Redshift Performance and Consumption SpotApp
            • Salesforce Pipeline Analysis SpotApp
            • ServiceNow Incident Management SpotApp
            • Snowflake Performance and Consumption SpotApp
            • Snowflake Query Profiling SpotApp
        • Disable Answer Search for specific Worksheets
        • How users are searching Answers Liveboard
      • Data Engineers
        • About connections
          • Share a connection
          • ThoughtSpot query tags
          • Column indexing with OAuth
        • Connect to Amazon Athena
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Amazon Athena
        • Connect to Amazon Aurora MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon Aurora MySQL
        • Connect to Amazon Aurora PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon Aurora PostgreSQL
        • Connect to Amazon RDS MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon RDS MySQL
        • Connect to Amazon RDS PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon RDS PostgreSQL
        • Connect to Amazon Redshift
          • Add connection
          • Edit connection
          • Remap connection
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure Azure AD OAuth
          • Best practices
          • Enable a PrivateLink
          • Connection reference
          • Redshift Partner Connect overview
          • Passthrough functions for Redshift
        • Connect to Azure Synapse
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Connection reference
          • Passthrough functions for Synapse
        • Connect to Databricks
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Databricks Partner Connect overview
          • Passthrough functions for Databricks
        • Connect to Denodo
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Denodo
        • Connect to Dremio
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Dremio
        • Connect to Generic JDBC
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Generic JDBC
        • Connect to Google AlloyDB for PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google AlloyDB for PostgreSQL
        • Connect to Google BigQuery
          • Prerequisites
          • Access levels and ingress rules for Google BigQuery
          • Add connection
          • Edit connection
          • Remap connection
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Connection reference
          • Passthrough functions
        • Connect to Google Cloud SQL for MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for MySQL
        • Connect to Google Cloud SQL for PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for PostgreSQL
        • Connect to Google Cloud SQL for SQL Server
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for SQL Server
        • Connect to Looker Modeler
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
        • Connect to MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for MySQL
        • Connect to Oracle
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Oracle
        • Connect to PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for PostgreSQL
        • Connect to Presto
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Presto
        • Connect to SAP HANA
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for SAP HANA
        • Connect to SingleStore
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for SingleStore
        • Connect to Snowflake
          • Add connection
          • Edit connection
          • Remap connection
          • Upload CSV
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Configure Azure AD OAuth
          • Configure Okta OAuth
          • Configure CSV Upload
          • Best practices
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions
          • Snowflake Partner Connect overview
          • Snowflake Partner Connect tutorials
        • Connect to SQL Server
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for SQL Server
        • Connect to Starburst
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Starburst
        • Connect to Teradata
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Teradata
        • Connect to Trino
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Trino
        • Custom calendar
          • Create custom calendar
          • Update custom calendar
          • Delete custom calendar
        • AWS PrivateLink
          • Enable a PrivateLink for Amazon Redshift
          • Enable a PrivateLink for Databricks
          • Enable a PrivateLink for Denodo
          • Enable a PrivateLink for Dremio
          • Enable a PrivateLink for Oracle
          • Enable a PrivateLink for PostgreSQL
          • Enable a PrivateLink for SAP HANA
          • Enable a PrivateLink for Snowflake
          • Enable a PrivateLink for SQL Server
          • Enable a PrivateLink for Starburst
          • Enable a PrivateLink for Teradata
        • Query external tables
          • Query external tables from your Amazon Redshift connection
          • Query external tables from your Google BigQuery connection
          • Query external tables from your Snowflake connection
        • Integrate with dbt
          • Metadata tags for dbt
        • Catalog integration
      • IT and Ops
        • Managing users
        • Managing groups
        • Understand RBAC and privileges
        • Granular access to Liveboards
        • Authentication overview
        • Managing local authentication
        • Identity and Access Management V2
        • Managing authentication with SAML
        • Managing authentication with SAML using IAMv2
        • Configure SAML group mapping
        • Search and SpotIQ settings
        • Email and onboarding settings
        • Scheduled maintenance
        • Style customization
        • Help customization
        • AWS PrivateLink
          • Enable a PrivateLink for Amazon Redshift
          • Enable a PrivateLink for Databricks
          • Enable a PrivateLink for Denodo
          • Enable a PrivateLink for Dremio
          • Enable a PrivateLink for Oracle
          • Enable a PrivateLink for PostgreSQL
          • Enable a PrivateLink for SAP HANA
          • Enable a PrivateLink for Snowflake
          • Enable a PrivateLink for SQL Server
          • Enable a PrivateLink for Starburst
          • Enable a PrivateLink for Teradata
        • OpenVPN for Google BigQuery
        • OpenVPN for Azure Synapse and Snowflake on Azure
        • Configure IPSec VPN for your cloud data connection
        • OIDC authentication
        • Custom domain configuration
        • Performance Tracking Liveboard
        • User Adoption Liveboard
        • Object Usage Liveboard
        • Billable Query Stats Liveboard
        • Indexing Queries Liveboard
        • Index Statistics Liveboard
        • ThoughtSpot use agreement
      • Developers
        • Embedded analytics
        • Integration guidelines
        • ThoughtSpot Developer Portal
        • Authentication and security
        • Visual Embed SDK
        • Custom actions
        • Customization and rebranding
        • REST APIs
        • Runtime filters
    • Search
      • Search Answers
      • Search Data
      • Search basics
        • Choose a data source
        • Search bar features
        • Search suggestions
        • Search results and column types
        • Last data refresh time
        • Work with Answers
        • Results that are tables
      • Use keywords in search
        • Time series analysis
        • Date filters for Answers
        • Search using growth over time
        • Using the keyword in for nested searches
        • Proximity search: near and farther than
      • Work with filters
        • Add a filter to a table
        • Add a filter to a chart
        • Create a bulk filter
        • Delete a filter
        • Filter on null, blank, or empty values
      • Other search actions
        • Change result display options
        • Show underlying data
        • See the search behind a result
        • Apply conditional formatting
        • Download your search
      • ThoughtSpot Sage
    • Charts
      • Chart types
        • Column charts
        • Stacked column charts
        • Line charts
        • KPI charts
        • Pivot table
        • Donut charts
        • Bar charts
        • Stacked bar charts
        • Line column charts
        • Area charts
        • Stacked area charts
        • Line stacked column charts
        • Scatter charts
        • Bubble charts
        • Waterfall charts
        • Heatmap charts
        • Treemap charts
        • Funnel charts
        • Geo charts
          • Geo bubble charts
          • Geo heatmap charts
          • Geo area charts
        • Sankey charts
        • Radar charts
        • Candlestick charts
        • Pareto charts
      • Changing charts
        • Change axes options
        • Configure the columns
        • Rename columns and axes
        • Customize titles and descriptions with HTML
        • Reorder labels
        • Set the y-axis range
        • Hide and show values
        • Charts with a large number of data values
        • Change chart colors
        • Show data labels
        • Show data markers
        • Add regression lines
        • Display gridlines
        • Zoom into chart
        • Advanced chart customization settings
      • Custom charts
    • Formulas
      • Add formula to search
      • View or edit formula in search
      • Aggregate formulas
        • Cumulative functions
        • Moving functions
        • Flexible aggregation functions
        • Grouping functions
        • Keywords “of”, “percentage of”
        • Filtered aggregation functions
        • Aggregate filters
        • Conversion functions
        • Date functions
        • Percent calculations
        • Formula operators
        • Nested formulas
        • Formulas for chasm traps
    • Liveboards
      • Edit Liveboard layouts
      • Liveboard tabs
      • Liveboard filters
      • Personalized Liveboard views
      • Verified Liveboards
      • Answer Explorer
      • AI highlights
      • Schedule a Liveboard job
      • Search actions within a Liveboard
      • Copy a Liveboard
      • Copy a Liveboard or visualization link
      • Reset a Liveboard visualization
      • Present Liveboard as slideshow
      • Download as PDF
    • SpotIQ
      • Monitor KPI
      • Webhooks for Monitor
      • Custom SpotIQ analysis
      • SpotIQ change analysis
      • Anomaly detection
      • SpotIQ preferences
      • Insight feedback
      • Best practices for SpotIQ Analyze
    • Mobile
      • Deploy
      • Install and set up
      • FAQ
      • Release notes
    • Work with data
      • Set your display language (locale)
    • Share your work
      • Share Liveboards
      • Share Answers
      • Request access
      • Revoke access
    • Help and support
      • Contact support
    • Modeling
      • Improve search with data modeling
        • Change a table’s data model
        • Edit system-wide data model
        • Data model settings
          • Set column name, description, and type
          • Set additive and aggregate values
          • Hide a column or define a synonym
          • Manage suggestion indexing
          • Add a geographical data setting
          • Upload custom geo maps
          • Set number, date, and currency formats
          • Change the attribution dimension
          • Exclude from SpotIQ analyses
          • Chasm traps
          • Data types
        • Link tables using relationships
          • Create a relationship
          • Delete a relationship
          • Use tags
      • Content migration with ThoughtSpot Modeling Language
        • Import and export TML files
        • Migrate multiple TML files
        • TML for Answers
        • TML for joins
        • TML for Liveboards
        • TML for Monitor alerts
        • TML for SQL views
        • TML for tables
        • TML for views
        • TML for Worksheets
    • Administration
      • Support Handbook
      • High Availability and resilience
      • Data Protection and Disaster Recovery
      • Multi-tenancy with Orgs
        • Orgs administration
        • Create, edit, or delete a user in a multi-tenant environment
        • Create, edit, or delete a group in a multi-tenant environment
        • Admin Console for Orgs
          • Create, edit, and delete Orgs
          • Managing users in a multi-tenant environment
          • Managing groups in a multi-tenant environment
          • Managing local authentication
          • Managing authentication with SAML
          • User Adoption Liveboard
          • Performance Tracking Liveboard
          • Managing search and SpotIQ settings
          • Managing email and onboarding settings
          • Style customization
          • Scheduled maintenance
      • Manage data
        • How to view a data schema
        • Delete a data source
      • Manage users and groups
        • Understand groups and privileges
        • Create, edit, or delete a group
        • Create, edit, or delete a user
        • Create, edit, or delete a user using IAMv2
        • Manage user logins and sessions
        • Allow users to sign up
      • Enable Early Access features
      • Security
        • System security
        • Data security
          • Data and object security
          • Share tables and columns
          • Share Worksheets
          • Share views
          • Share Liveboards
          • Share Answers
          • Revoke access
        • Row-level security
          • How rule-based RLS works
          • Set rule-based RLS
        • ThoughtSpot lifecycle
      • Simplify search with Worksheets
        • Edit a Worksheet
        • Create a formula in a Worksheet
        • Create a Worksheet filter
        • How the Worksheet join rule works
        • Create join rule or RLS for a Worksheet
        • Create a join relationship
        • Modify joins between Worksheet tables
        • Delete Worksheets or tables
        • Migrate or restore Worksheets
        • Worksheet TML specification
      • Work with views
        • SQL-based views
        • Save a search as a view
        • Create a search from a view
        • View example scenarios
      • Manage scheduled jobs
        • Scheduled Liveboards management
      • Monitoring
        • System Worksheets
        • System Liveboards
      • Troubleshooting
        • Generate a HAR file for ThoughtSpot Support
        • Network connectivity issues
        • Clear the browser cache
        • Cannot open a saved Answer that contains a formula
        • Search results contain too many blanks
      • Consumption-based pricing
        • Query-based usage
          • User actions and queries
          • Subscription and rollover
          • Billable Query Stats Liveboard
        • Time-based usage
        • Consumption data storage
      • Contact ThoughtSpot Support
    • Reference
      • Keyword reference
        • 中文 (简体): Chinese (Simplified) keyword reference
        • 中文 (简体): Chinese (Traditional) keyword reference
        • Dansk: Danish keyword reference
        • Nederland: Dutch keyword reference
        • Suomi: Finnish keyword reference
        • English (American) keyword reference
        • Français (France): French keyword reference
        • Français (Canada): French Canadian keyword reference
        • Deutsch: German keyword reference
        • Italiano: Italian keyword reference
        • 日本語: Japanese keyword reference
        • Norsk: Norwegian keyword reference
        • Português (Portugal): Portuguese keyword reference
        • Português (Brasil): Portuguese Brazilian keyword reference
        • Español (España): Spanish keyword reference
        • Español (Latinoamérica): Spanish Latin American keyword reference
        • Svenska: Swedish keyword reference
      • Date and time formats reference
      • Row-level security rules reference
      • Formula function reference
      • Alert codes reference
      • User action codes reference
      • Geo map reference
      • REST API reference
      • Glossary
      • Frequently asked questions
    • ThoughtSpot in practice
      • Reaggregation in practice
      • Liveboard schedule gating conditions in practice
      • Add a hyperlink to a search
  • Cloud
    • 9.9.0.cl
    • 9.7.0.cl
    • 9.6.0.cl
    • 9.5.0.cl
  • Home
    • master
  • SeekWell
    • latest
  • Software
    • 9.5.0.sw
    • 9.0.1.sw
    • 8.8.sw
    • 8.4.sw
    • 7.2
    • 7.1
    • 7.0
    • 6.3
    • 6.2
    • 6.1
    • 6.0
  • Cloud
  • ThoughtSpot for…​
  • Data Engineers
  • Connect to Generic JDBC
9.9.0.cl 9.7.0.cl 9.6.0.cl 9.5.0.cl
Was this page helpful?

Give us feedback!
×

Generic JDBC overview

You can connect to a Generic JDBC database in ThoughtSpot Cloud, and perform live queries to create Answers and Liveboards.

  • Add a Generic JDBC connection

  • Edit a Generic JDBC connection

  • Remap a Generic JDBC connection

  • Delete a table from a Generic JDBC connection

  • Delete a table with dependent objects

  • Delete a Generic JDBC connection

  • Connection reference for Generic JDBC

ThoughtSpot is the Modern Analytics Cloud company. Our Live Analytics services deliver personalized, actionable insights at the point of impact for every user, at every level.

Product
  • Product
  • Auto Analyze
  • Visualize
  • Connect
  • Operationalize
  • Embed
  • Mobile
  • Govern & Secure
  • New features
  • Pricing
By Role
  • Business Leader
  • Data Leader
  • Analyst
  • Product Leader
  • Developer
By Department
  • Marketing
  • Sales
  • ServiceNow Analytics
Solutions
  • Banking
  • Financial Services
  • Retail & E-commerce
  • Manufacturing & Logistics
  • Healthcare & Life Sciences
  • Media & Communications
  • Procurement
  • Public Sector
About Us
  • Team
  • Customers
  • Atlas Marketplace
  • Partner Directory
  • Events
  • News
  • Careers
  • Blog
  • Legal
  • Trust
Connect
  • Free Trial
  • Resources
  • Request Demo
  • Professional Services
  • Community
  • Support
  • Contact Us

(800) 508-7008

©2023 ThoughtSpot Inc. All Rights Reserved
Terms of Use Privacy Statement Cookie Policy