Design Business Processes with SAP Signavio Solutions

Standalone Connector for Consultants

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Explain the different options for loading data into the system

ETL Data Pipelines

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).

Use Data Models in SAP Signavio ETL

Save progress to your learning plan by logging in or creating an account