Automate Reload Data in OAC DV Data Sets

Siva Pratap Nellipudi-Oracle · Nov 18, 2020 1:11PM

Description

Currently, for the Data Sets based on an Oracle Database and set up in "Automatic Caching" mode for a refresh, there is no way to automate the "Reload Data" process whenever the Data is refreshed in the backend. This is very important as the data in the Database tables could be refreshed through ETLs or other processes and there is no way for the Data Sets to refresh automatically based on this. So it would be great to have some functionality built around this. I could think of a couple of options.

1. Provide a way to schedule the "Reload Data" at the Data Set level in the UI

2. Provide a way to trigger the "Reload Data" at the Data Set level from the ETL process completion.

Use Case and Business Need

The business would always like to view the latest data in their visualizations built on top of Database tables and set to "Auto Caching". Unless someone (Possibly BIAdministartor or a user with Full access to the Data Set) manually clicks the "Reload Data", users would always be seeing stale data in their reports, despite the data has been refreshed in the back end tables. Using "Live Data" is not an option, if the tables are holding several millions of rows due to row limits.

More details

Currently, the only option to "Reload Data" in data sets is to manually click the button available at the front end. This is inefficient at best.

Original Idea Number: 733ed61b05

Gabby Rubin-Oracle · Nov 18, 2020 11:34PM

The ability to schedule the refresh of datasets is planned for early 2021.

Siva Pratap Nellipudi-Oracle · Nov 19, 2020 1:28PM

Thanks, Gabby. Would there be an ability to trigger the "Reload Data" from an ETL tool like ODI or OCI Data Integration?

vkm · Mar 8, 2021 6:00PM

We need this feature ASAP too

vkm · Mar 8, 2021 6:01PM