Overview to Loading Datasets Incrementally

You can keep your workbooks up-to-date by implementing incremental dataset loads.

Reloading data incrementally refreshes data and can minimize processing time.

Where Do I Configure Incremental Loading?

In Oracle Analytics you configure incremental loading for datasets using the Cache Reload Type in the data access options.
Description of set-incremental-load-1.png follows
Description of the illustration set-incremental-load-1.png

What Incremental Load Types Are Supported?

In Oracle Analytics you can:
  • Load new records and updates to existing records, known as upsert, using the Load New and Updated Data option.
  • Load new records only, known as insert, using the Add New Data to Existing Data option.

If incremental loading isn't appropriate for you data, then you might choose to reload all data by selecting the Replace Existing Data option. For example, if a significant proportion of your data changes regularly, then a full load might be more efficient.

Database Types that Support Incremental Loading for Datasets

  • Oracle Database
  • Oracle AI Database
  • Oracle Applications
  • Oracle Autonomous AI Lakehouse (ALK)
  • Oracle Autonomous AI Transaction Processing (ATP)
  • Oracle Talent Management Cloud/Oracle Talent Acquisition Cloud (Taleo)
  • DB2
  • Informix
  • MySQL
  • SQL Server
  • Sybase ASE and Sybase IQ

Working With Data in Different Time Zones

If there's a time difference between the timestamps in your data and the default Oracle Analytics timezone , you can specify an offset that takes into account the time difference so that your data loads correctly. See Configure a Dataset to Load Incrementally.