SAP BODS — Course Content

COURSE: SAP BODS/Data Services/Data Integrator

Introduction

  • Introduction to Integration Approaches
  • What is ETL?
  • What is Data Warehouse?
  • Introduction to Data warehouse implementations

SAP Business Objects Data Services Overview

  • History of SAP BODS [evolution, acquisitions etc.]
  • Data Services Architecture
  • Data Services Tools & its functions
  • Data Services Objects & Object Hierarchy
  • Various implementations using BODS

Data Services Basic Level

Understanding Data Integrator

  • Describe components, management tools, and the development process
  • Explain object relationship

Defining source and target metadata

  • Create a database datastore and import metadata
  •  Create a new file format and handle errors in file formats

Validating, tracing, and debugging jobs

  • Using descriptions and annotations
  • Validate and trace jobs
  • Using View Data and the Interactive Debugger

Creating a batch job 

  • Create a project, job, workflow, and data flow
  • Using the Query transform in a data flow
  • Using template tables

Data Services Advance Level

Using built-in transforms and nested data 

  • Using the case, merge, and validation transforms
Data Services Advance Level cont.…

  • Import metadata from XML documents
  • Using the XML_Pipeline in a data flow

Using built-in functions

  • Using date and time functions and the date generation transform to build a dimension table
  • Using the lookup functions to look up status in a table
  • Using match pattern functions to compare input strings to patterns
  • Using database type  functions to return information on data sources

Using Data Integrator Scripting Language and variables

  • Explain differences between global and local variables
  • Create global variables and custom functions
  • Using strings and variables in Data Integrator scripting language

Capturing Changes in Data

  • Using Changed Data Capture (CDC) with time-stamped sources
  • Create an initial and delta load job
  • Using history preserving transforms
  • Implementing SCD Type 0,1,2,3

Handling errors and auditing

  • Recover a failed job
  • Create a manual, recoverable workflow
  • Define audit points, rules, and actions on failures

Supporting a multi-user environment 

  • Describe terminology and repository types in a multi-user environment
  • Create and activate the central repository
  • Work with objects in the central repository

Migrating Projects

  • Create multiple configurations in a data store
  • Work with projects in the central repository
  • Create a secure central repository
  • Implement and modify group permissions

Profiling Data

  • Set up the Data Profiler and users
  • Submit a profiling task
  • Monitor profiling tasks in the Administrator

Managing Metadata

  • Import and export metadata
  • Using Metadata Reports

Performance Tuning

Datastore & Formats

  • Datastore – Overview & Types
  • Datastore creation- DB, SAP, Adaptor, Webservice
  • Formats-Flat file, Excel, DTD, XSD

Data Services Transforms

  • Overview of Transforms & Category (DI, DQ, and PF)
  • All Transforms of Data Integrator and PF will be covered with examples
Data Services Administration

  • Management Console operations
  • Server Manager Operations
  • Repository Manager Operation
  • License Manager – adding and upgrading license keys
  • Execute, schedule, and monitor batch jobs

Data services SAP System Handling

  • SAP Systems-Introduction
  • SAP BODS and SAP ERP/BW integration
  • Creation of SAP ERP Datastore and overview of properties
  • Creation of SAP BW source & target Datastores and overview of properties
  • SAP ERP creating and getting RFC enabled Function Modules
  • SAP ERP Tables data extraction
  • SAP BW Dataflow, Interfaces, objects allowed to BODS
  • SAP BW Extracting data from SAP BW Infoproviders
  • Introduction to RAPID MARTS

Introduction to SAP HANA 

  • Configurations in HANA and BODS
  • Loading data to SAP HANA using BODS

Spotlights

Real Time Scenarios with advanced examples

Real-Time Environment Explanation

  • Project Landscape
  • Deployment Procedure
  • Production Support Procedure
  • Documentation

Suggestions for Resume Preparation

Suggestions for Interview Preparation

SAP DATA SERVICES 4.0 Introduction

Introduction

  • About SAP Business Objects Suite (BI & EIM).
  • SAP Data Services 4.0 Introduction & Overview.
  • SAP Data Services4.0 Administration & Configuration (Server Manager, DSM Console).

New Functionalities & Features

Graphical User Interface

  • Server Manager, Designer.
  • Management Console, CMC/Information Platform Services (IPS).


New Security Features

  • User Management in CMC/IPS.
  • Data Services Standard Users & User Groups.
  • User Security-Local Repository & Central Repository & DSM Console.
  • Transforms- Data Integrator, Data Quality & Platform.
  • Password Encryption.

Text Data Processing

  • About SAP Data Services Text Analysis.
  • Text Analysis in Data Services 4.0.
  • Introduction to Text Services Platform and Administrator.
  • Maintaining Text Services Platform.
  • Extracting Text Data- Email, Text, Portal Data, Internet Data.
  • New Flat File Format Types – Unstructured Text, Unstructured Binary.

Architecture & New Services

  • 64 Bit Server Components.
  • Adaptive Processing Server (EIM Service).
  • Performance & Memory Utilization Performance features.

Transforms & Functions

  • New Validation Transform Features.
  • New Joins in Query Transform.
  • New Hierarchy Flattening Transform Features.
  • New Functions- Cryptographic, gen_UUID, BLOB, Copy Query.

SAP Extraction

  • SAP Business Content Extractors i.e. Data Sources extraction from ERP.
  • SAP SLD & SMD Integration.


Other Features

  • New Operational Features-Designer GUI Keyboard accessibility, Multi-Language support.
  • Source & Target additional properties.
  • Migration Techniques.