SAP BODS

SAP BODS

Business Objects's Data Integrator is a data integration and ETL tool that was previously known as ActaWorks. Newer versions of the software include data quality features and are named SAP BODS (BusinessObjects Data Services). The Data Integrator product consists primarily of a Data Integrator Job Server and the Data Integrator Designer. It is commonly used for building data marts, ODS systems and data warehouses, etc.

Additional transformations can be performed by using the DI scripting language to use any of the already-provided data-handling functions to define inline complex transforms or building custom functions.

Data Integrator Designer stores the created jobs and projects in a Repository. However, Data Integrator Designer also facilitates team-based ETL development by including a Central Repository version control system. Although this version control system is not as robust as standalone VCSs, it does provide the basic check-in/check-out, get latest, version labeling and undo checkout functionality. The DI Job Server executes monitors and schedules jobs that have been created by using the Designer.

Course content:

Introduction
    What is a data warehouse?
    Data Warehouse Functions & Implementation
    Data Warehouse Products & Vendors
    About SAP & Their Products
    SAP's Data Warehouse product-SAP BW
    SAP BW functions, benefits & limitations
    About Business Objects & their Products
    SAP BO Product Portfolio- BI, EIM

SAP BO Data Service Overview
    About Data Services-Introduction
    Functions-Data Integration & Data Management
    Data Services Product Evolution (ATL, DI & DQ)
    Architecture-by Components
    BO Data Services Tools & its Functions
    BO Data Services Objects & Object Hierarchy
    BODS Objects Naming Standards
    BODS Objects Comparison with SAP BW Objects

SAP BO Data Services-Basic Level
    Resiportary Manager-BODS Resiportary
    Resiportary Types-Local, Central, Profile, Data Package
    Resiportary Creation & Up gradation
    Server Manager Job Server-Resipository Assignment
    Management Console- Introduction & Components
    Data Service Designer-Introduction & GUI
    Getting Start with Designer to develop First ETL Flow

Data store & Formats
    Data store-Overview & Types
    Data store creation - DB, SAP, Adaptor, and Web service
    Formats - Flat file, DTD, XSD, COBOL, copybooks
    Data Extraction from Database Tables
    Data Extraction from Excl Workbook- Multiple Sheets
    Data Extraction from flat files (CSV, Notepad, and SAP Transport)
    Data Extraction from XML FILE (DTD, XSD)
    Data Extraction from COBOL Copybooks
    Data Distribution to flat file & XML
    Dynamic Extraction-File Selection & Sheet Selection

SAP BO Data Services-Transforms
    Transforms & Category (DI, DQ, PF)
    Data Integrator-Data Transfer, Date Generation
    Data Integrator- Effective_Data, Hierarchy_Flatterning
    Data-Integrator-History _Preserving, Key _Generation
    Data Integrator-Pivot, Reserve_Pivot, XML_Pipeline
    Platform-Case, Map_Operation, Merge, query
    Platform-SQL, Validation, Custom ABAP Transform
    Data Quality-Introduction, standard content directions
    Data Quality-Dictionaries Configuration
    Data-Country_ID, Geocoder, Global_Adress_Cleanse

SAP BO Data Services-Advance Level
    BODS Admin Console-Administration, Auto Reporting
    Real time Jobs, Embedded Data Flows
    Variables, Parameters, Substitution Parameters, System Config
    Debugging, Recovery Mechanism
    Data Assessment-Data Profiling
    BODS Performance Tuning Techniques
    Multi-User Development Environment-Into &Advantages
    Multi -User Environment-Implementation & Migration
    BODS Objects Migration Techniques

Data Services-SAP Systems Handing
    SAP systems into, SAP Systems allowed, Terminology
    SAP BODS and sap ERP/SAP BI Integration
    SAP BODS User & Role Creation in SAP
    SAP ERP -Data Flow, Interfaces, and Objects allowed to BODS
    CREATING sap Application Data store-Properties
    SAP ERP-Tables & Hierarchies Data Extraction
    SAP ERP-Getting RFC enabled Functions Modules
    SAP ERP-IDOC Data Extraction & IDOC Data Loading
    SAP ERP- Extracting Flat files data from SAP APP Server
    SAP BW-Data Flow, Interfaces Objects allowed to BODS
    Creating SAP BW Source & SAP BW Target Data stores
    SAP BW-Extracting Data from SAP BW info Providers-OHD
    SAP BW -Extracting Data from SAP BW bases tables-/BIC/
    SAP BW -Loading data to SAP BW info Providers (MD & TD)
    SAP BW -BW Jobs Execution