Connecting to Relational Data from SAP HANA


When you are connecting to a SAP HANA data source, you can choose whether to work with the relational data or if you instead want to connect to predefined information views. See Connecting to Information Views from SAP HANA for more information about information views.

  1. Select File > Add Data Tables.

  2. Click Add.

  3. Select Connection To > SAP HANA.

  4. Under Connect to, click Relational data.

  5. Make other configurations needed for the connection and click Connect.

    Comment: See Details on SAP HANA Connection for information about the settings in the dialog. Depending on the Authentication method selected, you may need to provide a Username and a Password to continue.

    Response: The Views in Connection dialog is opened.

  6. 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.

    Response: The selected tables are added to the Views in connection list.

  7. 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.

  8. 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). Add prompting by clicking Define Prompting and specifying new prompts for suitable columns or parameters.

  9. When the configuration is done, click OK to close the Views in Connection dialog.

  10. In the Add Data Tables dialog, specify the Load method and click OK.

    Comment: With relational data, you can select whether to import the data table or keep the data table external, for each of the resulting views in the data connection.

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

See also:

SAP HANA Data Types

Supported Functions