(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:

1. Go to Glue Extractor Workbench.
2. Right-click on ABAP to Storage and select Create Extractor.
3. 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.

     

4. 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.
     
     
     
     
5. Save and activate it. In the case you activate an unsaved extractor, it is saved automatically before activation.

6. The next step is to (GLUE-1905) Generate and Execute Variants for Query Extraction.