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.
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.
- (Glue-2011) Create a Glue Table
- Create (Glue-2011) SAP Table Fetcher
- Create (Glue-2011) Glue Table Consumer with previously created Glue table
- Create (Glue-2011) Extraction Process with previously created SAP Table Fetcher and Glue Table Consumer
- Execute extraction