Why do I need an ODS?

Why you need an Operational Data Store (ODS).

We advice you to always use an ODS (Operational Data Store) between your source(s) data and your Data Warehouse.

Advantages of using an ODS

  • You can have a copy of your source(s) data without troubles for accessing your source(s) (Access to source data may cause delays in the use of the source application during data uploads).
  • You can centralize the historization of the data (SCD2) in the ODS and use really what you need in your Data warehouse (Sometimes historized data, sometimes only current data).
  • You can generate, deploy and load your DWH easily because all is stored in your ODS (mainly historized data).
Posted on:
January 12, 2023

Can’t find the right answer?

Go to our contact page and get in touch with us.
Our support team is ready to help you.

Start smart, with your data automation today.

Accelerate your applied intelligence workflow with comprehensive features that biGENIUS has to offer.