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