BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

[email protected]

SAP BODS Online Training


BESTWAY Technologies Providing SAP BODS Training in Hyderabad, Vijayawada and Bangalore. SAP Business Objects Data Services Online Training in Bangalore and Hyderabad. The software is a component of the SAP Business Objects enterprise information management solutions and allows you to extract & integrate data for analytical reporting & e-business.

 

SAP BODS Course Content

SAP BODS/Data Services/Data Integrator

Introduction

  • Introduction to Integration Approaches
  • What is ETL?
  • What is DataWarehouse?
  • Introduction to Data warehouse
  • Implementations

Data Services Basic Level Understanding Data Integrator

  • Describe components, management tools, and the development process
  • Explain object relationship

Defining source and target metadata

  • Create a database data store and import Metadata
  • Create a new file format and handle errors in file formats

Validating, tracing, and debugging jobs

  • Using descriptions and annotations
  • Validate and trace jobs
  • Using View Data and the Interactive Debugger

Creating a batch job

  • Create a project, job, work flow, and data flow
  • Using the Query transform in a data flow
  • Using template tables

Data Services Advance Level Using built-in transforms and nested data

  • using the case, merge, and validation transforms

Data Services Advance Level concepts.…

  • Import metadata from XML documents
  • using the XML_Pipeline in a data flow

Using built-in functions

  • Using date and time functions and the date generation transform to build a dimension table
  • Using the lookup functions to look up status in a table
  • Using match pattern functions to compare input strings to patterns
  • Using database type functions to return information on data sources

Using Data Integrator Scripting Language and variables

  • Explain differences between global and local variables
  • Create global variables and custom functions
  • Using strings and variables in Data Integrator scripting language

Capturing Changes in Data

  • Using Changed Data Capture (CDC) with time-stamped sources
  • Create an initial and delta load job
  • Using history preserving transforms
  • Implementing SCD Type 0,1,2,3

Handling errors and auditing

  • Recover a failed job
  • Create a manual, recoverable work flow
  • Define audit points, rules and actions on failures

Supporting a multi-user environment

  • Describe terminology and repository types in a multi-user environment
  • Create and activate the central repository
  • Work with objects in the central repository

Migrating Projects

  • Create multiple configurations in a datastore
  • Work with projects in the central repository
  • Create a secure central repository
  • Implement and modify group permissions

SAP BODS/Data Services/Data Integrator

Data Services Advance Level cont.…

Profiling Data

  • Set up the Data Profiler and users
  • Submit a profiling task
  • Monitor profiling tasks in the Administrator

Managing Metadata

  • Import and export metadata
  • Using Metadata Reports

Performance Tuning Datastore & Formats

  • Datastore – Overview & Types
  • Datastore creation- DB, SAP, Adaptor, Webservice
  • Formats-Flat file, Excel, DTD, XSD

Data Services Transforms

Overview of Transforms & Category

(DI, DQ and PF)

  • All Transforms of Data Integrator and PF
  • will be covered with examples

Data Services Administration

  • Management Console operations
  • Server Manager Operations
  • Repository Manager Operation
  • License Manager – adding and upgrading license keys
  • Execute, schedule, and monitor batch jobs

Dataservices SAP System Handling

  • SAP Systems-Introduction
  • SAP BODS and SAP ERP/BW integration
  • Creation of SAP ERP Datastore and overview of properties
  • Creation of SAP BW source & target

Datastores and overview of properties

  • SAP ERP creating and getting RFC enabled Function Modules
  • SAP ERP Tables data extraction
  • SAP BW Dataflow, Interfaces, objects allowed to BODS
  • SAP BW Extracting data from SAP BW Infoproviders
  • Introduction to RAPID MARTS

Introduction to SAP HANA

  • Configurations in HANA and BODS
  • loading data to SAP HANA using BODS

Spotlights

Real Time Scenarios with advanced examples

Real Time Environment Explanation

  • Project Landscape
  • Deployment Procedure
  • Production Support Procedure
  • Documentation

Suggestions for Resume Preparation

Suggestions for Interview Preparation

SAP DATA SERVICES4.1

Introduction

  • About SAP Business Objects Suite (BI & EIM)
  • SAP Data Services 4.1 Introduction & Overview
  • SAP Data Services 4.1 Installation – with BOE CMC (CMC, BODS Server, Designer)
  • SAP Data Services 4.1 Installation—with IPS (IPS, BODS Server, Designer)
  • SAP Data Services4.1 Administration & Configuration (Server Manager, DSM Console)

New Functionalities & Features Graphical User Interface

  • Server Manager, Designer
  • Management Console, CMC/Information Platform Services (IPS)

New Security Features

  • User Management in CMC/IPS
  • Data Services Standard Users & User Groups
  • User Security-Local Repository & Central Repository & DSM Console
  • Transforms- Data Integrator, Data Quality & Platform
  • Password Encryption

Text Data Processing

  • About SAP Data Services Text Analysis
  • Text Analysis in Data Services 4.0
  • Introduction to Text Services Platform and Administrator
  • Maintaining Text Services Platform
  • Extracting Text Data- Email, Text, PortalData, Internet Data
  • New Flat File Format Types – Unstructured Text, Unstructured Binary

Transforms & Functions

  • New Validation Transform Features
  • New Joins in Query Transform
  • New Hierarchy FlatteningTransform Features

SAP Extraction

SAP Business Content Extractors i.e. Data Sources extraction from ERP

Other Features

  • New Operational Features-Designer GUI Keyboard accessibility, Multi-Language support
  • Source & Target additional properties
  • Migration Techniques
  • Request Demo