Data Integrator XI R1, R2

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.

The course also shows delegates how to use tools to audit, profile data, and manage metadata to assist in the implementation of an ETL project. Smaller activities in this course focus on the tools and features discussed in each lesson and enable the delegate to create dimensions and a fact table. By being able to create efficient ETL projects, end users can use the transformed data to help improve operational and supply chain efficiencies, enhance customer relationships, create new revenue opportunities, and optimise return on investment from enterprise applications.

Who should attend?

This course is designed for individuals responsible for implementing ETL projects (batch-mode), administering and managing projects that involve Data Integrator.

Delegates will be able to

• Describe SAP 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, workflow and data flow.

Prerequisites

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.

Additional Education

If you want to increase your skill level and knowledge, the following course is recommended,

• Data Warehousing - Data Warehouse Design

Topics covered

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 documents
• 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