Skip to main content

SAP HANA

SAP HANA

How to create a source with SAP HANA​

This section explains how to connect Crestone with SAP HANA systems. You’ll learn how to configure the connection parameters, authenticate securely, and ensure data is extracted efficiently from your HANA environment.

1. Select the source type:​

Select the "SAP HANA" option for the source type.

Select the source type

2. Enter SAP HANA credentials:​

You will be prompted to enter the credentials needed to connect to your SAP HANA system.

Enter SAP HANA credentials:

  1. Host Address: Enter the host address of the SAP HANA system. This is typically the IP address or DNS name of the SAP HANA server. You can obtain this from your system administrator or the SAP HANA system’s network settings.

  2. Port Number: Enter the port number used for the SAP HANA connection. The default port for SAP HANA is usually 30015 for a standard instance. However, the port may vary depending on your system configuration. You can obtain this from the system administrator.

  3. User Name: Enter the SAP HANA username you use to log in to the system. Ensure that the username has the necessary permissions for accessing the SAP HANA system. This can be the same username you use for logging into SAP HANA Studio or other HANA client tools. If you don't have a username, contact your system administrator.

  4. Password: Enter the password associated with the SAP HANA username. This is the same password you use when logging into the SAP HANA system. If you don't have it or need to reset it, contact your system administrator.

3. Test the connection:​

  • Click the "Test Connection" button to verify that the connection to the SAP HANA system has been successfully established.
  • If the test is successful, the system will enable additional configuration options.

Test the connection:

4. Create the connection:​

Finally, click the "Create Source" button to establish the connection to SAP HANA.

Create the connection

Connection Parameters​

ParameterDescriptionExample
Host AddressIP or DNS of the SAP HANA serverhana.company.com
Port NumberSystem port (default 30015)30015
User NameUser with access permissions to the HANA systemhana_user
PasswordPassword of the HANA user— (hidden)