Creating Data Source Connections to Oracle Analytics Cloud - Essbase

After you install Oracle Smart View for Office, you can create connections to Oracle Analytics Cloud - Essbase.

Connections require information about the server and port. Your cloud service administrator should provide you with the information you need to create the connection. Use the quick connection method to create a private connection to the cloud service.

To create a private connection using the quick connection method:

  1. In Excel, select the Smart View ribbon, and then click Panel.
  2. On the Smart View Panel, click the arrow next to of the Switch to button Image of the Switch to button., and then select Private Connections from the list.
  3. Still in the Smart View Panel, in the text box, enter the URL for the data source to which you want to connect.

    The URL syntax:

    https://server/essbase/smartview
  4. Click Go, Image of the Go button. or press Enter.
  5. On the login window, enter your login credentials, and then select a data source from the drop-down menu.
You can now begin working with data in Oracle Analytics Cloud - Essbase. See the functional areas listed in Smart View and Oracle Analytics Cloud - Essbase for more information.