ThoughtSpot logo
Software
Cloud Mobile Spotter ThoughtSpot
Embedded SeekWell

Software

    • About our releases
      • Release notes
      • Mobile release notes
      • Fixed issues
      • Accessibility
      • Deprecated and removed features
      • More help and support
        • ThoughtSpot support
        • Contact ThoughtSpot support
        • Configure support services
        • ThoughtSpot Support Handbook
        • Support Handbook PDF
    • Users
      • Business User
      • Analyst
      • Data Engineer
      • IT and Ops
      • Developer
    • Getting started
      • User onboarding experience
      • Finding your way around
      • ThoughtSpot browser access
      • Your user preferences
      • Use tags to organize
      • Privileges
        • Granular access to pinboards
    • 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
      • Ask an expert
        • Manage Ask an Expert requests
        • Retrieve Ask an Expert answers
        • Answer an expert question
      • Results that are tables
      • Keyword searches
        • Time series analysis
        • 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
        • Replay search
    • Understand charts
      • Chart types
        • Column charts
        • Stacked column charts
        • Bar charts
        • Stacked bar charts
        • Line 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
        • 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
    • 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
        • Filtered aggregation functions
      • Conversion functions
      • Date functions
      • Simple number calculations
      • Percent calculations
      • Formula operators
      • Nested formulas
      • Formulas for chasm traps
    • Pinboards
      • Follow a pinboard
      • Edit a pinboard
      • Pinboard filters
      • Linked pinboard filters
      • Selective pinboard filters
      • Answer Explorer
      • Schedule a pinboard job
      • Search actions within a pinboard
      • Delete a visualization
      • Copy a pinboard
      • Copy a pinboard or visualization link
      • Reset a pinboard or visualization
      • Present a pinboard as a slideshow
      • Download as PDF
      • Model, migrate, or restore pinboards
    • Custom R in ThoughtSpot
      • Create and share R scripts
      • Run prebuilt R scripts on answers
      • Save and share R visualizations
    • SpotIQ
      • Best practices
      • Monitor headlines
      • Comparative analysis
      • Custom SpotIQ analysis
      • Advanced R customizations
      • Insight feedback
      • SpotIQ preferences
    • Work with data
      • Append data through the UI
      • View a data profile
      • Set your ThoughtSpot locale
      • Share your work
        • Share a pinboard
        • Share answers
        • Share uploaded data
        • Request object access
        • Revoke access (unshare)
    • Administration
      • Log in credentials
      • Admin console
        • Managing users
        • Managing groups
        • Local authentication
        • Authentication through SAML
        • Authentication through Active Directory
        • Configure SSL
        • Configure a reverse SSH tunnel
        • Set the relay host for SMTP (email)
        • Customize ThoughtSpot help
        • Customize actions
        • Style customization
        • Configure NAS for backup storage
        • Manage and create snapshots
        • System cluster pinboard
        • System alerts pinboard
        • User adoption pinboard
        • Available cluster updates
      • 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
        • Set up recording for Replay Search
        • 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
      • Scheduled jobs: pinboard schedule management
      • System monitoring
        • Overview board
        • Data board
        • Cluster manager board
        • Alerts and events board
        • System worksheets
          • TS:BI Server worksheet
        • System pinboards
        • Falcon monitor pinboards
        • Performance tracking pinboard
      • Troubleshooting
        • Get logs
        • Upload logs to 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
      • 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
      • Configure NAS file system
      • Set up monitoring
      • Configure support services
      • Network ports
      • Configure load balancing and proxies
      • Customize look and feel
    • Load and manage data
      • 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
        • Examples of schema creation
        • Upload a SQL script
      • Change the schema
        • Convert column data type
      • Import CSV files with tsload
      • Load data with a script
      • Load data with a tsload connector
      • Delete a data source (table)
      • Delete or change a table in TQL
    • 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
    • Security
      • ThoughtSpot lifecycle
      • System security
        • Tools and processes
        • Third-party security software
          • Installing third-party software
      • Data security
        • Share tables and columns
        • Share worksheets
        • Share views
        • Share pinboards
        • 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
    • Improve search with modeling
      • Change a table’s data model
      • Edit the system-wide data model
      • Data model 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
    • Worksheets
      • Creating worksheets
      • Editing or renaming worksheets
      • Create a formula in a worksheet
      • Create worksheet filters
      • How the worksheet join rule works
      • Change join rule or RLS for a worksheet
      • Create a join relationship
      • Modify joins between worksheet tables
      • Delete worksheets or tables
      • Model, migrate, or restore worksheets
      • Worksheet TML specification
    • Work with views
      • Save a search as a view
      • Create a search from a view
      • View example scenarios
      • About materialized views
      • Materialize a view
      • Dematerialize a view
      • Refresh a view
      • Model, migrate, or restore views
      • Schedule view refreshes
    • Migrating TS objects
      • Scriptability
      • TML: ThoughtSpot Modeling Language
      • SpotApps
    • Mobile
      • Deploy
      • Install and set up
      • FAQ
      • Release notes
    • Embedding
      • Log in to the Linux shell using SSH
      • Log in credentials
      • Use the JavaScript API
      • SAML
        • Configure SAML
        • Configure CA SiteMinder
        • Configure Active Directory Federated Services
      • Data REST API
        • Calling the REST API
        • REST API pagination
        • Use the data REST API to get data
        • Use the embedded search API
        • Use the data push API
      • Embed ThoughtSpot
        • Embed pinboard or visualization
        • Authentication flow with embed
        • Full application embedding
        • Configure trusted authentication
      • Runtime filters
        • Apply a runtime filter
        • Runtime filter operators
    • Software deployment
      • Amazon Linux 2 deployments
        • Amazon Linux 2 prerequisites
        • ThoughtSpot deployment artifacts for Amazon Linux 2
        • Online Amazon Linux 2 install
        • Offline Amazon Linux 2 install
        • Amazon Linux 2 upgrade
        • Adding new nodes to clusters in Amazon Linux 2
        • Packages installed with Amazon Linux 2
      • RHEL support
        • RHEL prerequisites
        • ThoughtSpot deployment artifacts for RHEL
        • Online RHEL install
        • Offline RHEL install
        • RHEL upgrade
        • Add new nodes to clusters on RHEL
        • Packages installed with RHEL
      • 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
    • Embrace
      • Amazon Redshift
        • Add a connection
        • Modify a connection
        • Best practices
        • Reference
      • Azure Synapse
        • Add a connection
        • Modify a connection
        • Reference
      • Google BigQuery
        • Prerequisites
        • Add a connection
        • Modify a connection
        • Reference
      • SAP HANA
        • Add a connection
        • Modify a connection
        • Reference
      • Snowflake
        • Add a connection
        • Modify a connection
        • Best practices
        • Reference
        • Snowflake Partner Connect
          • Tutorials
      • Teradata
        • Add a connection
        • Modify a connection
        • Reference
    • DataFlow
      • Key features
      • How DataFlow works
      • DataFlow home page
      • Requirements and guidelines
      • DataFlow security
        • DataFlow encryption reference
      • Database connections
        • Amazon Aurora in DataFlow
          • Connect
          • Sync
          • Reference
        • Amazon Redshift 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
        • Google BigQuery in DataFlow
          • Connect
          • Sync
          • Reference
        • Hive in DataFlow
          • Connect
          • Sync
          • Reference
        • IBM Db2 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
        • Netezza in DataFlow
          • Connect
          • Sync
          • Reference
        • Oracle in DataFlow
          • Connect
          • Sync
          • Reference
        • PostgreSQL in DataFlow
          • Connect
          • Sync
          • Reference
        • Presto 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
        • Teradata in DataFlow
          • Connect
          • Sync
          • Reference
      • File system connections
        • Amazon S3 in DataFlow
          • Connect
          • Sync
          • Reference
        • Azure Blob Storage in DataFlow
          • Connect
          • Sync
          • Reference
        • Flat Files in DataFlow
          • Connect
          • Sync
          • Reference
        • Google Cloud Storage in DataFlow
          • Connect
          • Sync
          • Reference
        • HDFS in DataFlow
          • Connect
          • Sync
          • Reference
      • Application connections
        • Salesforce in DataFlow
          • Connect
          • Sync
          • Reference
        • REST APIs in DataFlow
          • Connect
          • Sync
          • Reference
      • Administration of DataFlow
        • Manage DataFlow users
        • DataFlow mail setup
    • 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
      • Keyword reference
        • Dansk: Danish keyword reference
        • Deutsch: German keyword reference
        • English (American) keyword reference
        • Español (España): Spanish keyword reference
        • Español (Latinoamérica): Spanish keyword reference
        • Français (Canada): French (Canadian) keyword reference
        • Français (France): French keyword reference
        • Italiano: Italian keyword reference
        • Nederland: Dutch keyword reference
        • Norsk: Norwegian keyword reference
        • Português (Portugal): Portuguese keyword reference
        • Português (Brasil): Portuguese (Brazil) keyword reference
        • Suomi: Finnish keyword reference
        • Svenska: Swedish keyword reference
        • 中文 (简体): Chinese (Simplified) keyword reference
        • 日本語: Japanese keyword reference
      • Data types
      • API Reference
        • Pinboard data API
        • Metadata API
        • Session API
        • User API
        • Group API
        • Materialization API
        • Search data API
      • 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
      • ThoughtSpot in practice
        • Reaggregation in practice
          • S1: Supplier tendering by job
          • S2: Average rates of exchange
          • S3: Average period for semi-additives I
          • S4: Average period for semi-additives II
        • Pinboard schedule gating conditions in practice
  • Cloud
    • 10.3.0.cl
    • 10.1.0.cl
    • 10.0.0.cl
    • 9.12.5.cl
  • Home
    • master
  • Mobile
    • 3.0.0
  • SeekWell
    • latest
  • Software
    • 9.8.0.sw
    • 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
  • Spotter
    • 10.4.0.cl
  • Software
  • DataFlow
  • Database connections
  • IBM Db2 in DataFlow
9.8.0.sw 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

IBM Db2 connections in DataFlow

DataFlow enables you to connect to an IBM Db2 database, to use your data in ThoughtSpot.

  • Add a connection

  • Sync data

  • Reference

Was this page helpful?Give us feedback!
×

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

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