SAP - ABAP
Introduction to ABAP: Datatypes, Operators & Editor - Tutorial
ABAP stands for - Advanced Business Application Programming.It is a programming language for...
Before we learn SAP BODS overview, let's understand
ETL stands for Extract-Transform-Load, and it is a process of how data is loaded from the target system to the data warehouse. Data is extracted from a database and transformed to match according to the data warehouse schema. After that, it is loaded back to the data warehouse database in the form of dimension and fact tables.
SAP BODS is an ETL tool for extracting data from disparate systems, transform data into meaningful information, and load data in a data warehouse. It is designed to deliver enterprise-class solutions for data integration, data quality, data processing and data profiling. The full form of SAP BODS is Business Objects Data Services.
In this beginner's SAP BODS tutorial, you will learn,
Here, are famous landmarks in the history of SAP BODS:
Here, are some basic components of SAP BODS architecture:
A repository is a set of a table which holds user-created and predefined system object, source, target metadata, and transformation rules. It allows you to set up repositories on an open client/server platform. This helps you for sharing metadata with other enterprise tools. Each local repository is connected with one or more job server which runs the job you have created.
SAP BOD Data Services Management Console is the web-based application with the following features.
The Job Server component helps you to starts the data movement engine. It allows you to integrate data from multiple sources. It helps you to perform complex data transformations and manages transactions and extractions from ERP systems and other sources.
The Data integration Job server tool allows you to move in data in either batch or real-time mode. It delivers high data throughput and scalability. Moreover, while designing a job, you can also run it from the Designer which tells the Job Server to run the job. The Job Server also allows you to get the job from its associated BODS SAP repository.
The Data services Designer tool offers an easy-to-use graphical user interface that helps you define transformations, data mappings, and control logic.
This component helps you to build applications containing data and workflows. This component also allows you to manage metadata stored in a repository.
After SAP BusinessObjects Data Services job are executed, the Job Server starts the engine to perform data extraction, transformation, and movement. The engine uses parallel processing and in-memory data transformation to offer high data connectivity, quality, and scalability.
Access server offers real time request-reply message that collects message request routes them to a real-time service and delivers a message reply in a specific duration. The Acess Server queries message and sends them to the next available real-time service across numerous computing resources.
The next component is the Address Server. It offers address validation and corrections. The Address Server must be started before processing data flows which contain the Global address Cleanse or Global Suggestion list transform with the EMEA engine enabled.
A Datastore offers a connection to a data source like a database. It is a linking interface between the actual backend database and Data services. Data store also allows data services to import the description of the data source such as metadata.
CMC is a web-based administration tool for BOD. It is a helpful tool to perform some essential functions like repository registration, user management, etc.
Data Integrator web administrator is also known as DI web admin. It helps you to maintain repositories in Data services. This SAP BOD services included in DI web admin are Meta Repository, Central Repository, job services, and web services.
Here are a few pros of BODS in SAP
Here, are few draws backs of using SAP BODS.
ABAP stands for - Advanced Business Application Programming.It is a programming language for...
Purchase orders are used for a number of processes in procurement. They can be used for internal...
There are two types of goods movement against production order which impacts the inventory of the...
What is SAP Business Suite? Business Suite in SAP is collection of fully integrated applications such...
Training Summary SAP Human Capital Management (HCM) is also called SAP-HR. SAP HCM consists of...
Inspection against Production GR- this inspection will be based on production confirmation against a...