Oracle Analytics and AI

Triggers in OAX_User Schema

Hi Team,

Is it advisable to create triggers on OAX_User schema. If yes, what privileges are required. We have granted Create any Trigger to OAX_User but still getting Insufficient privileges.

We are loading a table from external source to ADW and creating a trigger to load data into other table in same schema with some other conditions.

Thanks

Find more posts tagged with

Database

External Data Sources

FDI Back End

Fusion Data Intelligence

Fusion AI Data Platform

Accepted answers

All comments

Sumanth V -Oracle

@FDI_USER - Creating triggers in the OAX_USER schema within ADW of Fusion Data Intelligence (FDI) is discouraged due to:

Managed schema restrictions enforced by Oracle.
Potential conflicts with upgrade processes that may overwrite or break custom objects.

Recommended Approach

Create a custom schema within ADW where you have full control and necessary privileges.
Grant required access to OAX_USER from your custom schema, allowing data interaction while keeping the core managed schema untouched.

Oracle Documentation – Reset Password for Custom Schemas

PRATHEEK

Can anyone recommend the best approach to pull Power BI data into Fusion Data Intelligence (FDI)?

Currently, a customer has implemented Fusion ERP and is keen to start using FDI ERP Analytics. They have previously built several Power BI dashboards based on financial data.

Is it possible to build any supporting data warehouse tables using Autonomous Data Warehouse (ADW)?

Also, what is the benefit or purpose of connecting from existing Power BI datasets into FDI?

PRATHEEK

@Sumanth V -Oracle @John Hung-Oracle @FDI_USER @Benjamin Arnulf-Oracle @Darryn Hinett-Oracle

Can anyone recommend the best approach to pull Power BI data into Fusion Data Intelligence (FDI)?

Currently, a customer has implemented Oracle Cloud Fusion ERP and is keen to start using FDI ERP Analytics. They have previously built several Power BI dashboards based on financial data.

Is it possible to build any supporting data warehouse tables using Autonomous Data Warehouse (ADW)?

Ideally aiming for single data lake for Power BI & FDI-ERP Analytics.

Also, what is the benefit or purpose of connecting from existing Power BI datasets into FDI?

Syamantak Saha

In ETL Engineering, this is usually accomplished from Import/Export of flat files between heterogeneous environments as the risk of data loss is higher when compared to the probability in each environment.