(Glue-2411) SAP Table Data Replication

Owned by SNP
Last updated: Dec 16, 2024 by Marian Vidra
3 min read

The most common scenario is data extraction 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.), or cloud solution (AWS Redshift, Azure Databricks, Azure Synapse, Snowflake, Google BigQuery or Cloudera). 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:

Create SNP Glue Table

  1. Go to transaction /DVD/GL80, right-click on the desired package, and press Create Glue Table.

  2. Fill in the Table name and confirm.

  3. In the attributes tab fill in Storage ID. You can use F4 help to get available storages.

  4. Click on the fields tab and click Import fields in the toolbar.

  5. Select From table and fill in your source table.

  6. Click Activate in the toolbar at the top of the screen.

  7. The table is now active and created on target storage.

Create SAP Table Fetcher

  1. Go to transaction /DVD/GL80, right-click on the desired package, and press Create Extractor 2.0 Object.

  2. Fill in the Object name. Select Fetcher in the Component type list box and SAP Table Fetcher in the Component Implementation list box.

  3. In the Fetcher screen fill in the SAP Table name and press Enter.

  4. If the SAP Table is correct, the filter selection should be updated. In filter selection, you can check a selection checkbox that will allow you to perform filters on checked fields later.

  5. Click Activate in the toolbar at the top of the screen.

Create Glue Table Consumer

  1. Go to transaction /DVD/GL80, right-click on the desired package, and press Create Extractor 2.0 Object.

  2. Fill in the Object name. Select Consumer in the Component type list box and GLUE Table Consumer in the Component implementation list box.

  3. In the Consumer screen, fill in the Glue table with your Glue table name.

  4. Click Activate in the toolbar at the top of the screen.

Create Extraction Process

  1. Go to transaction /DVD/GL80, right-click on the desired package, and press Create Extractor 2.0 Object.

  2. Fill in the Object name. Select Extraction Process in the Component type list box and Extraction Process in the Component implementation list box.

     

  3. In Parameters fill in Fetcher and Consumer names and press Enter.

  4. Click Suggest transformation mapping in the Transformation section.

     

  5. Click Activate in the toolbar at the top of the screen.

Execution of Extraction

  1. Open Extraction Process in transaction /DVD/GL80.

  2. Click Execute in the toolbar at the top of the screen.

  3. Click Execute again in the toolbar at the top of the screen.

  4. Choose either Dialog execution or Background execution.