This feature is available if you have created a new deployment of Essbase 21.7.0.0.1 or above from Oracle Cloud Marketplace with Autonomous Data Warehouse Serverless as the repository database (RCU). Only ONE Essbase instance link can be added per Autonomous Database.

The option is available during deployment. For more information, see Create Stack.

Alternatively, you can add the link by following the steps mentioned below.

About Data Studio

The Data Studio Tools allow you to load data from cloud and other diverse sources, analyzes it and gain insights from it. You can share the result of the analysis with other users. It is a one-stop application of your analytics tool from multiple data sources. This tool makes sure that there is seamless transition between different applications. The multiple ways of navigation do not impact the progress of your work.

The Data Studio comprises of the Data Load, the Data Analysis, the Data Insights, Catalog, Data Marketplace and the Data Share tool.

For more information, see The Data Studio Overview Page.

Run Registration Script

To link Essbase to Autonomous Database in case the option was not selected during deployment, you need to run the Essbase URL registration script.

1. Log in to the Essbase compute instance as user opc.
2. Switch to user oracle:

   su oracle

3. Navigate to /u01/vmtools/config/adb_url:

   cd /u01/vmtools/config/adb_url

4. Run configure-essbase-url.sh, using vault option, to register the current instance's URL on its repository database.

   Example:

   ./configure-essbase-url.sh --vault

5. The link to your Essbase instance should now appear in Data Studio suite of tools.
6. If needed, remove the URL link by running the script with drop option.

   Example:

   ./configure-essbase-url.sh --vault --drop