Course Curriculum

No curriculum found !

Curriculum

Introduction to SAP 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 SAP BODS

  • Concepts of Job, Workflow and Data Flow
  • Concepts of Datastore
  • Creating basic Batch Job
  • Transforms overview

Basic Data Profiling and Query Transform

  • Analyzing data sources
  • Joining data from multiple sources
  • Basic transformations and build-in functions
  • Aggregating data in BODS
  • Lookup

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 datastores
  • 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. ExportImport 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 vs. database functions

SAP BW 7.3 and SAP ECC, SAP CRM BODS Integration

  • Connecting to SAP Applications
  • ABAP data Flow processing Using Dataservices
  • IDoc interface connectivity Using Dataservices
  • SAP Application table source in real jobs using Dataservices
  • Executing Batch jobs that contain ABAP Dataflows
  • Connecting to SAP Net weaver Business warehouse
  • Using Dataservices in SAP NW BW environments, Openhub tables
  • Defining SAP Net Weaver BW Datastores Using Data services
  • Loading into SAP NW BW using Dataservices

SAP HANA 1.0 SPS5   BODS Integration

  • BODS 4.2 With SAP HANA to builgAgile Datamarts using Different Transforms  and File systems

Error Handling in SAP BODS

  • Validating Data Flow, Workflow, Job
  • Error handling on Workflow level – 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 lookups and Table Comparison

Performance optimization in BODS – Part 2

  • Degree of parallelism
  • Designing custom function for parallel execution
  • Bulk loading operation
  • Using MultiLoad for Teradata 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 job
  • Integration with other applications
  • Automatic job creation from template

Data Loads from BODS to HANA Project orientation based on Sap standards and methodologies (AIO, BPDM, RDS)

Demo Video

SAP BODS Training
SAP BODS Online Training

Course Reviews

3.6

3.6
40 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • 10 Hours
0 STUDENTS ENROLLED




    Looking for:
    ClassroomOnline

    Key Features

    We provide Job Oriented hands on practical training by real time working professional. its suitable for fresher and professional.

    We provide hard copy for classroom students / soft copy for online students.

    You will get lifetime video access - Online Students

    we provide 24/7 support by any type of issues regarding classes and accessing.

    You will get course completion certificate when you finished the course.

    QEdge provides you job assistance, we have 150+ clients across the globe. We don’t charge any extra fees for this.

    All rights reserved - © QEdge Technologies