Prerequisites
Before you start, you will need the following information from SAP HANA.- Host (endpoint without the port or database name)
- Port (the port used to connect to your database)
- User (the username of the service account)
- Password (the password for the service account user)
- Database Name (the database name of your service)
- SSL, if active (toggle “Connect through TLS” switch)
- Show System Schemas (enable the switch to display style schemas)
Connecting SAP HANA to Upsolve
- Navigate to your project in Upsolve and open Project settings → Connections.
- Select your data source from the Connect data cards to begin.
- The SAP Hana connection form opens with SAP Hana preselected.
-
Fill out the data source details form as shown in the image below, including:
- Host (endpoint without the port or database name)
- Port (the port used to connect to your database)
- User (the username of the service account)
- Password (the password for the service account user)
- Database Name (the database name of your service)
- Connect Through TLS (toggle switch if SSL is active)
- Show System Schemas (enable its switch to display style schemas)
- Click “Test & Create Connection” to establish the data source.
Congratulations! You’ve successfully created a new data source between SAP HANA and Upsolve. You can now access and manage your SAP HANA data seamlessly within the Upsolve platform.