I want to add a direct connection to my Oracle Database but it is configured as a Service instead of with an SID.
Generic thin client drivers are designed to reconstruct your information into a URL connection string, this only works if a SID is present for the connection
What you need to do to make a successful connection directly to your Oracle Database is to utilize a Generic JDBC connection instead of the Oracle Thin client driver settings.
*Note: You will still need to place the thin client driver into your drivers directory for this to work properly then restart the iDashboards(Tomcat) service.
When configuring a Data Source select Generic JDBC. After the selection of the Generic JDBC connection configure the Database URL and the JDBC Driver Class information to utilize the below as an example.
Set the Data Source Name to a Name of your choosing to best reference this connection.
Set the Database Username.
Set the Database Password.
Reenter the Database Password.
Quote Characters set to " ".
Leave Quote Table and Column Names unchecked.
Database URL: jdbc:oracle:thin:<Username>/<UN Password>@<server name>:1521/<Service Name>
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
Leave Optional Driver Properties empty.
Leave Max connections set to 10.
Leave Schema Pattern empty.
Leave Table Name Pattern empty.
Leave Validation Query empty.
Check the Allow Custom Queries check box.
Your connection should be established.
- Private Cloud
- Enterprise Suite