SAP BODI Online Training
Introduction
SAP Business Objects Data Integrator is an ETL and Data Integration tool to provide data integration and was previously known as ActaWorks. It’s a GUI workspace which creates jobs from the data extracted from different sources and that data is transformed to meet enterprise requirements, then loads data in Dataware house or single data store for further analysis. It can be used for both batch jobs and real time. Previous name of data services is BODI, it mainly consists of Data Integrator Designer and Job Server. It is mainly employed for creating data marts, data warehouse and ODs system.
Course Objectives
- Transform data for analysis.
- Define Data Services and Implement Change Data Capture.
- Error handling of processes.
- Define Source and Target Connections.
- Update staged data in batch mode.
- Debug, Validate and Trace Data Services Jobs.
- Detection of data recovery and process chains.
- Description of data services of business objects in SAP.
- Stage data in an operational data mart, data store or data warehouse.
- Understand the working of Business Objects in SAP Family.
PRE-REQUISITES: Basic Knowledge of SQL Commands, Knowledge of SAP Concepts
Course Curriculum
MODULE 1: OVERVIEW OF DATA INTEGRATOR
TOPICS: About Data Integrator, Data Integrator Product Documentation
MODULE 2: OVERVIEW OF DATA SERVICES
TOPICS: Data Services Engine, Introduction of Data Services Architecture, Data Services Repository, Data Services Designer, Data Services Job Server, Data Services Administrator, Data Services Address Server, Data Services Service, Data Services Access Server, Data Services Metadata Reports Applications, Data Services SAP Rapid Marts, Data Services Adapter SDK, Data Services Snmp Agent
MODULE 3: DATA INTEGRATOR DESIGNER
TOPICS: Logging into the Designer, Data Integrator Objects, Designer Overview, General and Environment Options, Data Stores, Data Flows, File Formats, Projects and Jobs, Working with Objects, Real-Time Jobs, Embedded Data Flows, Workflows, Variables and Parameters, Data Quality, Data Cleansing, Executing Jobs, Design and Debug, Nested Data
MODULE 4:TRANSFORMS
TOPICS: About Transforms, Operation Codes, Case, Effective Date, Address Enhancement, Hierarchy Flattening, History Preserving, Date Generation, Match Merge, Pivot And Reverse Pivot, Query, Row Generation, SQL, Table Comparison, XML Pipeline, Validation
MODULE 5: FUNCTIONS AND PROCEDURES
TOPICS: About Functions, Database And Application Functions, Custom Functions, About Procedures, Calling Stored Procedures, in General, Description of Built-In Functions, Without the Function Wizard, From Queries
MODULE 6: DATA INTEGRATOR SCRIPTING LANGUAGE
TOPICS: Language Syntax, about Scripting Language, Syntax For Column and Table References in Expressions, Trailing Blanks, Syntax for Statements in Scripts, Variable Interpolation, Operators, Variables, NULL Values, Quotation Marks, Keywords, Strings, NULL Values and Empty Strings, Functions and Stored Procedures, Escape Characters, Sample Scripts, Export or Import, Debugging and Validation
MODULE 7: DATA INTEGRATOR ADMINISTRATOR
TOPICS: Administrative Management, Using Server Groups, Central Repository Management, Export Execution Command, Scheduling Jobs, Using the Administrator, Trace and Monitoring Jobs, Executing Batch Jobs, Data Integrator Job Launcher,. Using a Third-Party Scheduler
MODULE 8: DATA INTEGRATOR METADATA REPORTS
TOPICS: Viewing Metadata Reports
MODULE 9: DATA INTEGRATOR PERFORMANCE OPTIMIZATION
TOPICS: Tuning and Measuring Data Integrator Performance, Using Bulk Loading, Environment Test Strategy
Course Reviews
No Reviews found for this course.
Write a Review