REDWOOD

Introduction

As a service administrator, you can use the Fusion Data Intelligence (FDI) Extract Service to retrieve data from Oracle Analytics Publisher reports and utilize it to create data augmentations for a variety of business use cases.

Currently, Analytics Publisher report connectors only support:

  • Analytics Publisher in Oracle Fusion Cloud Applications for data augmentation
  • Reports completed within the Analytics Publisher report execution timeout limit (typically 300 seconds)

In this article, we will discuss how to achieve this using Analytics Publisher reports.

Step 1: Create a sample Analytics Publisher report in the Oracle Fusion Cloud application with the following components:

  • Build a comma-separated values (CSV) report for the targeted tables.
Sample data model
Sample data model
Data model output
Data model output

 

Enable the report settings
Enable the report settings

Step 2: Enable the Analytics Publisher reports on the Enable Features page.

Enable the Oracle BI Publisher feature
Enable the Oracle BI Publisher feature

Step 3: Create a new connection for Analytics Publisher and provide the necessary details like host, password, list of reports path, and its parameters.

Step 4: Ensure you enter multiple reports in comma-separated format.

Step 5: Use the option RunAsynchronously if the report isn’t huge, othewise select runInChunkMode.

Note:

  • Report names are case-sensitive.
  • The order of the parameters is allowed to change.
  • You can pass the values as comma separated.
  • Make sure data pipelines are enabled before refreshing the metadata.
Create an Analytics Publisher connection
Create an Analytics Publisher connection

Note: You can get only the business-needed transaction records into the FDI packaged ADW, which helps to avoid loading all the transactional records into FDI and saves time during the data augmentation.

Step 6: Test the connection and refresh the metadata.

Test the connection
Test the connection

Step 7: Augment the data into the Autonomous DataWarehouse (ADW) database.

  • Select the source table for augmentation.
Data augmentation
Data augmentation
  • Select the required columns. In this use case, select all the columns.
Select the required columns
Select the required columns
  • Select the primary key and incremental key columns that help with incremental refreshing.
Select the primary and incremental keys
Select the primary and incremental keys
  • Save and run the data augmentation immediately.
Save and run the data augmentation
Save and run the data augmentation
  • Verify that the pipeline status displays as Activation Complete.
Verify the data augmentation pipeline status
Verify the data augmentation pipeline status
  • Verify the table in ADW and validate the data.
Verify the data in ADW
Verify the data in ADW

Call to Action

Implement the steps described in this article to use the FDI to extract the data from the Oracle Analytics Publisher and store it as packaged ADW. Oracle suggests performing the same steps to enable the feature on the production FDI instance.

See Manage Data connections for more details on FDI Connectors.

REDWOOD