Capturing Data Through SAP Data Extraction

The process of SAP data extraction captures and formats data through an exact structure. This data, in turn, can be transferred to the SAP BW (Business Warehouse). SAP Extractor is a program in SAP ERP that can either be taken from a homogeneous Data Source or customized as per needs. Both the methods describe a delta load process of full load with the SAP BW remotely accessing ingtransfer aspects through SAP data extraction.


The SAP data extraction process with the SAP Extractor starts with help from multiple application-specific extractors which are hard-coded for the Data Source to be delivered along with the BI Content for the SAP Business Warehouse. The Extractor is designed to exactly match the architecture of the Data Source.

Further, several generic extractors can be used for SAP data extraction from source systems and transferring to the SAP BW. The full process is automated and the SAP Extractor knows which data has to be extracted and from which tables the data has to be read. This is post-identification of the Data Source by the generic extractor. 

There are three types of SAP data extraction that are executed by the SAP Extractor.

·        Content Extraction: It is used to extract BW content, FI, HR, CO, SAP CRM, and LO cockpit.

·        Customer-Generated Extraction: Here, SAP BW Extractor is used for LIS, FI-SL, and CO-PA.

·        Generic Extraction: This is based on DB View, Infoset, and Function Modules.

From these three, the SAP data extraction activity that is in tune with the specific needs of an organization has to be selected. Originally, the SAP Extractor tool was developed to be provided for the applications of the SAP Business Warehouse.   


Comments

Post a Comment

Popular posts from this blog

Everything you need to know about Extract, Transform and Load (ETL) tools

Image
As a central repository that holds all the bid data from various different sources, a data lake is the vast, richest pool of raw data, the purpose of which is undefined. Data from this lake is then put to use for analytics and machine learning by organizations. A data lake is used for storing both relational and non-relational data from devices, apps, and users. Different types of analytics, such as machine learning, big data analytics, textual search, SQL queries, and real-time analytics can be derived from a data lake. It has both curated and non-curated data. An SAP data lake is easy to set up and can ingest data from on-premise or from a cloud warehouse. According to a survey, 90% of businesses believe that big data initiatives help them determine future success. A data lake allows data engineers, data scientists, and business analysts to access information using the tools and applications of their choice. There’s a lot of value in a data lake for businesses, the ability to harnes...
Read more

Migrating Oracle Database to Amazon Simple Storage Service (S3)

Image
Amazon Simple Storage Service (S3) is a cloud-based service that is cost-effective and provides unlimited storage capabilities. For Oracle databases, the most common source for data lakes in the Amazon Relational Database Service (RDS). To migrate the database from Oracle to S3 , there should be an AWS account. Further, also required is an Amazon RDS for the Oracle database and an S3 bucket l ocated in the same region where the AWS DMS (Database Migration Service) replication instance is created for migration.  Databases can be migrated from Oracle to S3in any one of two ways. The first is by importing data, Oracle Data Pump, and Database Link where the Data Pump and the Oracle DBMS_FILE_TRANSFER package are used to link to a source Oracle instance. This can be initiated either through an Amazon EC2 instance or an Amazon RDS for the Oracle database instance. After the Oracle data is exported to a dump file with the DBMS_DATAPUMP package, the file thus created is copied to the Ama...
Read more

The Unique Architecture of the SAP HANA Data Lake

Image
In April 2020, SAP launched the HANA Data Lake that added more power to the existing cloud-based business ecosystem. Users benefitted from a cost-effective storage system from the package that consisted of a native storage extension and a relational SAP data lake. From the start, this data lake was considered to be as feature-rich as the existing players like Microsoft Azure and Amazon S3.  What makes SAP data lake stand out among its competitors is its unique architecture. Organizations have the option of storing data that is frequently used and regularly accessed in one layer while moving other not-so-critical data in low-cost storage layers of SAP HANA. Visualize the SAP data lake as a pyramid that has three layers. The top of the pyramid houses the most important data of an organization that is used in the regular course of business. Hence the cost of storing this data is the highest as it is frequently accessed for analytics or reporting. In the second layer of the ...
Read more