1. Using Oracle Essbase
  2. Work with Connections and Datasources
  3. Create an Application-Level Connection and Datasource

Create an Application-Level Connection and Datasource

When Essbase operations for a single application require access to to source data external to the cube, you can implement saved connections and Datasources for that application.

Before you can create connections to external source data from Essbase, you must get the connection details such as host names, user names, passwords, and any other service credentials from your system administrator.

  1. Log in to the Essbase web interface as an application manager, or as a power user with application management permission to the specified application.

  2. On the Applications page, click an application name. For example, click ASOSamp.


    Essbase web interface Applications page with a tile for application ASOSamp

  3. Click Sources, and then click Create Connection.

  4. Select the type of source you need to connect to. Sources and versions included with Essbase are listed in the Database section of the certification matrix (see the Platform SQL table). If you want to use your own preferred JDBC driver that you will upload, refer for details to Create Connections and Datasources for Generic JDBC Drivers.


    Create Connection button with connection choices: Oracle Database, Essbase, File, Spark, DB2, SQL Server, MySQL, and JDBC

  5. Complete the connection details and save the connection. The input details vary depending on the source type.

  6. To create one or more Datasources that use the connection, click Datasources, and then click Create Datasource.


    Datasources tab in the Essbase web interface, with Create Datasource button.

    The information you provide in steps above will vary depending on the type of source you are using. For some source-specific workflows, refer to the following topics:

  1. Log in to the Essbase web interface as an application manager, or as a power user with application management permission to the specified application.

  2. On the Applications page, click the Actions menu to the right of the application name, and click Inspect.

  3. Click the Sources tab.


    Sources tab in the application inspector for application named Sample. The Connections area is showing, with two connections already created: one named OracleDB and one named Essbase2.

  4. Click Create Connection and select the source you need to connect to. Supported sources and versions included with Essbase are listed in the Database section of the certification matrix (see the Platform SQL table). If you want to use your own preferred JDBC driver that you will upload, refer for details to Create Connections and Datasources for Generic JDBC Drivers.

  5. Complete the connection details and save the connection. Similarly, create one or more Datasources that use the connection. The input details vary depending on the source type.