Connect to SAP Hana

1. Get SAP Hana Details & Whitelist Retool IP Address

Your SAP Hana system administrator will likely have your database connection details. You'll need to get them to whitelist the Retool IP address.

📘

SSH Tunneling

If you are not able to whitelist Retool's IP in SAP Hana, you might consider using SSH Tunneling which is supported by our SAP Hana integration. More information here.

2. Add to Retool

Create a new resource in Retool, and select "SAP Hana" as the type.

Enter your database connection details. Your connection string will be of the format:

jdbc:sap://host:port/?user=DBADMIN&password=mypassword

You may also need to include a parameter for your databaseName, depending on your SAP Hana setup.

3. Create Queries

You can now select your newly-created SAP Hana resource from the Resource dropdown when creating queries in your Retool apps.

You can display the results of SAP Hana queries as with any other query in Retool: