(GLUE-1808) Extractor Workbench

Owned by SNP
Jul 04, 2018

Transaction:

/DVD/GLWB

Glue Extractor Workbench is used for data transfer. Extraction creates a copy of a source on a target location.
There are plenty of options on how to extract. For each extraction process a source and a target must be clearly defined.

In this section


Metaobject

Glue extractor

Each extractor is composed of a source and target definition. Extractors can have various settings as there are different variants of data selection from source systems, delta mechanisms, transfer rules, etc.

Tutorials

(GLUE-1808) Create Extractor

(GLUE-1808) Create Variant

Operations for extractors and variants

(GLUE-1808) Manage extractor

Execute data extraction

Requirements

(GLUE-1808) Data Dictionary



Sources:

  • Primary database table
  • External table on a storage (defined by a Glue table in Glue DDIC)
  • BW InfoProviders
  • ABAP code implementing our interface
  • Local file (stored on the user's computer)
  • Remote file (stored on a machine where SAP Application Server is running)

Targets:

  • Primary database table
  • An external table in a storage
  • External place in a storage (path for a file)


Between SAP and Hadoop systems. The data movement process is based on extractors which work similar to DTP. The extractors provide various types of data movement:

  • ABAP to Storage 
  • CSV File to Storage 
  • Local File to HDFS – loads unstructured data from the local station to Hadoop
  • Storage to SAP table – loads an external table to SAP (DDIC) table
  • InfoCube to Storage
  • Remote File to HDFS – loads unstructured data from the remote station to Hadoop
  • SAP table to Storage – loads SAP (DDIC) table to an external table