Connect to SAP Hana Database

Document created by sheng_liao462475 Employee on Nov 30, 2016Last modified by chris_stevens on Jan 3, 2017
Version 3Show Document
  • View in full screen mode

Currently we don't have a dedicated SAP Hana connector, you will need to use a database connector to connect to Hana SAP database.

You will first need to download the jdbc driver and place the jar files under .../userlib/database folder, and restart the atom. Then configure the database connection as the following.

 

Driver Type: Custom

User: database user name

Password: password

Class Name: com.sap.db.jdbc.Driver

Connection URL: Refer to the JDBC vendor's documentation for the connection URL syntax.

      example: jdbc:sap://host:port/?instanceNumber=number&user=user&password=pwd

 

If you use custom policy files, you may also need to update the security policy by adding the below line to custom procrunner-HIGH and procworker-HIGH files.

permission java.security.SecurityPermission "permission name"; 

Restart the atom afterwards.

Please note that [permission java.security.AllPermission;] will grant all permissions and may not be ideal from security perspective. 

Attachments

    Outcomes