Key Features

Hands-on projects execution

Expert Assistant

24/7 Server access

Project explanations and placements



Instructor led Training

High Quality e-learning

Resume preparation guidance

SAP HANA BODS (Business Objects Data Services)
What is this course about?

BODS (Business Objects Data Services) is an ETL tool only. It delivers a single enterprise-class solution for Data Integration, Data Quality, Data Profiling, and Text Data Processing .It allows us to integrate, transform, improve, and deliver trusted data to critical business processes.

Prerequisites: Basic knowledge of ETL (Extraction, Transformation, and Loading) of data processes

Introduction
  1. What is a data warehouse?
  2. Data Warehouse Functions & Implementation
  3. Data Warehouse Products & Vendors
  4. About SAP & Their Products
  5. SAP's Data Warehouse product-SAP BW
  6. SAP BW functions, benefits & limitations
  7. About Business Objects & their Products
  8. SAP BO Product Portfolio- BI, EIM
SAP BO Data Service Overview
  1. About Data Services-Introduction
  2. Functions-Data Integration & Data Management
  3. Data Services Product Evolution (ATL, DI & DQ)
  4. Architecture-by Components
  5. BO Data Services Tools & its Functions
  6. BO Data Services Objects & Object Hierarchy
  7. BODS Objects Naming Standards
SAP BO Data Services-Basic Level
  1. Resiportary Manager-BODS Resiportary
  2. Resiportary Types-Local, Central, Profile
  3. Resiportary Creation & Up gradation
  4. Server Manager Job Server-Resipository Assignment
  5. Management Console- Introduction & Components
  6. Data Service Designer-Introduction & GUI
  7. Getting Start with Designer to develop First ETL Flow
Data store & Formats
  1. Data store-Overview & Types
  2. Data store creation - DB, SAP, Adaptor
  3. Formats - Flat file, DTD, XSD, Cobol,.csv, Excel
  4. Data Extraction from Database Tables
  5. Data Extraction from Excl Workbook- Multiple Sheets
  6. Data Extraction from flat files (CSV, Notepad, and SAP Transport)
  7. Data Extraction from XML FILE (DTD, XSD)
  8. Data Distribution to flat file & XML
  9. Dynamic Extraction-File Selection & Sheet Selection
SAP BO Data Services-Transforms
  1. Transforms & Category (Data Integration and Platform Transforms)
  2. Data Integrator-Data Transfer, Date Generation
  3. Data Integrator- Effective _Data, Hierarchy_Flatterning
  4. Data-Integrator-History _Preserving, Key _Generation
  5. Data Integrator-Pivot, Reserve_Pivot, XML_Pipeline
  6. Platform-Case, Map_Operation, Merge, query
  7. Platform-SQL, Validation, Custom ABAP Transform
  8. BODS Admin Console-Administration, Auto Reporting
  9. Real time Jobs, Embedded Data Flows
  10. Variables, Parameters
  11. SAP BODS Script Objects
  12. PARELLEL JOBS Execution
  13. Debugging, Recovery Mechanism
  14. Data Assessment-Data Profiling
  15. BODS Performance Tuning Techniques
  16. Multi-User Development Environment-Into & Advantages
Data Services-SAP Systems Handing
  1. SAP systems into, SAP Systems allowed, Terminology
  2. SAP BODS and sap ERP/SAP BI Integration
  3. Creating SAP Application Data store-Properties
  4. SAP ERP-Tables & Hierarchies Data Extraction
  5. SAP BW with RFC enabled Functions Modules
  6. Extracting SAP ECC data using DXC (Direct Extractors)
  7. SAP BW-Data Flow, Interfaces Objects allowed to BODS
  8. Introduction about SAP BW CUBES and Designing the SAP BW cubes
  9. Creating SAP BW Source & SAP BW Target Data stores
  10. SAP BW-Extracting Data from SAP BW info Providers-OHD
  11. SAP BW -Extracting Data from SAP BW bases tables-/BIC/
  12. SAP BW -Loading data to SAP BW info Providers
  13. SAP BW -BW Jobs Execution