(Glue-2208) SAP table data replication

Owned by SNP
Last updated: Aug 22, 2022 by Marian Vidra

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 (Glue-2208) Storage Managementdocumentation.

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. Create SNP Glue™ Table
  2. Create SAP Table Fetcher 
  3. Create SNP Glue™ Table Consumer with previously created SNP Glue™ table
  4. Create Extraction Process with previously created SAP Table Fetcher and SNP Glue™ Table Consumer
  5. Extraction Process