How to Modify the JDBC Connection URL Format in Helical Insight?

Database Support
, , , ,
#1

Hello Team,

How can we modify the JDBC connection URL format for a database in Helical Insight to match the required connection format, such as changing the URL structure or switching between different connection formats?

Thank You,
Snow.

#2

Hello Snow,

To modify the JDBC connection URL format in Helical Insight, follow the steps below:

  1. Open the databaseDriver.properties file from the following location:

".../hi/hi-repository/System/Admin"

  1. Locate the respective database driver configuration. You will find the JDBC URL definitions for the database, including the default and service-specific connection formats.

  2. Modify the JDBC URL configuration according to your database connection requirements.

For example, for Oracle, you can modify the following configuration for accepting connection reqeuest as / instead of :

Existing configuration:

#Oracle 

oracle.jdbc.OracleDriver=jdbc:oracle:thin:@{{hostName}}:{{port}}:{{database}},1521 

type.service.oracle.jdbc.OracleDriver=jdbc:oracle:thin:@{{hostName}}:{{port}}/{{database}},1521 

Modified configuration: 

#Oracle 

oracle.jdbc.OracleDriver=jdbc:oracle:thin:@{{hostName}}:{{port}}/{{database}},1521 

type.service.oracle.jdbc.OracleDriver=jdbc:oracle:thin:@{{hostName}}:{{port}}:{{database}},1521
  1. Save the changes and perform a hard refresh of the Helical Insight application in your browser.

After completing these steps, the JDBC connection URL will be displayed in the modified format when configuring the respective database connection.

Note: Ensure that the modified JDBC URL follows the syntax supported by the respective database and JDBC driver. Restart the application if the changes are not reflected after a hard refresh. Try in private window

Thank You,
Helical Insight.