We are struggling to find a solution for keeping track of data changes, for example, on customer order line columns such as quantity, date, and price.
Some solutions can read the Oracle archive log to identify changes and replicate deltas to Data Warehouse which would be very efficient. However, some of our data doesn't come directly from tables but involves IFS built-in APIs. Therefore, we may need to extract data from views instead of reading the logs of tables. This means that we must extract a full load of data from views and perform certain procedures to identify changes, but it isn’t effecient this way.