July 14, 2023
o9 — SAP Integration
o9's integration platform is a flexible and fully featured solution that can connect to a wide variety of data sources, including ERP systems, cloud data stores, and streaming data. The platform supports both batch ingestion for large master datasets as well as real time integration via APIs for transactional data.
In this video, we will discuss a typical o9 integration process, setting up a data load from SAP. The four basic steps involved are:u003cbru003e1. Setting up the connection: This involves configuring the o9 adapter to connect to SAP and specifying the target tables and frequency for data extraction.u003cbru003e2. Data mapping: This involves defining the mappings between the SAP data and the o9 data model.u003cbru003e3. Ingestion logic: This involves specifying the logic for how the data will be ingested into o9, including any transformations or filtering that needs to be applied.u003cbru003e4. Oversight and monitoring: This involves setting up alerts and metrics to track the performance of the integration process.
We will also discuss how o9's data staging area and transformation logic bring all of these types of data together in o9's in memory graph cube EKG.
