Denodo adding SAP HANA fail over server as JDBC data sources

Fill the form with the following parameters:
● Database adapter: Generic
● Driver class: com.sap.db.jdbc.Driver.
● Database URI: use a connection string in the form of:

jdbc:sap://<server>:<port>[/?<option1>[&<option2>]…]

For example: jdbc:sap://host:30015/?autocommit=false. The port should follow the syntaz 3<instance number>15. For example: 30015, if the instance is 00.

You can specify one or more failover servers by adding additional hosts, as in the following example:

jdbc:sap://host:30015,host1:30015,host2:30015/?autocommit=false

Leave a Reply

Your email address will not be published. Required fields are marked *