SAP Signavio ETL Data Pipelines
Process Intelligence ETL is the data ingestion component. It automates data extractions and transformations from external source systems and loads it directly to SAP Signavio Process Intelligence. All of this can be done in PI itself without the need to configure a staging environment and only on-premise systems require additional setup on the source system side.
SAP Signavio ETL uses standard connectors and provides an interface to extract, transform and load data directly to a process. All interaction stays within the system.
SAP Signavio ETL Components
The integrated ETL feature consists of three main components, which all together are used to setup Data Pipelines.
PI ETL consists of three components. Data sources establish a connection to the source system. In the event of an on-premise system, the On-premises Extractors is needed for this step. The extraction itself is then set up under Integrations where the specific tables and schedules for continuous loads can be defined.
These components are brought together in Data models. This step transforms your data into an event-log format. This is also when you connect your data to an investigation to start the process analysis.
To learn more about each step, click the tabs below.
In the animation below, click on each tab on the left-hand side to learn more about the 3 PI ETL components.
Process Intelligence: Data Manager
Use Data Models in SAP Signavio ETL
In a data model, you define how the ETL data pipeline extracts and transforms data, and where to load the data. It's basically the blueprint to identify and extract all required data based on the data model.
Let's have a look at how to create and use them:
- Create new Data Model
- New data models can be created by clicking on the button "New data model".
- Select Source System
- The data model needs to be connected to a data source to obtain the data.
- Select the Data Model Template
- Based on the data source, specific templates are provided. Select your desired one.
- Select Integration
- The integration defines the tables to be extracted. In this example, we create a new one.
- Select the configured data source
- The data model and integration requires the underlying data source which connects to the source system (in our case SAP).