SAP BusinessObjects: Data Integrator XIr2

Overview

• Describe BusinessObjects Data Integrator architecture
• Describe components, management tools, and the development process
• Create a secure central repository
• Execute, schedule, and monitor batch jobs
• Create a project, job, work flow, and data flow

Data Integrator enables the implementation of ETL (Extract, Transform, and Load) projects from disparate data sources to deliver more timely and accurate data.
In this four day course delegates will learn about batch data transformation jobs, techniques for capturing changes in data, handling errors, multi-user environment tasks, administering server and migration basics.

Prerequisites

This course is designed for individuals responsible for implementing ETL projects, administering and managing projects that involve Data Integrator. Delegates attending this course should have
• Knowledge of data warehousing concepts, ETL concepts, SQL language
• Experience with Microsoft SQL Server
• Knowledge of normal functions, elementary procedural programming and flow-of-control statements. For example: If, Else, While, Loop

Course Outline.

Data Warehousing Concepts
• Describe dimensional modeling

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

Defining Source and Target metadata
• Create a database datastore and import metadata
• Create a new file format and handle errors in file formats

Validating, Tracing, and Debugging Jobs
• Use descriptions and annotations
• Validate and trace jobs
• Use View Data and the Interactive Debugger

Creating a Batch Job
• Create a project, job, work flow, and data flow
• Use the Query transform in a data flow
• Use template tables

Using Built-in Transforms and Nested Data
• Use the case, merge, and validation transforms
• Import metadata from XML
• Use the XML Pipeline in a data flow

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

Managing Metadata
• Import and export metadata
• Use Metadata Reports
• Using Data Integrator Scripting Language and Variables
• Explain differences between global and local variables
• Create global variables and custom functions
• Use strings and variables in Data Integrator scripting language

Capturing Changes in Data
• Use Changed Data Capture (CDC) with time-stamped sources
• Create an initial and delta load job
• Use history preserving transforms

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

Using the Administrator
• Add a repository and user roles
• Set the job status interval and
• log retention period
• Execute, schedule, and monitor batch jobs
• Understand architecture, load balance index, and job execution in server groups

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

QA reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.