ThoughtSpot logo
Software
Cloud ThoughtSpot
Everywhere Seekwell

Software

    • About our releases
      • Release notes
      • Mobile release notes
      • Fixed issues
      • Known issues
      • Accessibility
      • Deprecated and removed features
      • Release life cycle
      • Downloads
      • More help and support
      • ThoughtSpot Support
        • Contact ThoughtSpot Support
        • Configure support services
        • ThoughtSpot Support Handbook
        • Support Handbook PDF
      • EOS and EOL announcements
        • Release end-of-service
        • CentOS end-of-life
      • Users and workflows
        • Business User
        • Analyst
          • Analyst onboarding
          • Create worksheets in Setup
          • Create answers in Setup
        • Data Engineer
        • IT and Ops
        • Developer
      • Getting started
        • User onboarding experience
        • Search Assist
        • Finding your way around
        • ThoughtSpot browser access
        • Your user preferences
        • Use tags to organize
        • Privileges
          • Granular access to Liveboards
      • Third-party software
        • Full list CSV
    • Search
      • Start a new search
      • Choose a data source
      • Search bar features
      • Search suggestions
      • Search results and column types
      • Last data refresh time
      • Work with answers
      • Model, migrate, or restore answers
      • Results that are tables
      • Keyword searches
        • Time series analysis
        • Date filters for Answers and Liveboards
        • Search using growth over time
        • Subquery search (in keyword)
        • 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 to a table
        • Download your search
    • Answers and Liveboards
      • New Answer experience
      • New Liveboard experience
      • Using parameters
      • Charts
        • Chart types
          • Column charts
          • Stacked column charts
          • Bar charts
          • Stacked bar charts
          • Line charts
          • KPI charts
          • Pie charts
          • Area charts
          • Stacked area charts
          • Scatter charts
          • Bubble charts
          • Pareto charts
          • Waterfall charts
          • Treemap charts
          • Heatmap charts
          • Line column charts
          • Line stacked column charts
          • Funnel charts
          • Geo charts
            • Geo area charts
            • Geo bubble charts
            • Geo heatmap charts
          • Pivot table
          • Sankey charts
          • Radar charts
          • Candlestick charts
      • Changing charts
        • Change axes options
        • Configure the columns
        • Rename columns and axes
        • Customize titles and descriptions with HTML
        • Reorder the labels
        • Set the y-axis range
        • Hide and show values
        • Charts and tables with a very large number of data values
        • Change chart colors
        • Show data labels
        • Show data markers
        • Add regression lines
        • Display gridlines
        • Disable automatic selection of chart type
        • Zoom into a chart
      • Liveboards
        • Edit a Liveboard
        • Liveboard note tiles
        • Liveboard filters
        • Linked Liveboard filters
        • Selective Liveboard filters
        • Mandatory Liveboard filters
        • Liveboard cross filters
        • Verify Liveboards
        • Answer Explorer
        • Schedule a Liveboard job
        • Search actions within a Liveboard
        • Delete a visualization
        • Copy a Liveboard
        • Copy a Liveboard or visualization link
        • Reset a Liveboard or visualization
        • Present a Liveboard as a slideshow
        • Download as PDF
        • Model, migrate, or restore Liveboards
      • Formulas
        • Add a formula to search
        • View or edit a formula in a search
        • Aggregate formulas
          • Cumulative functions
          • Moving functions
          • Flexible aggregation functions
          • Grouping functions
          • Keywords “of”, “percentage of”
          • Filtered aggregation functions
        • Conversion functions
        • Date functions
        • Simple number calculations
        • Percent calculations
        • Formula operators
        • Nested formulas
        • Formulas for chasm traps
      • Custom R in ThoughtSpot
        • Create and share R scripts
        • Run prebuilt R scripts on answers
        • Save and share R visualizations
      • SpotIQ
        • Best practices
        • Comparative analysis
        • Custom SpotIQ analysis
        • Advanced R customizations
        • Insight feedback
        • SpotIQ preferences
    • Work with data
      • Data workspace
        • Append data through the UI
        • View a data profile
        • Set your ThoughtSpot locale
        • Share your work
          • Share a Liveboard
          • Share answers
          • Share uploaded data
          • Request object access
          • Revoke access (unshare)
      • Work with worksheets
        • Create worksheets
        • Edit or rename worksheets
        • Create parameters
        • Custom groups
        • Create a formula in a worksheet
        • Add a filter to a worksheet
        • How the worksheet join rule works
        • Change join rule or RLS for a worksheet
        • Create a join relationship
        • Modify joins within a worksheet
        • Create worksheet onboarding lessons with Search Assist Coach
        • Delete a worksheet or table
        • Model, migrate, or restore a worksheet
      • Work with views
        • SQL views
        • Save a search as a view
        • Create a search from a view
        • View example scenarios
        • Materialized views
        • Materialize a view
        • Dematerialize a view
        • Refresh a materialized view
        • Model, migrate, or restore views
        • Schedule view refreshes
      • Load and manage data
        • Integrate with dbt
          • Metadata tags for dbt
        • Configure casing
        • Load CSV files with the UI
        • How to view a data schema
        • Plan the schema
          • Data types
          • Constraints
          • Sharding
          • Chasm traps
        • Build the schema
          • Connect with TQL and create a schema
          • Create a schema in SQL
          • Schema creation examples
          • Upload and run a SQL script
        • Change the schema
          • Convert column data type
        • Import CSV files with tsload
        • Load data with a script
        • Load data with the tsload connector
        • Delete a data source (table)
        • Delete or change a table in TQL
    • Modeling
      • Improve search with modeling
        • Change a table’s data model
        • Edit the system-wide data model
        • Data modeling settings
          • Set column name, description, and type
          • Set additive and aggregate values
          • Hide a column
          • Define a synonym
          • Exclude columns from SpotIQ analyses
          • Manage suggestion indexing
          • Add a geographical data setting
          • Set number, date, currency formats
          • Change the attribution dimension setting
        • Link tables using relationships
          • Create a relationship
          • Delete a relationship
      • 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 SQL views
        • TML for tables
        • TML for views
        • TML for Worksheets
    • Administration
      • Login credentials
      • Admin console
        • Managing users
        • Managing groups
        • Local authentication
        • Authentication through SAML
        • Authentication through Active Directory
        • Managing search and SpotIQ settings
        • Managing email and onboarding settings
        • Configure SSL
        • Configure a reverse SSH tunnel
        • Set the relay host for SMTP (email)
        • Customize ThoughtSpot help
        • Style customization
        • Configure NAS for backup storage
        • Manage and create snapshots
        • System cluster Liveboard
        • System alerts Liveboard
        • System information and usage Liveboard
        • Table status Liveboard
        • User adoption Liveboard
        • Performance tracking Liveboard
      • Style customization
        • Upload application logos
        • Set chart and table visualization fonts
        • Choose a background color
        • Select chart color palettes
        • Change the footer text
      • System administration
        • Send logs when reporting problems
        • Upgrade a cluster
      • Choose the backup strategy
        • Understand backup/snapshot schedules
        • Work with snapshots
        • Backup modes
          • Create a manual backup
          • Configure periodic backups
          • About restore operations
      • Liveboard schedule management
      • System monitoring
        • System information and usage Liveboard
        • Table status Liveboard
        • Cluster manager board
        • Alerts and events board
        • System worksheets
        • System Liveboards
        • Falcon monitoring Liveboards
        • Object usage Liveboard
      • Troubleshooting
        • Get logs
        • Upload logs to ThoughtSpot Support
        • Generate a HAR file for ThoughtSpot Support
        • Network connectivity issues
        • Check the timezone
        • Browser untrusted connection error
        • Characters not displaying correctly
        • Clear the browser cache
        • Cannot open a saved answer that contains a formula
        • Data loading too slowly
        • Search results contain too many blanks
      • Disaster recovery
        • Disk failure
        • Node failure
        • HA and resilience
        • Cluster replacement
        • Mount a NAS file system
        • Configure disaster recovery
      • Architectural components
        • Data caching
        • Authentication
        • Data and object security
        • Performance considerations
        • In-memory data compression
      • Installation and setup
        • Set your locale
        • Test connectivity between nodes
        • ThoughtSpot use agreement
        • Allow users to request access
        • Set the relay host for SMTP
        • Set up custom calendars
        • Configure internal authentication
        • Configure SSL
        • Configure SAML
        • Configure SAML group mapping
        • Enable SSH through Active Directory
        • Integrate LDAP
          • Configure authentication through Active Directory
          • Add the SSL certificate for LDAP
          • Test the LDAP configuration
          • Sync users and groups from LDAP
        • OpenID Connect authentication
        • Configure NAS file system
        • Set up monitoring
        • Configure support services
        • Network ports
        • Configure load balancing and proxies
        • Customize look and feel
      • Manage users and groups
        • Onboarding users
        • Understand groups and privileges
        • Create, edit, or delete a group
        • Create, edit, or delete a user
        • Allow users to sign up
      • Enable Early Access features
      • Security
        • ThoughtSpot lifecycle
        • System security
          • Tools and processes
            • Collect security logs
          • Third-party security software
            • Installing third-party software
        • Data security
          • Share tables and columns
          • Share worksheets
          • Share views
          • Share Liveboards
          • Share answers
          • Revoke access (unshare)
          • Security for SpotIQ functions
        • Row-level security (RLS)
          • How rule-based RLS works
          • Set rule-based RLS
        • Encryption of data in transit
    • Mobile
      • Deploy
      • Install and set up
      • FAQ
      • Release notes
    • Embed ThoughtSpot
      • Embedding
      • Log in to the Linux shell using SSH
      • Use the JavaScript API
      • SAML
        • Configure SAML
        • Configure CA SiteMinder
        • Configure Active Directory Federated Services
      • Understand embedding
        • Embed Liveboard or visualization
        • Authentication flow with embed
        • Full application embedding
        • Configure trusted authentication
    • Runtime filters
      • Apply a runtime filter
      • Runtime filter operators
    • REST APIs
      • Get started
      • Calling the REST API
      • REST API pagination
      • Use the Data REST API to get data
      • Use the Embedded Search API
    • Deployment
      • Deploying ThoughtSpot on your own OS
        • Prerequisites for deploying ThoughtSpot on your own OS
        • ThoughtSpot artifacts for deploying on your own OS
        • Contents of the ansible tarball for deployment on your own OS
        • Run the offline script for deployment on your own OS
        • Configure and run the ansible playbook
        • Deploy ThoughtSpot clusters on your own OS
        • Upgrading ThoughtSpot on your own OS to a new release
        • Adding new nodes to clusters running on your own OS
        • Packages installed with ThoughtSpot running on your own OS
      • Manage cluster operations on ansible for clusters that use RHEL
        • Create a cluster
        • Restore a cluster
        • Start or stop a cluster
        • Upgrade a cluster
        • Add a node to a cluster
        • Delete a cluster
      • Hardware appliance
        • Deploying on the SMC appliance
          • Prerequisites
          • Hardware requirements
          • Connect the appliance
          • Configure nodes
          • Install cluster
        • Deploying on the Dell appliance
          • Prerequisites
          • Hardware requirements
          • Connect the appliance
          • Configure management settings
          • Configure nodes
          • Install cluster
      • Cloud deployment
        • Cloud deployment on AWS
          • Set up AWS resources for ThoughtSpot
          • Prepare AWS VMs for ThoughtSpot
          • Configure ThoughtSpot nodes in AWS
          • Install ThoughtSpot clusters in AWS
          • Set up high availability
          • Back up and restore using S3
        • Cloud deployment on Microsoft Azure
          • Set up ThoughtSpot in Azure
          • Configure ThoughtSpot nodes in Azure
          • Install ThoughtSpot clusters in Azure
        • Cloud deployment on GCP
          • Set up ThoughtSpot in GCP
          • Configure ThoughtSpot nodes in GCP
          • Install ThoughtSpot clusters in GCP
          • Back up and restore a GCP cluster using GCS
      • VMware deployment
        • Set up ThoughtSpot in VMware
        • Configure ThoughtSpot nodes in VMware
        • Install ThoughtSpot clusters in VMware
      • Network ports
      • Consumption-based pricing
        • Query-based usage
          • User actions and queries
          • Subscription and rollover
        • Time-based usage
        • Consumption data storage
    • Connections
      • Share a connection
      • ThoughtSpot query tags
      • Amazon Aurora MySQL
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete a table with dependencies
        • Delete connection
        • Reference
      • Amazon Aurora PostgreSQL
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete a table with dependencies
        • Delete connection
        • Reference
      • Amazon RDS MySQL
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete a table with dependencies
        • Delete connection
        • Reference
      • Amazon RDS PostgreSQL
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete a table with dependencies
        • Delete connection
        • Reference
      • Amazon Redshift
        • Add connection
        • Edit connection
        • Remap connection
        • Query external tables
        • Delete table
        • Delete a table with dependencies
        • Delete connection
        • Configure Azure AD external OAuth for a Redshift connection
        • Configure AWS Secrets Manager
        • Best practices
        • Reference
      • Azure Synapse
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete a table with dependencies
        • Delete connection
        • Configure OAuth
        • Reference
      • Databricks
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete a table with dependencies
        • Delete connection
        • Configure OAuth
        • Reference
      • Denodo
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Configure OAuth
        • Reference
      • Dremio
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Configure OAuth
        • Reference
      • 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
        • Reference
      • MySQL
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • Oracle
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • PostgreSQL
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • Presto
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • SAP HANA
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • SingleStore
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • Snowflake
        • Add connection
        • Edit connection
        • Remap connection
        • Query external tables
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Configure OAuth
        • Configure Okta OAuth
        • Configure Azure AD OAuth
        • Best practices
        • Reference
        • Snowflake Partner Connect
          • Tutorials
      • SQL Server
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • Starburst
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Configure OAuth
        • Reference
      • Teradata
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • Trino
        • Add connection
        • Edit connection
        • Remap connection
        • Delete table
        • Delete table with dependencies
        • Delete connection
        • Reference
      • Passthrough functions
      • Custom calendar
        • Create custom calendar
        • Update custom calendar
        • Delete custom calendar
      • 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
    • DataFlow
      • Key features
        • Database connections
        • File System connections
        • Application connections
      • How DataFlow works
      • DataFlow home page
      • Requirements and guidelines
      • DataFlow security
        • DataFlow security reference
      • DataFlow tips
      • Administration of DataFlow
        • Manage DataFlow users with SSO
        • DataFlow mail setup
        • Other global properties
      • Amazon Aurora in DataFlow
        • Connect
        • Sync
        • Reference
      • Amazon Redshift in DataFlow
        • Connect
        • Sync
        • Reference
      • Amazon S3 in DataFlow
        • Connect
        • Sync
        • Reference
      • Azure Blob Storage in DataFlow
        • Connect
        • Sync
        • Reference
      • Azure Synapse in DataFlow
        • Connect
        • Sync
        • Reference
      • Cassandra in DataFlow
        • Connect
        • Sync
        • Reference
      • Databricks Delta Lake in DataFlow
        • Connect
        • Sync
        • Reference
      • Denodo in DataFlow
        • Connect
        • Sync
        • Reference
      • Dremio in DataFlow
        • Connect
        • Sync
        • Reference
      • Exadata in DataFlow
        • Connect
        • Sync
        • Reference
      • Flat Files in DataFlow
        • Connect
        • Sync
        • Reference
      • Google BigQuery in DataFlow
        • Connect
        • Sync
        • Reference
      • Google Cloud Storage in DataFlow
        • Connect
        • Sync
        • Reference
      • Google Sheets in DataFlow
        • Connect
        • Sync
        • Reference
      • Greenplum in DataFlow
        • Connect
        • Sync data
        • Reference
        • Utilities
      • HDFS in DataFlow
        • Connect
        • Sync
        • Reference
      • Hive in DataFlow
        • Connect
        • Sync
        • Reference
      • IBM Db2 in DataFlow
        • Connect
        • Sync
        • Reference
      • Impala in DataFlow
        • Connect
        • Sync
        • Reference
      • JDBC in DataFlow
        • Connect
        • Sync
        • Reference
      • MariaDB in DataFlow
        • Connect
        • Sync
        • Reference
      • MongoDB in DataFlow
        • Connect
        • Sync
        • Reference
      • MySQL in DataFlow
        • Connect
        • Sync
        • Reference
      • Memsql in DataFlow
        • Connect
        • Sync data
        • Reference
      • Netezza in DataFlow
        • Connect
        • Sync
        • Reference
      • Oracle in DataFlow
        • Connect
        • Sync
        • Reference
      • PostgreSQL in DataFlow
        • Connect
        • Sync
        • Reference
      • Presto in DataFlow
        • Connect
        • Sync
        • Reference
      • REST APIs in DataFlow
        • Connect
        • Sync
        • Reference
      • Salesforce in DataFlow
        • Connect
        • Sync
        • Reference
      • SAS in DataFlow
        • Connect
        • Sync
        • Reference
      • SAP Adaptive Server Enterprise in DataFlow
        • Connect
        • Sync
        • Reference
      • SAP HANA in DataFlow
        • Connect
        • Sync
        • Reference
      • SAP SQL Anywhere in DataFlow
        • Connect
        • Sync
        • Reference
      • SQL Server in DataFlow
        • Connect
        • Sync
        • Reference
      • Snowflake in DataFlow
        • Connect
        • Sync
        • Reference
      • Splice Machine in DataFlow
        • Connect
        • Sync
        • Reference
      • Splunk in DataFlow
        • Connect
        • Sync data
        • Reference
      • Teradata in DataFlow
        • Connect
        • Sync
        • Reference
      • Vertica in DataFlow
        • Connect
        • Sync
        • Reference
    • Data integration
      • JDBC and ODBC setup prerequisites
      • ODBC driver client
        • ODBC on Windows
          • Configure multiple connections on Windows
          • Deploy SSL with ODBC on Windows
          • Set up the ODBC Driver for SSIS
        • Install the ODBC Driver on Linux
        • Best practices for using ODBC
      • JDBC driver client
        • Use the JDBC driver
      • Set up the JDBC driver for Pentaho
      • Troubleshooting data integrations
        • Enable ODBC logs
        • Enable JDBC logs
        • Schema not found error with ODBC
        • How to improve throughput
        • ODBC tracing on Windows
        • SQL commands in ODBC and JDBC
        • Connection configuration for ODBC and JDBC
    • Reference
      • REST API 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
      • Data types
      • TQL reference
        • TQL service reference
      • tsload reference
        • tsload connector API reference
        • tsload flag reference
      • tscli command reference
      • Date and time formats reference
      • Row-level security rules reference
      • Formula function reference
      • Alerts code reference
      • User action code reference
      • Stop word reference
      • Geo map reference
      • Glossary
      • Frequently asked questions
      • Deployment reference
        • Cable reference
        • Network ports
        • The nodes.config file
        • Parameters of the nodes.config file
        • Using the tscli cluster create command
        • Parameters of the tscli cluster create command
        • Site survey PDF
    • Google Sheets add-ons
  • Cloud
    • 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
  • Software
  • Connections
  • SQL Server
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
Was this page helpful?

Give us feedback!
×

SQL Server overview

You can connect to a SQL Server database in ThoughtSpot Software, and perform live queries to create Answers and Liveboards.

  • Add a SQL Server connection

  • Edit a SQL Server connection

  • Remap a SQL Server connection

  • Delete a table from a SQL Server connection

  • Delete a table with dependent objects

  • Delete a SQL Server connection

  • Connection reference for SQL Server

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