The Leader In IT Training & Project Support Solutions

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.

Drop us a query

Looking for a training for

 Myself My team/organization

captcha

 I agree to be contacted over email

top
Copyright © 2015 KEEN IT TECHNOLOGIES Pvt.Ltd, ALL RIGHTS RESERVED  |   PRIVACY POLICY   |   TERMS OF USE   |   REFUND AND RESCHEDULE POLICIES   |   SITEMAP  
Keen IT is not an affiliate of SAP AG or other products.