Extraction Settings

This page contains an overview of the extraction settings in the DeltaQ extraction type.
To open the extraction settings, click Extraction Settings in the main window of the extraction type.

The DeltaQ settings consist of the following tabs:

• Base

• Hierarchy

Base Settings

Transfer Mode

The raw data packages can be sent by SAP via tRFC call or Data-IDoc. tRFC is is the default setting.
Switch to IDoc to monitor the raw data packages in the transaction WE02 (IDoc-Monitoring) for debugging reasons.

Misc. Settings

Automatic Synchronization

Option to prevent manual changes in the transactional system when switching from test environment to production environment.
Example: To use DeltaQ extractions in the production environment, the data source has to be enabled in the production environment. If Automatic Synchronization is active, the activation is performed automatically and the timestamp of the data source is changed to be consistent with the settings of the SAP system.

Add Serialization Info to Output

Adds the columns DataPackageID and RowCounter to the output.
Example: the following columns that are a composite key of the SAP records are included in the output:

• RequestID
• DataPackageID
• RowCounter

Accept Gaps in DataPackage ID

At the end of each extraction the DeltaQ component performs a consistency check. The extraction is considered consistent if all data packages arrive correctly. Example: When using a filter function in the user exit of an OLTP source, certain data packages are not sent. In this case the filter function is an inconsistency. If Accept Gaps in DataPackage ID is active, gaps in the package numbering are not considered inconsistencies. Only use this option when a filter function exists in the user exit.

Timeout (sec)

Enter a time period (in seconds). The timeout applies when an extraction finishes on the SAP side, but not all tRFC calls have been received.

Hierarchy Settings

The following settings only apply to Hierarchy extractions.

Extraction

Language

Enter the language of the Hierarchy, e.g., ‘E’ or ‘D’.

Hierarchy Name

Enter the name of the Hierarchy.

Hierarchy Class

Enter the class of the Hierarchy.

Representation

• ParentChild: The Hierarchy is represented in the SAP parent-child format, see Output Formats: ParentChild. Example:
  
• Natural: The SAP parent-child Hierarchy is transformed into a regular hierarchy, see Output Formats: Natural. Example:
  
• ParentChildWithNodeNames: The Hierarchy is represented in a reduced SAP parent-child format that only includes single nodes and their parent, see Output Formats: ParentChildWithNodeNames. Example:
  

Natural Representation

Level Count

Defines the maximum number of levels. The following example shows a Hierarchy with four levels.

Fill empty levels

Copies the bottom element of the Hierarchy until the last level. The following example depicts the previously shown Hierarchy with the activated Repeat Leaves option.

Description texts for levels

Sets the output field LevelTextN for each field LevelN containing the text based on the system language settings.

Leaves only

Returns only the leaves as data records.

Maintenance

Click [Maintenance] to open a list of Init requests of the DataSource (SAP transaction RSA7).

Select an Init request and click [ ] to delete it. This is necessary when re-initializing a delta process.