SAP BODS Online Training
Pin It

SAP BODS Online Training:

SAP BODS Online Training Overview:

Business Objects Data Services is a complex platform for the data integration process and constitutes the latest version of Business Objects application.

 

boda hana SAP BODS Online Training

BODS Online Training

The SAP BusinessObjects Data Services application can help by delivering a single enterprise-class solution for data integration, data quality, data profiling, and text analysis that allows you to integrate, transform, improve, and deliver trusted data that supports critical business processes and enables sound decisions.

SAP BusinessObjects Data Services combines industry-leading data quality and integration into one platform. With Data Services, your organization can transform and improve data anywhere. You can have a single environment for development, runtime, management, security and data connectivity.

One of the fundamental capabilities of Data Services is extracting, transforming, and loading (ETL) data from heterogeneous sources into a target database or data warehouse. You create applications (jobs) that specify
data mappings and transformations by using the Designer.

Use any type of data, including structured or unstructured data from databases or flat files to process and cleanse and remove duplicate entries. You can create and deliver projects more quickly with a single user interface and performance improvement with parallelization and grid computing.

Data Services RealTime interfaces provide additional support for real-time data movement and access. Data Services RealTime reacts immediately to messages as they are sent, performing predefined operations with message content. Data Services RealTime components provide services to web applications and other client applications.

The Data Services product consists of several components including:

Designer

The Designer allows you to create, test, and execute jobs that populate a data warehouse. It is a development tool with a unique graphical user interface. It enables developers to create objects, then drag, drop, and configure them by selecting icons in a source-to-target flow diagram. It allows you to define data mappings, transformations, and control logic. Use the Designer to create applications specifying work flows (job execution definitions) and data flows (data transformation definitions).

Job Server

The Job Server is an application that launches the Data Services processing engine and serves as an interface to the engine and other components in the Data Services suite.

Engine

The Data Services engine executes individual jobs defined in the application you create using the Designer. When you start your application,the Data Services Job Server launches enough engines to effectively accomplish the defined tasks.

Repository

The repository is a database that stores Designer predefined system objects and user-defined objects including source and target metadata and transformation rules. In addition to the local repository used by the Designer and Job Server, you can optionally establish a central repository for object sharing and version control.

 

SAP BODS Course Content:     Request a demo button SAP BODS Online Training

DW Concepts

  • Definition
  • Methodologies
  • Dimensional Modeling
  • DW Lifecycle
  • DW Challenges

ETL Overview

  • ETL  introduction
  • Staging Area
  • Business Rules
  • Performance
  • Slowly Changing Dimensions
  • Surrogate Keys
  • Facts and Dimension Tables
  • Different ETL Tools

Business Objects Overview

  • History
  • Components
  • Architecture

Data Services

  • Purpose of Data Services
  • Data Services architecture
  • Define Data Services objects
  • Data Services Designer interface

Data Services Objects

  • Object Hierarchy
  • Jobs
  • Workflows
  • Data Flows

Source and Target Metadata

  • Data Stores
  • File formats for flat files
  • File formats for Excel files
  • File formats for XML files
  • Lab Exercises

Environment setup

  • Creating repository
  • Setting Job Server
  • Setup for realtime operation
  • Setting multiple datastores
  • Starting Job servers
  • Lab Exercises

Batch Jobs

  • Work with objects
  • Create a data flow
  • Use the Query transform
  • Use target tables
  • Execute the job
  • Lab Exercises

Troubleshooting Jobs

  • Use descriptions and annotations
  • Validate and tracing jobs
  • Use View Data and the Interactive Debugger
  • Use auditing in data flows
  • Lab Exercises

Functions, Scripts and Variables

  • Define built-in functions
  • Functions in expressions
  • Lookup function
  • Decode function
  • Variables and parameters
  • Data Services scripting language
  • Scripting custom functions
  • Lab Exercises

Important Transforms

  • Map Operation transform
  • Validation transform
  • Merge transform
  • Case transform
  • SQL transform
  • Lab Exercises

Other Transforms

  • Pivot transform
  • Hierarchy Flattening transform
  • Data Transfer transform
  • XML Pipeline transform
  • Lab Exercises

Error Handling

  • Error Handling
  • Recoverable work flows

Change Data Capture

  • Update data over time
  • Database native CDC mechanisms
  • Source-based CDC
  • Target Comparison
  • Lab Exercises

Data quality Overview

  • Fundamentals of DQ and Data Cleansing
  • Built in DQ Transformations
  • Data Validation
  • Name & Address cleansing
  • De duplication
  • Cleansing other data
  • Lab Exercises

Web-Services and Real-Time Integration

  • Real Time Jobs
  • SOAP Introduction
  • Web Services

SAP Integration

  • Creating datastores for SAP databases
  • Accessing SAP data
  • Running ABAP programs
  • R/3 Data flows

 

Incoming search terms: