This article describes how to connect Tableau to an SAP HANA database and set up the data source.
Before installing the SAP HANA client on a supported UNIX, macOS, or Linux operating system, review the available supported clients and the default installation paths. We use cookies and similar technologies to give you a better experience, improve performance, analyze traffic, and to personalize content. UAC UCCSS HELP LICENSE KEYS. WINDOWS MAC SAP Hana Business Intelligence/Business Objects. The SAP Download Manager is a free-of-charge tool that allows you to download multiple files simultaneously, or to schedule downloads to run at a later point in time. Software found in your download basket is visible in the SAP Download Manager. Note that to download software the Software Download authorization is required.
Note: Beginning with Tableau version 2020.2, this connector for Linux and Mac uses a JDBC driver. For Windows, this connector still uses an ODBC driver.
Before you begin
Before you begin, gather this connection information:
Driver required
This connector requires a driver to talk to the database. You might already have the required driver installed on your computer. If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download(Link opens in a new window) page where you can find driver links and installation instructions.
Make the connection and set up the data source
Sign in on a Mac
If you use Tableau Desktop on a Mac, when you enter the server name to connect, use a fully qualified domain name, such as mydb.test.ourdomain.lan, instead of a relative domain name, such as mydb or mydb.test.
Alternatively, you can add the domain to the list of Search Domains for the Mac computer so that when you connect, you need to provide only the server name. To update the list of Search Domains, go to System Preferences > Network > Advanced, and then open the DNS tab.
Convert an SAP HANA level hierarchy to a user hierarchy
In all Tableau versions, when you create an SAP HANA data source or workbook, you can create your own hierarchy in Tableau thatâs solely for use in Tableau.
Starting in Tableau 2019.4, in addition to support for creating your own hierarchy for use in Tableau, Tableau now supports level hierarchies created in SAP HANA. This means that when you connect Tableau to an SAP HANA calculation view with a level hierarchy, the structure of the SAP HANA level hierarchy appears in the Data pane.
If you want to modify the SAP HANA level hierarchy in Tableau, you need to convert the SAP HANA level hierarchy to a user hierarchy. After you convert an SAP HANA level hierarchy to a user hierarchy, you can't reverse it. If you decide you want to use the SAP HANA level hierarchy instead of the user hierarchy, you need to start over.
To convert to a user hierarchy, follow these steps:
Customize JDBC connections
On Mac and Linux, SAP HANA uses a JDBC connection, which you can customize using a properties file. For more information, see Customize JDBC Connections Using a Properties File(Link opens in a new window) in Tableau Community.
Install trusted SSL certificates on a Mac
If you want to use SSL/TLS to encrypt communications between Tableau Desktop and your database, you may need to add certificates to the Java certificate trust store. This is required if your database uses self-signed certificates.
Note: Beginning with Tableau version 2020.2, you can import a custom certificate into the 'System' keychain. For details, see One-Way SSL for JDBC Connections.
To connect Tableau Desktop to your database using SSL/TLS, follow these steps:
For more information on installing trusted certificates, consult the documentation for your Java Runtime Environment.
Select variables and input parameters
If the table you use includes required or optional variables or parameters, the Variables and Input Parameters dialog box opens.
Select a variable or parameter and type or select a value for it. Gopro studio desktop download mac. Repeat for all required values and any optional values that you want to include, and then select OK.
Note: You can use SQL query-based SAP HANA prompts.
![]() Support for SAP HANA single sign-on (SSO)
When SAP HANA is configured to support single sign-on (SSO), after you sign in to the SAP HANA server, you can access data, and publish data sources and workbooks to Tableau Server, without having to re-enter your user name and password. And, you can publish a data source or workbook so that other users with SSO can access the published data sources and workbooks without having to enter their user names and passwords.
To use SSO, you need to publish data sources and workbooks to Tableau Server with Viewer credentials authentication. To enable Viewer credentials authentication, you must connect to SAP HANA using Windows Authentication on a Windows computer or Kerberos on a Mac. For more information, see Publish to the Server.
Important: Your environment must be correctly configured to support SSO for SAP HANA:
Sign in to the server
When SSO is set up in your environment, to sign in to SAP HANA, simply enter the server name, select Use Windows Authentication on a Windows computer or Kerberos on a Mac, and then click Sign In.
Publish to the Server
In an SSO environment, users donât have to enter their credentials to access a data source or a workbook if you publish it to Tableau Server with the correct authentication mode.
To enable SSO when you publish a data source or workbook to Tableau Server, follow these steps:
How to refresh HANA extracts when you use SSO
When you use single sign-on (SSO) to connect to SAP HANA, because of authentication restrictions, you can't schedule an extract refresh when you publish the data source or workbook to a server. You can, however, use the Tableau Data Extract Utility to automate the extract refresh task.
For example, the following command refreshes an SAP HANA extract named 'mydatasource' that has been published to Tableau Server. This command specifies the following:
C:Program FilesTableauTableau 10.2bin>tableau refreshextract --server https://mytableauserver --datasource mydatasource
For more information about the utility, see Tableau Data Extract Command-Line Utility.
Performance tips
You can improve performance by enabling one or both of these capabilities:
The following sections describe how to use these features.
Use bind variables
Tableau can use bind variables for your SAP HANA queries. This improves performance:
To enable this feature, your Tableau Server Administrator can add the CAP_ODBC_QUERY_USE_PREPARE_PARAMETER_MARKER capability in a TDC file.
Notes: This feature requires Tableau 2018.3 or later.
Despite its name, CAP_ODBC_QUERY_USE_PREPARE_PARAMETER_MARKER can be used with JDBC as well as ODBC. Use shared metadata cache
Tableau relies heavily on SAP HANA metadata, which in turn may be complex, and therefore difficult (slow) to retrieve.
Tableau supports a shared metadata cache. In many cases, and especially with single sign-on (SSO), it maybe useful to share a metadata cache between database users. This can improve performance.
When Tableau shares the metadata cache, these things are true:
One possible risk: If you have developed a process where different column names display depending upon the User/Group, then a user might see too few or too many columns.
To enable this feature, your Tableau Server Administrator can add these capabilities using the following TSM commands:
Note: This feature requires Tableau 2019.2 or later. For more information about TSM files, see Tableau Services Manager Overview.
Use column metadata collection
Tableau supports column metadata collection, resulting in great load-time improvements for some views.
When Tableau reads the column metadata for a table or view, it uses a prepared query on the table by default. This is usually the most accurate option, but may not be the most efficient.
Optionally, you can use column metadata collection. That is, you can disable prepared query metadata using a TDC file. When you do this, Tableau uses the ODBC API, SQLColumns. While this method is faster, it may not be as accurate. That is why you should use this option cautiously and only when it seems like a good approach for your data.
Using column metadata via SQLColumns is enabled using these capabilities:
Note: To apply these capabilities to temporary tables, you must install Tableau Server 2019.3.6 or later. Then you can add those capabilities to the TDC file.
TDC example for SAP HANA
Your TDC file should look like the following example. In most cases, you will need no other capabilities. In particular, be sure to avoid capabilities such as CAP_ODBC_METADATA_SUPPRESS_SQLPRIMARYKEYS_API and CAP_ODBC_METADATA_SUPPRESS_SQLFORIEGNKEYS_API. These may speed up the initial connection time, but will cause us to generate less efficient queries later.
For more information about using TDC files, see 'Create a TDC file' in the Customize and Tune ODBC Connections topic. Also see the Knowledge Base article called Using a TDC File with Tableau Server.
Important: Be sure enabled=âtrueâ is part of your connection-customization line.
See also
United States
Or see our complete list oflocal country numbers
Call Me NowCall Offline
SAP can call you to discuss any questions you have.
Chat NowChat Offline
Get live help and chat with an SAP representative.
Install your free SAP HANA, express edition
* Learn more about how to check RAM on a Windows computer (see: https://developers.sap.com/tutorials/hxe-ram-disk-ms.html ) or on a Mac computer (see: https://developers.sap.com/tutorials/hxe-ram-disk-mac.html ).
Export Control Restrictions
You acknowledge that the Software is subject to the export control laws and regulations of the United States of America, including any amendments thereof, and may include technical data also subject to export and re-export restrictions imposed by U.S. law. You confirm you will not export or re-export the Software, directly or indirectly, either to:
Sap Hana Client Mac Download Windows 10
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |