To create SAP Table to Storage extractor
- Go to Extractor Workbench.
- Right-click on SAP Table to Storage, select Create Extractor.
- Specify the following parameters:
- Extractor name – technical name of the extractor.
- Description – description of the extractor.
- Extractor type – this value is predefined, for this type of extractor select the SAP Table to Storage extractor.
- Source table – source SAP (DDIC) table or a view from which data is transferred.
- Target table – name of the created target (Glue) table. For information on how to create a Glue table, see (Glue-2002) Create a Glue Table.
- Specify a Package.
- Define a Delta Type to specify which data should be extracted and ensure data synchronization
Following types are supported:
- FULL – Standard full load. Data is transferred and appended to the target table.
- VALUE – Value based delta load. Only entries with new distinct values are transferred during the next execution of the extractor.
- DATE – Date based delta load. In the first run, all the data with a date older than the current date is transferred. In the following extractor runs, only data with a date newer than the latest date and older than current date is transferred.
- TMSTMP – Timestamp based delta. In the first run, all data is transferred. In the following extractor runs, only data with a timestamp greater than the latest timestamp from the previous run is transferred.
- TRIGGER – Trigger based delta.
See the the chapter Delta mechanisms for more information.
- Fieldname Mapping is automatically generated.
Field mapping of the extractor is used to map fields of a source table to the fields of a target table.
When a target and source tables contain fields with the same names, they are linked automatically. If these field names are not the same, you must fill them manually. Please note, that all key fields of the source table must be included. - You may change the transfer rule or edit the routine. For more information, see (Glue-2002) Transfer Rules.
You may select fields, which are used for filtering (selection) of data by the Variant definition. More information can be found in the part Variant Selection.
Note Please note: Maximum number of selected fields is 100.
- Before you use an extractor, save it and activate it. In the case you activate an unsaved extractor, it will be saved automatically before activation.
- The next step is to create a (Glue-2002) Variant.