(Glue-2408) SAP Table Data Replication

Owned by SNP
Aug 20, 2024
3 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.), 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 desired package and hit Create Glue Table.

  2. Fill in Table name and confirm.

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

  4. Click on fields tab an click button Import fields in toolbar.

  5. Select From table from the options and fill in your source table.

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

  7. Table is now active and created on target storage.

Create SAP Table Fetcher

  1. Go to transaction /dvd/gl80 right click on desired package and hit Create Extractor 2.0 Object.

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

  3. In Fetcher screen fill in SAP Table name and hit enter.

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

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

Create Glue Table Consumer

  1. Go to transaction /dvd/gl80 right click on desired package and hit Create Extractor 2.0 Object.

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

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

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

Create Extraction Process

  1. Go to transaction /dvd/gl80 right click on desired package and hit Create Extractor 2.0 Object.

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

     

  3. In Parameters fill in Fetcher and Consumer names and hit enter.

  4. Click Suggest transformation mapping in 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.