CPI for Data Services

SAP Cloud Platform Integration for Data Services (CPI-DS) enables scheduled data movement between on-premises and cloud systems using extract, transform and load (ETL) processes. It supports batch integration scenarios where data is extracted from source systems, transformed to match the structure and rules of the target environment and then loaded into cloud-based SAP applications.

This integration component is often used with planning, analytics or supply chain solutions, such as SAP Integrated Business Planning (IBP), where accurate and timely data is critical. It includes built-in transformation functions that optimize datasets for use in cloud applications. 

Key capabilities include:

• Extracting data from on-premises SAP and non-SAP systems
• Loading batch data into supported SAP cloud applications on a schedule
• Reversing the flow to move data from cloud back to on-premises systems
• Transforming data for compatibility with cloud-based targets

Templates are available for common use cases, and workflows can be scheduled to run as part of broader workload automation strategies. This ensures that data pipelines align with system dependencies, business rules and performance requirements.

Benefits and use cases for CPI-DS

CPI-DS is designed for organizations that need governed, scheduled data movement rather than real-time APIs. 

Consistent hybrid data movement

CPI-DS enables secure, scheduled data movement between on-premises systems and cloud-based SAP applications (such as IBP, SuccessFactors and Analytics Cloud (SAC)). It is designed specifically for batch data loads across hybrid IT landscapes common in digital transformation projects.

No middleware or custom coding required

Unlike custom-built data jobs or legacy integration platforms, CPI-DS requires no scripting or middleware. This reduces development time and lowers maintenance overhead.

Purpose-built support for batch ETL scenarios

CPI-DS enables scheduled, high-volume data transfers, unlike SAP Integration Suite, which is designed for real-time or operational integration. This makes it ideal for use cases like daily master data synchronization and historical or batch data loads.

Rich data transformation capabilities

CPI-DS includes a browser-based data flow designer that allows users to build mappings, apply transformation logic and cleanse data. This makes it easy to standardize and prepare data for analytics or cloud applications.

Secure and scalable architecture

CPI-DS uses a Data Services Agent installed on-premises, ensuring secure communication between internal systems and the cloud runtime. This agent supports SSL encryption, proxy configurations and multi-tier environments.

Achieving unified control across SAP data and planning tools

RunMyJobs by Redwood acts as the orchestration layer that connects SAP’s most critical cloud data and planning tools — CPI-DS, Datasphere, IBP and SAC — into a unified, end-to-end automation fabric. It doesn’t replace the core functionality of these tools, but coordinates and governs how they operate together within complex business processes.

RunMyJobs delivers the following integration points:

• CPI – DS: Schedules and triggers ETL jobs using its SAP Data Services connector
• Datasphere: Monitors and orchestrates task chains and replication flows
• IBP: Schedules and manages workloads that automate supply chain forecasting simulations for better inventory management and restocking reporting
• SAC: Executes and tracks SAC Publishing Events (refreshes, report distribution) in complex, cross-system workflows

Centralized orchestration

RunMyJobs transforms these individual tools into a coordinated automation system. This is especially valuable for scenarios that span multiple data sources and execution layers, such as supply chain planning or quote-to-cash cycles.

RunMyJobs offers:

• Centralized visibility: It gives users a single pane of glass to view the status, history and dependencies of every job, regardless of whether it runs on S/4HANA, CPI-DS, IBP or a non-SAP system.
• End-to-end governance: It applies enterprise-grade features (SLA monitoring, audit trails and conditional logic) across the entire process chain, eliminating the need for manual workarounds and error resolution scripts.
• Unification: RunMyJobs provides purpose-built connectors for each SAP BTP component (CPI-DS, IBP, SAC, etc.) that unify disparate schedulers into a single, cohesive business workflow.

Automate and control data transformation

RunMyJobs enables SAP CPI-DS users to move, replicate and map SAP and non-SAP data from on-premises environments to the cloud as part of an automated data migration process. 

With the RunMyJobs connector, it’s easy to embed RunMyJobs capabilities while maintaining strict control and accuracy of data services.

More About the CPI for Data Services Connector>

How RunMyJobs enhances CPI-DS pipelines

While CPI-DS handles batch integration, RunMyJobs manages when, how and under what conditions those jobs run. It layers governance, scheduling logic and monitoring on top of CPI-DS processes so data pipelines execute reliably across hybrid landscapes.

• Process orchestration: RunMyJobs can import existing CPI-DS tasks as Job Definitions, execute them and monitor them using built-in Process Definitions like:
  • ImportTasks
  • RunTask
  • ShowTasks
• End-to-end job automation: These built-in connectors eliminate the need for custom scripts, enabling RunMyJobs to orchestrate CPI-DS tasks within broader, cross-application workflows, including data flows to/from SAP Datasphere, Integration Suite and SAC.
• Clean core support: Because RunMyJobs is agentless and uses standard APIs, it supports SAP’s clean core strategy, avoiding custom code in SAP Cloud ERP and other cloud systems.
• Data pipeline governance: RunMyJobs ensures secure, accurate and timely data movement, which is critical for downstream SAP AI models and analytics tools like SAC. This is especially relevant when CPI-DS is used as a staging or transformation layer in BTP-integrated environments.