(GLUE-1905) Query Extraction
This document describes the steps necessary to extract data from SAP BW query into a file system.
After the extraction, there are two types of files stored on the defined storage:
- .csv files containing the data from queries
- .json files describing the structure of data
You can extract data from a BW query by using the ABAP Based Extractor.
To perform this, proceed as follows:
- Go to Glue Extractor Workbench.
- Right-click on ABAP to Storage and select Create Extractor.
- Specify the following parameters:
- Extractor name - technical name of an extractor
- Description - description of an extractor
- Extractor type - this value is predefined, but you can change it using a simple drop-down menu. For a BW query extraction, select ABAP to Storage extractor type
- Source type - choose Query to extract data from a BW query
Target type - choose File stored in Binary storage
Only the Target Type "File stored in Binary storage" is supported by this extractor. It's not possible to create a Query extractor with a Glue table as a target.
- Then, fill in following entries:
- Binary Storage - binary storage ID. You may use F4 help.
- Delimiter type - delimiter used to separate data in .csv file. You may use F4 help.
- Container name - name of an existing or non-existing container in the file system for the selected storage, which serves as a target for the extracted data.
- Source Query - name of the BW query, from which data is transferred. You may use F4 help.
- Class Name - this value is predefined with the class name /DVD/GL_EXT_ABAP_CL_QUERY.
- Run with user - user under which the extraction is executed. If the value is not specified, the current user will be used.
- Save and activate it. In the case you activate an unsaved extractor, it is saved automatically before activation.
The next step is to (GLUE-1905) Generate and Execute Variants for Query Extraction.