With the SAP HANA® JDBC connector, you can use commands in a chain to perform structured query language (SQL) operations in SAP high-performance analytic appliance (HANA). For example, with this connector, you can:
- Execute SQL commands, including a
CREATE
orUPDATE
statement orSELECT
query - Retrieve details about a table in SAP HANA
- Insert records into the SAP HANA database
Note: This connector is built by Workiva and connects to a third-party system. While our Support team can help configure this connector within your workspace, we are unable to troubleshoot or otherwise assist with any issues that originate outside of the Workiva platform.
Prerequisites
To enable the connection to SAP HANA, the connector uses Java database connectivity (JDBC), secured with basic username and password authentication. To set up the connector, you'll need:
- A designated integration user created in SAP HANA for the connector
- The integration user's username and password
- The JDBC connection's URL, such as
jdbc:sap://<server>:<port>[/?<options>]
- To connect to an on-premises instance of SAP HANA, a GroundRunner for the connection
Note: To connect to a cloud instance of SAP HANA, use the default CloudRunner.
Set up the SAP HANA JDBC connector
Note: To make the connector available for use in your organization's chains, an org security administrator first enables it from Configuration.
- From Chain Builder, click Connections , and then Create at the top right.
- Under BizApp Connection, select SAP HANA JDBC and the runner to use with the connection.
- Under Basic Info, enter a unique name and description to help identify the connection.
- Under Properties, enter the connector's details:
Property Details Username Enter the username of the connector's SAP HANA integration user. Password Enter the password for the Username property. Connection URL Enter the URL for the JDBC connection with any optional properties appended as a query string, such as jdbc:sap://localhost:<server>:<port>/?<options>
. For example, to disable the connection's latency and timeout,jdbc:sap://localhost:30015/?latency=0&communicationtimeout=0
.Note: By default, the port is
30015
; however, this may be different for your environment.Note: All sensitive credentials are automatically encrypted and stored at Advanced Encryption Standard (AES)-256 encryption. For security purposes, avoid including user credentials as optional properties within the Connection URL input.
- Select the environments to use with the connection, and click Save.
- To test the connection, create and run a chain with the connector's Get Table Definition command, and verify it returns a valid output.
Troubleshooting
If the connection to SAP HANA fails:
- Verify the integration user's authentication credentials
- Check the URL for the JDBC connection, including its server and port
If the connection fails to perform a command, verify its inputs—such as its SQL syntax or table—are valid.