SAP BODS — Course Content

• 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

• 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

• 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

• 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