SAP Business Objects Data Services (BODS)
The SAP Business Objects Data Services application can help by delivering a single enterprise-class solution for data integration, data quality, data profiling, and text analysis that allows you to integrate, transform, improve, and deliver trusted data that supports critical business processes and enables sound decisions.
SAP Business Objects Data Services combines industry-leading data quality and integration into one platform. With Data Services, your organization can transform and improve data anywhere. You can have a single environment for development, runtime, management, security and data connectivity.
One of the fundamental capabilities of Data Services is extracting, transforming, and loading (ETL) data from heterogeneous sources into a target database or data warehouse. You create applications (jobs) that specify
data mappings and transformations by using the Designer.
Use any type of data, including structured or unstructured data from databases or flat files to process and cleanse and remove duplicate entries. You can create and deliver projects more quickly with a single user interface and performance improvement with parallelization and grid computing.
Data Services Real Time interfaces provide additional support for real-time data movement and access. Data Services Real Time reacts immediately to messages as they are sent, performing predefined operations with message content. Data Services Real Time components provide services to web applications and other client applications.
The Data Services product consists of several components including:
The Designer allows you to create, test, and execute jobs that populate a data warehouse. It is a development tool with a unique graphical user interface. It enables developers to create objects, then drag, drop, and configure them by selecting icons in a source-to-target flow diagram. It allows you to define data mappings, transformations, and control logic. Use the Designer to create applications specifying work flows (job execution definitions) and data flows (data transformation definitions).
• Job Server
The Job Server is an application that launches the Data Services processing engine and serves as an interface to the engine and other components in the Data Services suite.
The Data Services engine executes individual jobs defined in the application you create using the Designer. When you start your application,the Data Services Job Server launches enough engines to effectively accomplish the defined tasks.
The repository is a database that stores Designer predefined system objects and user-defined objects including source and target metadata and transformation rules. In addition to the local repository used by the Designer and Job Server, you can optionally establish a central repository for object sharing and version control.
Business Objects Data Services (along with Xcelcius) Version 4.0
What is Data Services
Importance of Data Services
Position of Data Services in BI Solution
Architecture of Data Services
- Components of Data Services
Building blocks in Data Services Designer
- Sources – Files, Tables
- Targets – Files, Tables
- Query Transform
- Few Important Transforms
Running the BODS Jobs
- Scheduling the BODS Jobs
What is Xcelcius / SAP BO Dashboard Designer
Importance of Xcelcius
Position of Xcelcius in BOBJ Solution
Understanding the Interface of Xcelcius
Quick walk through the types of Components
Using the Excel connectivity to Components
Design simple dashboard
Query / Web service connectivity to Xcelcius components
BODS Training, BODS Training Toronto, BODS Training Mississauga