$ 14

SAP BO Data Services (BODS) is an ETL tool used for data integration, data quality, data profiling and data processing. It allows you to integrate, transform trusted data-to-data warehouse system for analytical reporting.

Categories: ,



Introduction to Introduction

  • Introduction to SAP HANA
  • SAP In-Memory Strategy
  • HANA compare to BWA

Look and Feel

  • In-Memory Computing Studio
  • Administration view
  • Navigator View
  • System Monitor
  • Architecture Overview
  • IMCE and Surroundings
  • Row Store
  • Column Store
  • Loading data into HANA
  • Data Modelling
  • Reporting
  • Persistent Layer
  • Backup & Recovery
  • Place of BODS among modern DI software package
  • Competitive advantage of BODS
  • ETL and ELT approach
  • How both approaches can be combined in one tool
  • Data Services components and architecture
Basics of BODS
  • Concepts of Job, Workflow and Data Flow
  • Concepts of Data store
  • Creating basic Batch Job
  • Transforms overview
Basic data profiling and Query Transform
  • Analysing data sources
  • Joining data from multiple sources
  • Basic transformations and build-in functions
  • Aggregating data in BODS
  • Look ups
Working with Files
  • Defining file formats for file data source
  • Working with XML files(XSD,DTD)
  • File Formats as Source and as Targets
Platform Transforms Overview
  • Case and Merge transforms
  • SQL transform
  • Validation transform
  • Row Generation
  • Map Operation
  • Combining Validation and Auditing – best practices
Data Integrator Transforms
  • Working with hierarchical data
  • Hierarchy Flattening transform
  • Merging data
  • Table Comparison transform
  • Other ways of merging data for RDBMS data stores
  • Slowly changing dimension support in BODS
  • History preserving transform
 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

Metadata Management
  • Local and Central repositories
  • Working in a group
  • Propagating Job from development to staging and production environment – best practices
  • Backing up metadata
  • ATL file. Export\Import operations
  • Validating, tracing, and debugging jobs
  • Use description and annotations
  • Validate and trace jobs
  • Use view data and the Interactive Debugger
Management Console
  • Administrating BODS
  • Overview of all major tools
  • Execution of a Job from server
  • Scheduling a job
  • Auto Documentation reports
  • Designing ETLs with auto documentation in mind
BODS Scripting Language
  • Variables in BODS – Scope of variable
  • Scripting language – Advantages and limitations
  • Custom functions in BODS
  • Creating simple function
  • Database procedures
  • Custom functions. database functions
  • Connecting to SAP Applications
  • ABAP data Flow processing using Data services
  • IDoc interface connectivity using Data services
  • SAP Application table source in real jobs using Data services
  • Executing Batch jobs that contain ABAP Data flows
  • Connecting to SAP Net weaver Business warehouse
  • Using Data services in SAP NW BW environments,Open hub tables
  • Defining SAP Net Weaver BW Data stores using Data services Loading into SAP NW BW using Data services.

Data Provisioning using BODS 4.2 workbench
1. Workbench user Interface

  • Data Flow editor
  • Monitoring editor
  • File Format editor
  • Replication job editor
  • Data store editor

2.Information Steward

  • Getting started with Cleansing Package Builder
  • About cleansing data
  • About cleansing packages
  • Cleansing package types
  • Create cleansing packages
  • Assign standard forms and variations
  • updating a published cleansing package
  • viewing published cleansing packages
  • Person and firm cleansing package
  • BODS 4.0 With SAP HANA to built Agile Data marts using Different Transforms and File systems
  • Error Handling in BODS
  • Validating Data Flow, Workflow, Job
  • Error handling on Workflow label – Try and Catch objects
  • Analyzing execution of Batch Job – Log files
  • Debugging in BODS
  • Handing execution errors – best practices
Performance optimization in BODS – Part 1
  • Push-down concept
  • Cases when push-down doesn’t work
  • Data Transfer transform
  • Cashing in BODS
  • Defining cashing for look ups and Table Comparison
Performance optimization in BODS – Part 2
  • Degree of parallelism
  • Designing custom function for parallel execution
  • Bulk loading operation
  • using Multi Load for Tera data targets
  • Execution parameters
  • Rows per commit
  • Number of loaders
Using BODS Metadata
  • Access to BODS metadata
  • Operational metadata
  • Auditing metadata
  • Creating your own metadata by using BODS metadata
Possible Alternative Topics
  • Data Quality in BODS
  • SAP and SAP BODS
  • Real-time jobs
  • Integration with other applications
  • Automatic job creation from template


Reviews (0)


There are no reviews yet.

Be the first to review “SAP BODS”
Contact Us