CDS Flow Settings
This page contains an overview and description of all available CDS Flow settings.
Open the CDSFlow Settings
To open the service settings of an existing CDSFlow service:
- Open the Services menu
- Select a service of type CDSFlow.
- Click [ Edit].
The settings of the CDSFlow service open.
CDS Flow
The CDS Flow tab contains settings related to the source CDS View in SAP.
CDS View
The CDS View section displays the name, description and delta support of the selected CDS View.
Select CDS View
Select a CDS View from the connected SAP system. The CDS Flow service type extracts data from the selected CDS View. For more information, see Look Up CDS Views.
Output Columns
The Output Columns section shows which CDS View columns are included in the output of the service. You can select either all or only individual columns. By default all columns are selected and included in the output. Deselect the columns you want to remove from the output.
Update Mode
The Update Mode section contains settings that define the load behavior of the service. The CDS Flow service type offers the following loading behaviors:
| Update Mode | Description |
|---|---|
| Full Load | Loads all data from the source CDS View. |
| Initial load | Initializes delta loading. |
| Delta load | Loads data that has been added or changed in the source CDS View since the last service run. |
For more information, see Initialize Delta Loads.
Subscription Name
The subscription name is used to track changes in the source CDS View and must be unique for each CDS View. The subscription name is required for delta loading and is only visible when the update mode Delta Load is selected.
Subscribe
Initializes delta loading for the selected CDS View. If the initialization is successful, a status message "Initialization successful" opens in the bottom right corner of the window. After subscribing, the service must run once to complete the initial full load of the CDS View.
Subscription ID
The subscription ID is generated by SAP when delta loading is initialized and is used to identify the subscription for the selected CDS View in SAP. The subscription ID is only visible when the update mode Delta Load is selected.
Unsubscribe
Deletes the subscription for the selected CDS View. If successful, a status message "Unsubscribed successfully" opens in the bottom right corner of the window and the subscription ID is removed from the Subscription ID field
Service Settings
The Service Settings tab contains settings specific to the service type.
Package Size
The extracted data is split into packages of the defined size. The default value is 50000 lines.
A package size between 20000 and 50000 is advisable for large amounts of data. 0 means no packaging. Not using packaging can lead to an RFC timeout for large data extractions.
Warning
RFC_ERROR_SYSTEM_FAILURE - No more storage space available for extending an internal table
To avoid a memory overflow on the SAP source system and to avoid huge overheads, choose a package size that suits your memory capacity.
Destination Settings
The Destination Settings tab contains settings specific to the destination assigned to the service.
The destination settings define how and where a service saves its output data. The settings vary depending on the destination.
- HTTP Destination Settings
- Microsoft Azure Storage Destination Settings
- Microsoft Fabric Mirroring Destination Settings
- Microsoft Fabric (OneLake) Destination Settings
- Microsoft Power BI Destination Settings