SAP BODS (BusinessObjects Data Services) is a data integration and transformation tool used to extract, transform, and load (ETL) data from various sources into target systems. It is part of the SAP BusinessObjects suite of tools and is designed to work with SAP and non-SAP data sources. To get best SAP BODS Training in Chandigarh, join GB training & placement centre.

Course content

Chapter 1. Dataware housing concepts

• Describe dimensional modeling

Chapter 2. Understanding Data Integrator

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

Chapter 3. Defining source and target metadata

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

Chapter 4. Validating, tracing, and debugging jobs  

• Use description and annotations
• Validate and trace jobs
• Use view data and the Interactive Debugger

Chapter 5. Creating a batch job

• Create a project, job, work flow, and data flow
• Use the query transform in a data flow
• Use template tables

Chapter 6. Using built-in transforms and nested data

• Use the case, merge, and validation transforms
• Use the Pivot, reverse Pivot
• Hierarchy flattening

Chapter 7. Using built-in functions

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

Chapter 8. Using Data Integrator Scripting Language and Variables

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

Chapter 9. Capturing Changes in Data

• Use Change Data Capture (CDC) with time-stamped sources
• Create an initial and delta load job
• Use history preserving transform

Chapter 10. Handling errors and auditing

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

Chapter 11. Supporting a multi-user environment

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

Chapter 12. Migrating Projects

• Work with projects in the central repository
• Creation of Profile Repository
• Understand Profiling

Chapter 13. Using the Administrator

• Add a repository and user roles
• Set the job status interval and log retention period
• Execute, schedule, and monitor batch jobs

Chapter 14. Profiling Data

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

Chapter 15. Managing Metadata

• Import and export metadata
• Use Metadata Reports

Chapter 16. Data Quality Management

Chapter 17. SAP Integration

• Data extraction from ECC system to File, Table and SAP BI
• ABAP WorkFlows
• Extracting data from SAP BI using Openhub Services and Data services as 3^rd party system