SAP BODS 4.2 ON HANA

Description:

SAP BODS is a data processing platform, it is used in extracting data from all types of dissimilar systems, transform it into meaningful information and load it into diverse types of systems. With full visibility into data quality, business users of an organization can observe that how their data measures up against information governance rules and standards. Understand the working and importance of SAP BODS to deliver better solutions during crisis. Our training comprises of Basic data profiling and Query Transform, Platform Transforms Overview, Data Integrator Transforms and many more.

Did you know?

• It consolidates all information in the Enterprise Data Warehouse resulting in easy access to all data sources through local interfaces.
• SAP BODS fixes the data quality issues thereby harmonizing non-SAP data and SAP standards, enrich and cleanse data, remove duplicates.
• Standardize on single platform for all data extraction, validation and cleansing rules, so that SAP and non-SAP data can be combined, cleansed and validated before loading into BW.

Any Graduates/Post Graduates are eligible. Candidates looking to build a career in SAP BODS. Candidates looking for a career in SAP. Candidates with IT background. Candidates who wants to secure a job and applicable for domestic and global job market. Candidates who are already SAP consultants and willing to learn new module. SAP end users. Candidates as Project Managers and Data Warehousing Consultants who work with data integration. Candidate with Project team members with basic knowledge of Data Integration and Data Warehousing concepts.

Internationally Accepted Certificate

Duration of Course:

• 40+ hours

Topics Covered are:

Chapter 1 - 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 Modeling
• 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

Chapter 2 - Basics of BODS:

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

Chapter 3 - Basic data profiling and Query Transform:

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

Chapter 4 - 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

Chapter 5 - Platform Transforms Overview:

• Case and Merge transforms
• SQL transform
• Validation transform
• Row Generation
• Map Operation
• Combining Validation and Auditing - best practices

Chapter 6 - Data Integrator Transforms:

• Working with hierarchical data
• Hierarhy Flattening transform
• Merging data
• Table Comparison transform
• Other ways of merging data for RDBMS datastores
• Slowly changing dimension support in BODS
• History preserving transform

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 - 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

Chapter 9 - 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

Chapter 10 - 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

Chapter 11: 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
• Sefining SAP Net Weaver BW Datastores using DataservicesLoading into SAP NW BW using Dataservices.

Chapter 12:Data Provisioning using BODS 4.2 workbench:

• Workbench user Interface
• Data Flow editor
• Monitoring editor
• File Format editor
• Replication job editor
• Datastore editor

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

Chapter 13:SAP HANA 1.0 SPS67 BODS INTEGRATION:

• BODS 4.0 With SAP HANA to builg Agile Datamarts using Diffrennt Transforms and File systems
• Chapter 10 - Error Handling in BODS
• Validating Data Flow, Workflow, Job
• Error handling on Workflow lebel - Try and Catch objects
• Analyzing execution of Batch Job - Log files
• Debugging in BODS
• Handing execution errors - best practices

Chapter 14 - 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

Chapter 15- 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

Chapter 16- Using BODS Metadata:

• Access to BODS metadata
• Operational metadata
• Auditing metadata
• Creating your own metadata by using BODS metadata

Chapter 17 - Possible Alternative Topics:

• Data Quality in BODS
• SAP and SAP BODS
• Real-time jobs
• Integration with other applications
• Automatic job creation from template

Knowasap provides best online self learning SAP courses and high end technologies courses that maximizes learning outcomes and career opportunity for professionals and as well as students. Experienced consultants, project team members, support professionals, end users, executives and students will find courses to meet their needs that are accessible anytime, anywhere.