ERP BODS

ERP BODS is an ETL tool currently acquired by ERP used for integration with all types of disparate systems, extracting data from them, transforming them into meaningful information and loading them into all types of systems.

It is tightly integrated with ERP systems and hence really a good tool to migrate data from legacy systems to ERP systems with ease and less development efforts with effective debugging and monitoring capabilities.

Section Heading

Course Information

Duration: 40 Hours

Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Method: Online/Classroom Training

Study Material: Soft Copy

System Access: For 1 month

Course Content

Introduction

  • What is a Data Warehouse?
  • Data Warehouse Functions & Implementation
  • Data Warehouse Products & Vendors
  • About ERP & their Products
  • ERP’s Data Warehouse product – ERP BW
  • ERP BW functions, Benefits & Limitations
  • About BusinessObjects & their Products
  • Why ERP Acquired BusinessObjects
  • Data Centric Vs Process Centric DWH system
  • BusinessObjects Vs ERP BOBJ
  • ERP BOBJ Product Portfolio – BI, EIM, EPM, GRC, AA

ERP BOBJ Data Services Overview

  • About Data Services – Introduction & BI Platform
  • Functions – Data Integration & Data Management
  • Data Services Product Evolution (ATL, DI & DQ)
  • Architecture – by Components
  • Installation of Data Services on Windows
  • Data Services Tools & its functions
  • Data Services Objects & Object Hierarchy
  • BODS Objects Naming standards
  • BODS Objects comparison with ERP BW Objects

Data Services – Basic Level

  • Repository Manager – BODS Repository
  • Repository Types – Local, Central, Profile, Data Package
  • Repository Creation & Upgradation
  • Server Manager – Job Server (JS) & Access Server (AS)
  • JS & AS Creation, Job Server-Repository Assignment
  • Metadata Integrator – Sharing the BODS Metadata to BOXI
  • License Manager – Adding or Upgrading the Keys
  • Management Console – Introduction & Components
  • Data Service Designer – Introduction & GUI
  • Getting Start with Designer to develop First ETL Flow

Datastore & Formats

  • Datastore – Overview & Types
  • Datastore creation – DB, ERP, Adaptor, Web Service
  • Formats – Flat file, Excel, DTD, XSD, COBOL Copybooks
  • Data Extraction from Database Tables
  • Data Extraction from Excel Workbook – Multiple Sheets
  • Data Extraction from Flat file (CSV, Notepad, and ERP 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

Data Services – Transforms

  • Transforms & Category (DI, DQ, PF)
  • Data Integrator – Data_Transfer Transform, Date_Generation Transform
  • Data Integrator – Effective_Date, Hierarchy_Flattening
  • Data Integrator – History_Preserving, Key_Generation
  • Data Integrator – Map_CDC_Operation, Table_Comparision
  • Data Integrator – Pivot, Reverse_Pivot, XML_Pipeline
  • Platform – Case, Map_Operation, Merge, Query
  • Platform – SQL, Validation, Custom ABAP Transform
  • Text Analysis – Introduction & TDP vs. TA
  • Text Analysis – Base Entity Extraction Transform
  • Text Analysis – Unstructured Data Extraction, Dictionaries & Rules and Language Modules

Data Services – Advance Level

  • BODS Admin Console – Administration, Auto Reporting
  • Real time Jobs, Embedded Data Flows & Security
  • 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

Data Services – ERP Extraction Introduction

  • ERP Systems – Into, ERP Systems allowed, Terminology
  • ERP BODS and ERP ERP / ERP BI Integration
  • ERP BODS User & Role creation in ERP

Data Services – ERP ERP Extraction

  • ERP ERP – Data Flow, Interfaces, and Objects allowed to BODS
  • Creating ERP Application Datastore – Properties
  • ERP ERP – Tables & Hierarchies Data Extraction
  • ERP ERP – Getting RFC enabled Functions Modules
  • ERP ERP – IDOC Data Extraction & IDOC Data Loading
  • ERP ERP – Extracting Flat file data from ERP APP Server
  • Data Services – ERP BW/BI Extraction & Loading
  • ERP BW – Data Flow, Interfaces, and Objects allowed to BODS
  • Creating ERP BW Source & ERP BW Target Datastores
  • ERP BW – Extracting Data from ERP BW InfoProviders – OHD
  • ERP BW – Extracting Data from ERP BW bases tables - /BIC/
  • ERP BW – Loading data to ERP BW InfoProviders (MD & TD)
  • ERP BW – BW Jobs Execution

Data Services – ERP Advanced Concepts

  • ERP BusinessObjects Rapid Marts – Introduction & Overview and differences between 3.x and 4.x
  • ERP BusinessObjects Extractors Extraction – Introduction of ODP, ERP DataSources Extraction, ERP Delta Mechanism and DOP Queue
  • ERP Data Migration with BODS – Data Migration Techniques, BODS Data Migration to ERP, Data Migration Tool Introduction and Overview

Key Features

Instructor Led Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Request For Demo

Training Calendar

Module Classroom/Online Location
ERP EWM  Online Instructor-Led Online
ERP TM Online Instructor-Led Online
ERP GTS Online Instructor-Led Online
ERP MM Online Instructor-Led Online

Our Clients