ThoughtSpot logo
Software
Cloud ThoughtSpot
Everywhere Seekwell

Software

    • About our releases
      • Release notes
      • Mobile release notes
      • Fixed issues
      • Accessibility
      • Deprecation announcements
      • 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
        • 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 into 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
      • 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
        • Apache Parquet 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
        • 中文 (简体): Chinese 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
      • 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
          • S3: Average period for semi-additives II
        • Pinboard schedule gating conditions in practice
  • Cloud
    • 8.3.0.cl
    • 8.2.0.cl
  • Home
    • master
  • Software
    • 7.2
    • 7.1
    • 7.0
    • 6.3
    • 6.2
    • 6.1
    • 6.0
  • Software
  • Embrace
  • SAP HANA
7.2 7.1 7.0 6.3 6.2 6.1 6.0
Was this page helpful?

Give us feedback!
×

SAP HANA overview

Embrace enables you to connect to SAP HANA databases, to use your data in ThoughtSpot.

  • Add a connection

  • Modify a connection

  • Reference

SAP HANA version 2.0 or later is required.
Home Page

ThoughtSpot is the Search & AI-driven Analytics platform for the enterprise. Anyone can use search to analyze company data in seconds and get automated insights when you need them.

Product
  • Product
  • SpotIQ
  • Mobile
  • Embedded Analytics
  • Architecture
  • Pricing
Solutions
  • Overview
  • Retail
  • Financial Services
  • Manufacturing
  • Communications
  • Healthcare
  • Embedded Analytics
  • Procurement
  • Government Analytics
Resources
  • Overview
  • Demo Videos
  • Analyst Reports
  • Webinars
  • Case Studies
  • White Papers
  • Datasheets
  • Solution Briefs
About Us
  • Team
  • Customers
  • Atlas Marketplace
  • Partner Directory
  • Events
  • News
  • Careers
  • Blog
  • Legal
Connect
  • Request Demo
  • Community
  • Support
  • Contact Us

(800) 508-7008

Thoughtspot on Twitter Thoughtspot on Facebook Thoughtspot on LinkedIn

(800) 508-7008

Thoughtspot on Twitter Thoughtspot on Facebook Thoughtspot on LinkedIn
©2022 ThoughtSpot Inc.
All Rights Reserved
Terms of Use Privacy Statement Cookie Policy