Create a Connection to Oracle Essbase Data on a Private Network

You can create a connection to Oracle Essbase data on a private network and use the connection to access data.

You secure a connection to Oracle Essbase data held on a private network by using Data Gateway (for datasets or data models). Your Administrator installs Data Gateway in your private network. Data Gateway then redirects queries to the Essbase host.

1. On the Home page, click Create, and then click Connection.
2. Click Oracle Essbase.
3. Enter the connection details.
4. For DSN (data source name), enter the URL for your data source.

   These are the connectivity options to access Oracle Essbase on your private network:

   Note: When you specify the URL for your data source, <hostname>:<port> specify the hostname and port of the host accessible on the public internet that forwards traffic to your Remote Data Connector host.

   • The basic URL syntax:

     http(s)://<hostname>:<port>/essbase/capi/<private essbase host address>/<Oracle Essbase Agent port on the
           specified host>

     For example,

     https://myproxyhost.example.com:1234/essbase/capi/mylocalhost/1423

   • When Oracle Essbase is running on a secure port:

     http(s)://<hostname>:<port>/essbase/capi/<private essbase host address>/<Oracle Essbase Agent Secure port on the specified host>/secure

   • When Oracle Essbase is running on a secure port, with a self-signed certificate:

     http(s)://<hostname>:<port>/essbase/capi/<private essbase host address>/<Oracle Essbase Agent Secure port on the specified host>/secure/selfsigned 

5. Under Authentication, specify how you'd like to authenticate the connection:
   • Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
   • Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
   • (Displayed if Oracle Analytics supports impersonation for this database type) Use the active user’s credentials - Oracle Analytics doesn't prompt users to sign in to access the data. The same credentials they used to sign in to Oracle Analytics are also used to access this data source.
6. If you're connecting to an on-premises database, click Use Remote Data Connectivity.
   Check with your administrator that you can access the on-premises database.
7. Save the details.
   You can now create datasets from the connection.