A data-oriented integration approach is optimal when dealing with diverse data sources and complex data requirements. This includes scenarios where the data is both structured and unstructured, changes rapidly, and needs significant processing such as cleansing, correlation, and partial recalculation. The advantage of this approach is that it centralizes data handling and transformation logic, allowing for more efficient data processing and integration into a central store like SAP HANA Cloud.
Reference = SAP's guidelines on data integration recommend this approach when handling large and complex data sets that require intensive processing and are sourced from a variety of SAP and non-SAP systems. It is supported by SAP's data management and integration tools that are designed to handle such complexity and frequency of change.