The OneCloud SAP HANA JDBC BizApp enables OneCloud to natively integrate with the SAP HANA system. Combining the ability to perform HANA database operations across other applications including Tableau and Power BI and performance management applications such as Anaplan, IBM Planning Analytics, Host Analytics, and Oracle EPM, allows OneCloud customers to tightly and bi-directionally integrate their data stored in the HANA database with other apps.
For documentation on all available commands, see the SAP HANA JDBC Command Reference.
Need a specialized SAP HANA command?
If there are specific SAP HANA operations that your company is looking to perform, please contact email@example.com to discuss the requirements and we would be happy to consider adding the capability to the product.
To enable OneCloud to interact with a relational system, you'll need to navigate to the connection manager to create a connection.
From here, choose SAP HANA JDBC from the service drop-down and select the appropriate Runner.
The username to authenticate with.
The password to authenticate with.
The connection url. (e.g jdbc:sap://<server>:<port>[/?<options>])
SAP HANA JDBC Port
The default SAP HANA JDBC port is 30015 but could be different depending on your environment.
SAP HANA JDBC Connection Parameters
Visit SAP's documentation to learn more about additional connection parameters that can be leveraged.
The following is an example of a working connection. Please substitute your own values.