BusinessObjects Data Integrator 4.0

RapidDecision pre-built data warehouse software utilizes Business Objects Data Services 4.0 (Data Integrator) to manage and facilitate critical elements of the RapidDecision data structure.  This hands-on, instructor-led offering is a three-day course that utilizes SAP Authorized course material.

Who Should Attend
RapidDecision users responsible for implementing, administering, and managing data integration projects.

What You Will Learn
In this course participants learn how to administer and operate SAP Business Objects Data Integrator in a production RapidDecision CDC environment.  Content will include creating, executing, and troubleshooting batch jobs, using functions, scripts and transforms to change the structure and formatting of data, handling errors, setting yup a replication schema, capturing changes in replicated data, and an overview of the RapidDecision batch job scream methodology.

Topics covered
Describing Data Services

  • Describe the purpose of Data Services
  • Describe Data Services architecture
  • Define Data Services objects

Defining Source and Target Metadata

  • Datastores in Data Services
  • Data Services system configurations
  • Flat file formats
  • Excel file formats

Creating Batch Jobs

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

Troubleshooting Batch Jobs

  • Setting Traces and adding annotations
  • Using the Interactive Debugger
  • Configuring and using the Audit features

Using Functions, Scripts, and Variables

  • Using the built-in functions
  • Using the Map Operations transform
  • Using the Validation transform
  • Using the Merge transform
  • Using the Case transform
  • Using the SQL transform

Setting up Error Handling

  • Set up recoverable work flows

Using Data Integrator Transforms

  • Describe the Data Integrator transforms
  • Use the Pivot transform
  • Describe performance optimization
  • Use the Data Transfer transform

Data Integrator & CDC via Replication Services

  • Overview of Replication Services in MS SQL Server
  • Replication CDC in Business Objects Data Integrator
  • Configuring replication in CDC in Business Objects Data Integrator
  • Job Execution of replication CDC

Using the Administrator Services

  • Management administrator services
  • Metadata reporting: impact / lineage analysis
  • Metadata reporting: auto documentation
  • Using the operational dashboard
  • Using data validation reports

Prerequisites
Knowledge of data warehousing and ETL concepts, experience with MySQL and SQL language, Experience using functions, elementary procedural programming, and flow-of-control statements such as If-Then-Else and While Loop statements, knowledge of Data Warehouse Architecture and Modeling fundamentals

Duration: 3 days

Tuition: US $2,250 per student (three student minimum required to confirm session)


Magnitude Software specifies the dates of public classes. Private and on site classes will be scheduled by mutual agreement. Magnitude Software may cancel or defer any scheduled class on 10 working days notice. If Magnitude Software cancels a class for which you have prepaid, Magnitude Software will refund the price you paid to Magnitude Software. Magnitude Software will not be responsible for any loss incurred by you, e.g. travel expenses, as a result of Magnitude Software’s cancellation or deferral of a class.

request_a_call

© Copyright 2017-2018 Magnitude Software, Inc. All rights reserved. Magnitude Software is a registered trademark of Magnitude Software, Inc. in the U.S. and other countries. All other product and company names mentioned herein are used for identification purposes only and may be trademarks/registered trademarks of their respective owners