What happens during Hyperion EPM configuration when you mention the relational schema details

In this blog, I would be focusing on the technical aspects of what happens when we mention the relational schema details during the Hyperion EPM configuration. In addition, I would show a small sample code that will show how EPM internally connects to a database schema using a user name and password.

Now the below couple of snapshots show the EPM configuration utility asking for database schema details for first time configuration of the Hyperion Shared services. 

 

The important points to observe in the above snapshot is as follows: -

• Database Type: Oracle Driver(Thin)
• Server Name: Server where the database is installed.
• Port number: By default, Oracle listens at port 1521 but this can be changed at configuration time of Oracle DB.
• Service Name or SID: XE
• User name: hyp_hss
• Password: Password for the hyp_hss user.

The Oracle Thin driver is coded purely in Java and is platform independent. More details on the driver is present at this link. (https://docs.oracle.com/cd/B19306_01/java.102/b14355/jdbcthin.htm#CACGGDCE)

Service name is how Oracle is named on a particular machine. Since I am using the default install, the name is XE.

Now, let us dive into the technical aspects.

Oracle Driver(Thin) resolves to jdbc:oracle:thin:

The remaining parameters are used to in combination to establish a database connection.

The URL that is used for connection is something of this sort: -

<Driver Name>@<SERVER NAME>:<PORT NUMBER>/<SERVICE NAME or SID>

In our case this would be something like: -

Jdbc:oracle:thin:@WIN-B6B8874FFE3:1521/XE

The user name and password may be passed either separately or together since the getConnection() method is overloaded. 

Now, a sample snapshot of me establishing connection to a database using the thin driver is as shown below. 

If you are using Microsoft SQL Server, the connection URL would be more or less same since platform independence…

Below shows a sample URL for Microsoft SQL server.

jdbc:sqlserver://<Server Name>:<Port Number>;databasename=<SID/Service Name>