Accessing data from SAP HANA

You can connect to and access data from SAP HANA in Spotfire.

What is required to connect to SAP HANA in Spotfire?

Preparations

Before you start, read the System requirements for Spotfire Connectors. Make sure that the SAP HANA data source that you want to connect to is compatible with your version of Spotfire. The system requirements page also specifies what driver, and versions of the driver, that you can use with the connector.

Installing the driver

To be able to connect to SAP HANA data sources in Spotfire, you must install the required ODBC driver on your computer.

For instructions on how to download and install the required driver, see Drivers and data sources in Spotfire.

Connecting to SAP HANA

When you want to connect to SAP HANA, you can either open and reuse a connection that is shared in your Spotfire library, or you can create a new connection.

Adding data from an existing connection to SAP HANA

If you want to add data from an existing connection or connection data source that is shared in your Spotfire library, you can use the search function in the Files and data flyout to quickly find the data you are looking for.
Use the search phrase 'connector:hana' to find all shared connections and connection data sources in the library that were created with the SAP HANA connector. For more detailed instructions, see How to work with Data Connections and their Data Sources in the Library.

To create a new connection to SAP HANA:

  1. Click Files and data .

  2. In the Files and data flyout, click Connect to.

  3. In the list of connectors, click SAP HANA.

  4. In the SAP HANA flyout, click New connection.

  5. In the SAP HANA Connection dialog, enter the connection information your SAP HANA instance. Then click Connect.

    Comment: For information about the settings in the dialog, see Details on SAP HANA Connection.

  6. In the Views in Connection dialog, select the data you want to analyze.

    1. In the Available tables in database list, select the tables you want to analyze in Spotfire and click Add >, or create a Custom Query to select your data.

      Comment: See Creating Custom Queries for more information about how to add custom queries.

    2. You can add related tables to the view by right-clicking on a table in the Views in connection list and selecting Add Related Tables. You can also add custom relations between two tables, to create a single view based on the tables in Spotfire.

      Comment: See the topic Structural Relations for more information.

    3. If desired, you can prompt the end users of the analysis to select specific values in the data only (for example, you can prompt to select data for a single region or product only). You also use prompts to give input values for any SAP HANA parameters defined for your selected data. Add prompting by clicking Define Prompting... and specifying new prompts for suitable columns or parameters.

  7. When you are happy with your data selection, click OK to close the Views in Connection dialog.

  8. The final step is a summary view of the resulting data tables that will be added to your Spotfire analysis. Here you can select whether to load the data from SAP HANA as Imported or External data tables.

  9. Click OK.

    Response: Any defined prompts will be shown, and as soon as the input has been provided, data is ready to be analyzed in Spotfire.

Troubleshooting

This section lists useful information about requirements, limitations, and best practices for accessing data from SAP HANA.

Granting access to XSA/HDI views

For views and tables that have been created with XS Advanced, through the SAP WebIDE, to be accessible in Spotfire, certain privileges must be set up for your database user. Your database administrator must grant your database user "SELECT", "SELECT CDS METADATA" and "EXECUTE" privileges.

For multidimensional data, your database user must have "SELECT" privilege for the "_SYS_BI" schema.

See the official documentation from SAP for more information. Some helpful tips can be found, for example, in this SAP blog post.  

HINTS to optimize metadata loading

If it is taking a long time to load the list of tables and schemas in the Views in Connection dialog, the reason could be that the loading of metadata is slow.

You might be able to improve metadata loading performance with HINTS. HINTS is a feature in SAP HANA, with which you can include a WITH HINT clause in queries to guide how to get metadata.

You can configure Spotfire to add HINTS to metadata queries to SAP HANA. Use this preference setting in the Administration Manager:

Connectors > SAP HANA > MetadataQueryHints

Note: For information about how to use SAP HANA HINTS, see the official documentation for SAP HANA.

Limitations

When you access data from SAP HANA in Spotfire, keep the following limitations in mind.

 

See also:

SAP HANA Data Types

Supported Functions