Show TOC

To create a local SAP HANA connectionLocate this document in the navigation structure

Context

In Analysis, you can create a local connection to an SAP HANA server. A local SAP HANA connection is created in the Select Data Source dialog.

Procedure

  1. Select the cell in the Analysis worksheet.
  2. Select Start of the navigation path Insert Data Source Next navigation step Select Data Source... End of the navigation path in the Analysis ribbon.
  3. Select Skip to go to the local system connections.
  4. Select Create New SAP HANA Connection... in the context menu in the Description area.

    The New SAP HANA Connection dialog box appears.

  5. Enter a description for the new local HANA connection.
  6. Select a scheme: HTTP or HTTPS

    We recommend to use HTTPS.

  7. Enter a Host Name.
  8. Enter a Port.

    The default HTTP port settings for SAP HANA XS include an SAP HANA instance number: 80<SAP HANA instance>, for example 8001. You can change the default settings, for example, to ensure that standard ports 80 and 443 are used for client access to the SAP HANA XS Web server by HTTP (80) or HTTPS (443).

    For more information, see chapter Maintain Standard HTTP Port Numbers with SAP HANA XS in the SAP HANA Administration Guide.

  9. Select an Authentication Type:
    • Basic

      When this type is selected for the connection, the end user will be prompted with a dialog box to enter a user ID and password.

    • X.509 Client Certificate

      Authentication with X.509 Certificates makes use of a Public Key Infrastructure (PKI) to securely authenticate users. In this case, user authentication takes place using the underlying Secure Sockets Layer (SSL) protocol and users do not need to interactively enter a password for logon.

    • Kerberos

      The Kerberos authentication process involves several systems connected in a network, or a Kerberos realm. Kerberos authentication within a realm works on the basis of “tickets”, which serve to prove the authenticity of client requests. Kerberos authentication makes use of a trusted third party system called Key Distribution Center (KDC).

    For more information, see chapters User Authentication and Single-Sign On and Maintaining Single Sign-On for SAP HANA XS Applications in the SAP HANA Administration Guide.

  10. Select Create or Create and Logon... to create the connection.

Results

The new connection is available in the Select Data Source dialog.

You can also edit and delete existing local SAP HANA connections in this dialog.