(Glue-2102) SAP table to Storage

Owned by SNP
Last updated: Feb 19, 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 the Storage Management documentation.

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

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