BODS 4.2 Course Content

Course duration: 30 Hours
Lesson 1.Architecture of BODS 4.2
 Installation
 Introduction to Repositories
 Overview of Components and Hierarchy of Objects
Lesson 2. Installation of Local Repository
 Introduction to CMC
 Registering Repository to CMC
 Adding Repository to Job Server
 Introduction to DataStores
Lesson 3.Introduction to creation of Jobs
 Create a Project, job, work flow, and data flow
 Introduction to Management Console
 Job Execution ,Scheduling using Management Console
 Understanding the Query Transform
 Use template tables
Lesson 4. Validating, tracing, and debugging jobs
 Use description and annotations
 Validate and trace jobs
 Use view data and the Interactive Debugger
Lesson 5. Defining source and target metadata
 Create a database datastore and import metadata
 Create a new file format and handle errors in file formats
 Understand extraction using Flat files,XML,Cobol Copybooks
Lesson 6. Using built-in transforms and nested data
 Use the case, merge, and validation transforms
 Use the Pivot, reverse Pivot
 Hierarchy flattening
Lesson 7. Using built-in transforms 2
 Use the SQL transform, Map Operation, and XML Pipeline
 Use the Row Generation Transform, Date Generation, Data Transfer
 MAP_CDC_Operation, Table Comparison, History Preservation
Lesson 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
Lesson 8. Using Data Services 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
Lesson 9. Change Data Capture
 Use Change Data Capture (CDC) with time-stamped sources
 Source CDC concept and working
 Target CDC concept and working
 Working with Slowly Changing Dimensions(type1,2,3)
 Create an initial and Delta load job
 Use history Preserving Transform
Lesson 9. Supporting a multi-user environment
 Describe terminology and repository types in a multi-user environment
 Introduction to Secure Central Repository and Non-Secure Central Repo
 Create and Activate the Central repository
 Create user and Privileges with Secure Central Repository
 Understand Check In,Check Out ,Get Options

Lesson 10. Profiling Data
 Set up the Data Profiler and users
 Submit a profiling task
 Monitor profiling tasks in the Administrator
Lesson 11.Handling errors and auditing
 Recover a failed job
 Create a manual, recoverable work flow
 Define audit points, rules and actions on failures
Lesson 12. Migrating Projects & Managing Metadata
 Work with projects in the central repository
 Creation of Profile Repository
 Understand Profiling
 Import and export metadata
 Use Metadata Reports
Lesson 13.Data Quality Management Lesson14.SAP Integration
 Data extraction from ECC system to File, DatabaseTables
 Extraction using ODP Extractors
 Extraction using BAPIs and Function Modules
 ABAP WorkFlows
 Extracting data from SAP BI using Openhub Services and Data services as 3rd party system.
 Working with SAP Function Modules.
 Configuration and RFC Maintenance
Lesson15.SAP Integration Part 2
 Load Data into SAP systems using IDocs
 Load Data into SAP systems using LSMWs
Lesson16. Rapid Deployment Solutions
 Understanding the AIO methodology of Data Migration
 Installation of SAP BPDM Job(best Practice Data Migration Jobs)
 Working and Architecture of the RDS
 Customizing the RDS
Lesson17.SAP Integration
 Integration of SAP HANA with BODS
 Configuring the SAP HANA Datastore
 Loading into SAP HANA(ECC,Flatfiles,Db tables)
 Working with the SAP Dataservices Workbench