Click the the main window “Extract SAP DataSources and Extractors” on [Settings]. The window Xtract IS DeltaQPrefernces open. The window consists of four main sections and buttons.
String Conversion #
Automatic String Conversion
All strings are converted into VarChar strings if the source system is non-Unicode, and all strings are converted into NVarChar if the source system is Unicode.
Convert Strings to VarChar
All strings are converted to VarChar regardless if the source system is Unicode or not.
Convert Strings to NVarChar
All strings are converted to NVarChar regardless if the source system is Unicode or not.
Transfer Mode #
The raw data packages can be send by SAP by a tRFC call or a Data-IDoc. Normally the tRFC is optimal for the default setting. If it is necessary, e.g. to examine the raw data packages for debugging reasons, you can change the transfer mode to IDoc. Then you can examine the data packages in the transaction WE02 (IDoc-Monitoring).
Hierarchy Settings #
Language
Defines the Language, if a Hierarchy is extracted.
Hierarchy Name
Defines the Hierarchy Name.
Hierarchy Class
Defines the Hierarchy Class.
Hierarchy Version
Defines the Hierarchy Version.
Misc. #
Update Mode Variable
Defines a variable for the update mode.
Set the value of the Update Mode to V - SSIS Variable and define the SSIS Variable for the Update Mode. The SSIS Variable can process the following values: F, C, D, S, I and R, as it is listed in the values of the Update Mode.
Request ID
This field is optional.
If a value (e.g. XtractDatasource) is set, it will be used as suffix in the SAP job name (e.g. BIXtractDatasource), otherwise a combination of process ID and timestamp will be used (e.g. REQU_pppppppp_yyyyMMddHHmmss), with process ID being the ID of the Windows process, the XtractDeltaQServerPool.exe is running under.
Automatic Synchronisation
Depending on the system landscape it could happen that developments only be performed in a test system. If SSIS packages should be used later in the production environment, the data source has to be enabled there. To avoid manual changes in the transactional system you can activate this option. In this case the activation will be automatically done and the timestamp of the data source will be changed that it will be consistent to the SAP system setting.
If the DataSource was modified in the SAP system, e.g. a field’s name, data type or length was changed or a field was excluded from data transfer, you will still have to manually activate the DataSource in the DeltaQ component, even if Automatic Synchronisation is switched on. Otherwise data load will fail. This behaviour is by SAP design and is described in SAP help.
Add Serialization Info to Output
Adds the two columns DataPackageID and RowCounter to the output. In this Case the following 3 columns will be available in the output: RequestID, DataPackageID and RowCounter, which are a composite key of the records delivered by SAP.
Newer data has a higher PackageID. In the same package newer data has a higher RowCounter.
Automatic Data Type conversion
SAP data types (like Date) will be converted to an appropriate SQL data type.
Value for invalid date [YYYYMMDD]
In case of no convertable date values you have to enter a default date value into the textbox. Every invalid value will be converted into this value. SAP date ‘00000000’ will be converted to NULL, irrespective of the entered date.
Replace date 00000000 with [YYYYMMDD]
SAP date ‘00000000’ will be converted to NULL or the entered date [YYYYMMDD].
Replace invalid date with[YYYYMMDD]
In case of no convertable date values you have to enter a default date value into the textbox. Every invalid value will be converted into this value.
Request Maintenance #
[Request Maintenance] shows the content of SAP table ROOSPRMSC. Allows the deletion of Init Requests (Requests in RSA7). In general, only one entry which corresponds to one Init Request should be visible here. Only if you’ve executed Init Requests with non-overlapping selection criteria, can you have more than one entry in this view.
Generate Documentation #
[Generate Documentation] generates an excel documentation about the datasource and its fields.