SAP HANA

Easily talk to your "Systems, Applications, and Products" In-Memory database

Create a role and a user for Dot

Create a dedicated user and role for Dot to access SAP HANA Cloud tables. Replace <schema_name>, <table_name> with the name of your schema and tables.

SET SCHEMA <schema_name>
CREATE USER DOT_USER
CREATE ROLE DOT_ROLE
GRANT SELECT ON SCHEMA <schema_name> TO DOT_ROLE
GRANT DOT_ROLE TO DOT_USER

It is recommended to grant permissions only to tables your end-users should have access to. These typically include core business tables and reporting tables.

If you need to grant access to a particular table, run the following command:

GRANT SELECT ON <schema_name>.<table_name> TO <user_or_role>

How to connect to the free SAP HANA Cloud instance

  1. Sign-in to the SAP BTP Cockpit using the following credentials:

    • username: rick@sled.so

    • password: ;75r_#=5B!zM5F%

  2. Select SLED_HANA_FREE Subaccount under the Account Explorer

  1. Select SLED_HANA_SPACE under Cloud Foundry->Spaces

  1. Select SAP HANA Cloud on the left panel, you will see the hana-free instance

  1. Open SAP HANA Cloud Central, check the current status of the SAP HANA instance. Run Start if needed. By default the instance is stoped on the nightly basis.

For more info on how to start with the SAP HANA free instance check out: Provision an Instance of SAP HANA Cloud, SAP HANA Database.

Allow Dot IPs:

To connect your SAP HANA Cloud instance with Dot, configure it to allow Dot to access it through the following IPs.

  • 3.229.110.216

  • 3.122.135.165

Last updated