SAP Business objects DATA INTEGRATOR Release Summary

Data Integrator Release Summary

Data Integrator 11.5.2.0

for Windows and UNIX

If you find any problems with this documentation, please report them to Business Objects S.A. in writing at documentation@businessobjects.com.

Trademarks

Third-party contributors

Patents

Date

Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners.

Business Objects products in this release may contain redistributions of software licensed from third-party contributors. Some of these individual components may also be available under alternative licenses. A partial listing of third-party contributors that have requested or permitted acknowledgments, as well as required notices, can be found at:

http://www.businessobjects.com/thirdparty

Business Objects owns the following U.S. patents, which may cover products that are offered and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and 6,289,352.

July 28, 2006

Data Integrator Release Summary

Contents

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Data Integrator information resources . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

New to Data Integrator version 11.5.2.0 . . . . . . . . . . . . . . . . . . . . . . . . 6

New to Data Integrator version 11.5.1.5 . . . . . . . . . . . . . . . . . . . . . . . . 6

New to Data Integrator version 11.5.1.0 . . . . . . . . . . . . . . . . . . . . . . . . 7

New to Data Integrator version 11.5.0.0 . . . . . . . . . . . . . . . . . . . . . . . . 7

Trusted information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

Case preservation for database object names . . . . . . . . . . . . . . . . . . . 8

Data Quality dashboard metadata reports . . . . . . . . . . . . . . . . . . . . . . . 8

Data profiler redesign . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

End-to-end metadata viewing from Desktop Intelligence documents . 10

Validation transform enhancements . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Variable-length character processing enhancements . . . . . . . . . . . . . 11

Productivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

COBOL copybook file format enhancements . . . . . . . . . . . . . . . . . . . . 12

Function enhancement (rand_ext) . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

Metadata reports redesign . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

Impact and Lineage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

Operational Dashboards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

Data Quality dashboards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

Auto Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

PeopleSoft tree extraction enhancement . . . . . . . . . . . . . . . . . . . . . . . 13

Query transform enhancements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

Tutorial upgrade . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

Web Services option enhancement . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

Data Integrator Release Summary 3

Contents

Windows clustering failover support . . . . . . . . . . . . . . . . . . . . . . . . . . .15

Scalability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15

Changed-data capture (CDC) enhancement . . . . . . . . . . . . . . . . . . . .15

Netezza bulk loading . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16

Oracle Real Application Cluster (RAC) support . . . . . . . . . . . . . . . . . .16

Performance improvements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17

Teradata named pipes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17

Teradata MultiLoad, FastLoad, and TPump . . . . . . . . . . . . . . . . . . . . .17

XML_Pipeline transform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17

4 Data Integrator Release Summary

Introduction

Welcome to BusinessObjects Data Integrator XI Release 2 version 11.5.2.0. This document summarizes the new features for Data Integrator versions 1 1.5.0.0 through 11.5.2.0.

For important information about this product release including installation notes, resolved issues, and known issues, see the Data Integrator Release

Notes.

Business Objects has also recently released two new products that complement Data Integrator and offer more Enterprise Information Management solutions:

• Composer

• Metadata Manager

See the Business Objects web site or contact a Business Objects sales representative for more information.

Data Integrator information resources

Consult the Data Integrator Getting Started Guide for:

• An overview of Data Integrator products and architecture

• Data Integrator installation and configuration information

• A list of product documentation and a suggested reading path

After you install Data Integrator (with associated documentation), you can view the technical documentation from several locations. To view documentation in PDF format:

• Select Start > Programs > Data Integrator version > Data Integrator

Documentation and select:

• Release Notes—Opens the Release Notes PDF, which includes

known and fixed bugs, migration considerations, and last-minute documentation corrections

• Release Summary—Opens this document, which describes the

latest Data Integrator features

• Technical Manuals—Opens a “master” PDF document that has

been compiled so you can search across the Data Integrator documentation suite

• Tutorial—Opens the Data Integrator Tutorial PDF, which you can

use for basic stand-alone training purposes

• Select one of the following from the Designer’s Help menu:

Introduction

Data Integrator Release Summary 5

Overview

• Release Notes

• Release Summary

• Technical Manuals

• Tutorial

Other links from the Designer’s Help menu include:

• DIZone—Opens a browser window to the DI Zone, an online resource for

the Data Integrator user community)

• Knowledge Base—Opens a browser window to Business Objects’

Technical Support Knowledge Exchange forum (access requires registration)

• Select Help from the Data Integrator Administrator to open Technical

Manuals.

To obtain additional information that might have become available following the release of this document, or for documentation for previous releases (including Release Summaries and Release Notes), visit the Business Objects documentation Web site at http://support.businessobjects.com/

documentation/.

The features presented in Data Integrator XI Release 2 accommodate several key areas:

• Trusted information

• Productivity

• Scalability

Each new feature (or product) supports a key area. Find new feature and product summary information under the associated key area heading.

The following lists itemize new features by version, then alphabetically.

New to Data Integrator version 11.5.2.0

The following feature is new to Data Integrator version 11.5.2.0:

Teradata MultiLoad, FastLoad, and TPump

New to Data Integrator version 11.5.1.5

The following features are new to Data Integrator version 11.5.1.5:

6 Data Integrator Release Summary

+ 13 hidden pages