(Glue-2111) SAP table data replication

Owned by SNP
Last updated: Nov 23, 2021 by Marian Vidra
1 min read

The most common scenario is the extraction of data from the SAP systems on the table level. The tables can be extracted from any SAP system that runs on Netweaver 7.01 and higher.

The data can be extracted from the SAP tables with specific selections and transformations based on the customer's needs.

Desired data can be moved to various targets which can be RDBMS storage (Oracle, MSSQL, etc.), file system (HDFS, Azure Blob, Azure Data Lake Storage, AWS S3, etc.), Hadoop (Hive, Impala), or cloud solution (AWS Redshift, Azure Databricks, Google BigQuery). For more information see Storage Management documentation.

In this section:

The following section provides you with a step-by-step procedure on how to configure the extraction of the SAP table to the desired storage.

  1. (Glue-2111) Create a Glue Table
  2. Create (Glue-2111) SAP Table Fetcher 
  3. Create (Glue-2111) Glue Table Consumer with previously created Glue table
  4. Create (Glue-2111) Extraction Process with previously created SAP Table Fetcher and Glue Table Consumer
  5. Execute extraction