Course #: 11050e - SAP BODS - Business Objects Data Service

INTRODUCTION

•     Data Integrator Overview
•     Introduction
•     Data Integrator Design
•     Data Integrator Objects

DEFINING SOURCE & TARGET METADATA IN DATA INTEGRATOR

•     Logging into the repository
•     Defining a data source
•     Importing meta data
•     Defining a file format

OBI COMPONENTS

•     OBI Administration Tool
•     OBI Answers
•     Intelligence dashboards

POPULATING THE SALES ORG DIMENSION FROM A FLAT FILE

•     Objects and their hierarchical relationships
•     Adding a new project
•     Adding a job
•     Adding a work flow
•     About data flows
•     Adding a data flow
  •         Defining the data flow
  •         Validating the data flow

ADDRESSING ERRORS

•     Saving a project
•     Executing the jobs
•     Deleting objects

POPULATING THE CUSTOMER DIMENSION FROM A RELATIONAL TABLE

•     Adding CUST dim job and work flow
•     Adding CUST dim data flow
•     Defining the CUST dim data flow
•     Validating the CUST dim data flow
•     Executing the CUST dim job
•     Using the interactive debugger

POPULATING THE MATERIAL DIMENSION FROM AN XML FILE

•     Adding material dim job ,work and data flow
•     Importing a document type definition
•     Defining the material dim data flow
•     Validating the material dim data flow
•     Leveraging the XML-PIPE line

POPULATING SALES FACT TABLE FROM MULTIPLE RELATIONAL TABLES

•     Using meta data reports

CHANGED DATA CAPTURE

•     Adding and defining the initial load job
•     Adding and defining the delta-load job
•     Executing the jobs

DATA QUALITY

•     Overview
•     Viewing profile statistics
•     Defining a validation transform based on data profile statistics
•     Auditing a data flow
•     Viewing audit details in operational DASHBOARD reports

RECOVERY MECHANISMS

•     Creating a recoverable work flow manually
•     Adding the job and defining local variables
•     Specifying a recoverable job
•     Status of the exercise
•     Executing the job
•     Data Integrator Automated recovery properties

MULTI USER DEVELOPMENT

•     Introduction
•     Preparation
  •         Creating a central repository
  •         Creating two local repositories
  •         Associating repositories to your job server
  •         Defining connections to the central repository
  •         working in a multi user environment

EXTRACTING SAP R/3 DATA

•     an SAP R/3 data store
•     Importing metadata for SAP R/3 source tables
•     Repopulating the customer dimension table
•     Adding the SAP-CUST dim job ,workflow, and data flow
•     Defining the SAP-cust dim data flow
•     Defining the R/3 data flow
•     Validating the SAP-CUST dim dataflow
•     Executing the SAP-CUST dim job
  

Recommended Prerequisites:
There are no mandatory prerequisites. Work experience in IT services is recommended.