Description

SAP BODS COURSE CONTENT

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

• Architecture Overview
• IMCE and Surroundings
• Row Store
• Column Store
• Loading data into HANA
• Data Modelling
• Reporting
• Persistent Layer
• Backup & Recovery

BODS

• 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)
• COBAL COPY BOOKS
• 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

SAP BW 7.3 AND SAP ECC,SAP CRM BODS INTEGRATION

• 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

SAP HANA 1.0 SPS67 BODS INTEGRATION

• 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

https://www.govideotutorials.com