SAP Business objects DATA INTEGRATOR Release Notes

Data Integrator Release Notes

December 4, 2006

Data Integrator 11.7.0.0

for Windows

Patents

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.

Trademarks

Third-party contributors

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

Data Integrator Release Notes

Introduction

BusinessObjects Data Integrator XI Release 2 (XI R2) Accelerated version

11.7.0.0 is a functional release. For an overview of new features included in this release, see the Data Integrator Release Summary.

This document contains important information about this product release including installation notes, details regarding the latest resolved issues as well as known issues with this release, and important information for existing customers.

Read this entire document before installing your Business Objects software.

Note: To obtain the latest version of Data Integrator documentation, including

the most up-to-date version of these Release Notes, go to the Customer Support documentation download site (http://support.businessobjects.com/

documentation/) and follow the appropriate product guide links.

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 St art > Programs > BusinessObject s Dat a Integrator version >

Data Integrator Documentation and select:

• Data Integrator Release Notes—Opens this document, which

includes known and fixed bugs, migration considerations, and lastminute documentation corrections

• Data Integrator Release Summary—Opens the Release Summary

PDF, which describes the latest Data Integrator features

• Data Integrator Technical Manuals—Opens a “master” PDF

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

• Data Integrator Core 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:

• Release Notes

Introduction

Data Integrator Release Not es 1

Compatibility and limitations update

• Release Summary

• Technical Manuals

• Tutorial

Other links from the Designer’s Help menu include:

• Data Integrator Community—Opens a browser window to the Diamond,

the Business Objects developer community web site

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

Online Customer Support web site

You can also open the Data Integrator documentation from links on the new Start Page that opens automatically when you open the Designer . To open the Designer, choose Start > Programs > BusinessObjects Data Integrator version > Data Integrator Designer.

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 Customer Support Web site at http://support.businessobjects.com/

documentation/.

In this document

These release notes contain the following sections:

• Compatibility and limitations update

• Migration considerations

• Adapter interfaces

• Resolved issues

• Known issues

• Documentation updates

• Business Objects information resources

• Copyright information

Compatibility and limitations update

This section describes changes in compatibility between Data Integrator and other applications. It also summarizes limitations associated with this version of Data Integrator.

For the latest and detailed compatibility , availability, and limitation information, see the Supported Platforms documentation on the Business Objects Customer Support Web site at:

2 Data Integrator Release Notes

http://support.businessobjects.com/documentation

Compatibility update

This section describes:

• Supported products

• Unsupported products

For complete compatibility and availability details, see the Business Objects Supported Platforms documentation on the Business Objects Customer Support Web site:

http://support.businessobjects.com/documentation

Supported products

• Data Integrator now supports multibyte Metadata for table names,

column names, file names, and file paths. The following table lists which sources support multibyte and single-byte Metadata and which support single-byte only:

Compatibility and limitations update

Multibyte and single-byte Metadata supported*

Siebel DB2 Informix ODBC (includes MySQL) Oracle Microsoft SQL Server Sybase ASE Sybase IQ Teradata XML BusinessObjects Enterprise

* Support for multibyte Metadata is dependent on comparable support in the applications, databases, and technologies with which Data Integrator interoperates.

Single-byte Metadata supported

Oracle Applications SAP R/3 SAP BW Server Attunity connector for mainframe databases Netezza JD Edwards PeopleTools Data Quality

• Support is now available for the following platforms and configurations:

• DataDirect ODBC Driver version 5.2.

Data Integrator Release Not es 3

Compatibility and limitations update

• SAP ECC 6.0 via ABAP, BAPI and IDOC

Please note that this support is available on Data Integrator 1 1.7 only and not Rapid Marts. Check your Rapid Marts documentation to get the latest support information for that product.

• Data Quality using:

• International ACE version 11.5.1

• DataRight IQ version 11.5.1

• Excel version 97 and above as a source

• Impact analysis will interoperate with:

• BusinessObjects universes 6.5.1, XI, XI R2, and XI R2 SP1

• Web Intelligence documents versions 6.5.1, XI, XI R2, and XI R2

SP1

• Desktop Intelligence documents versions 6.5.1, XI R2, and XI R2

SP1

• Business Views XI, XI R2, and XI R2 SP1

• The scheduling functionality is supported with BusinessObjects version

XI R2 or later compatible versions of the BusinessObjects Enterprise scheduler

• The following Universe Builder versions are compatible with Data

Integrator 11.7:

• The stand-alone Universe Builder version 11.5 bundled with Data

Integrator 11.7.0.0. This version of Universe Builder will interoperate with Business Objects versions 6.5.1, XI, and XI R2. Find Universe Builder documentation in the “Building Universes from Data Integrator Metadata Sources” chapter of the Universe Designer Guide, which you can download from the Business Objects Customer Support Web site at http://support.businessobjects.com/

documentation/. Select BusinessObjects Enterprise as the product

and Universe Designer Guide as the document.

• The Universe Builder version bundled with BusinessObjects

Enterprise XI R2, XI R2 SP1 (see the required BusinessObjects Enterprise CHF-13 patch information in the Resolved issues section of this document for ADAPT00534412)

• ODBC to generic database support has been validated with the following

database servers and ODBC drivers. For complete compatibility details, see the Business Objects Supported Platforms documentation on the Business Objects Customer Support Web site: http://

support.businessobjects.com/documentation/

• Microsoft SQL Server 2000 via DataDirect Connect for ODBC 5.2.

4 Data Integrator Release Notes

Compatibility and limitations update

• MySQL version 5.0 via ODBC driver version 3.51.12 on Windows

Note: Driver version 3.51.12 is required in the multibyte

environment.

• Red Brick version 6.3 via ODBC driver version IBM 6.3

• SQLAnywhere version 9.0.1 via ODBC driver version Adaptive

Server Anywhere 9.0

• Sybase IQ version 12.6 requires ESD 4.

• Log-based changed-data capture (CDC) works with the following

database versions

• Oracle version 9.2 and above compatible versions for synchronous

CDC and Oracle version 10G and above compatible version for asynchronous CDC

Note: Changed-data capture for Oracle 10G R2 does not support

multibyte table and column names due to a limitation in Oracle.

• Microsoft SQL Server 2000 and 2005

• IBM DB2 UDB for Windows version 8.2 using DB2 Information

Integrator for Replication Edition version 8.2 (DB2 II Replication) and IBM WebSphere Message Queue version 5.3

• IBM DB2 UDB for z/OS using DB2 Information Integrator Event

Publisher for DB2 UDB for z/OS and IBM WebSphere Message Queue version 5.3.1

• IBM IMS/DB using DB2 Information Integrator Classic Event Publisher

for IMS and IBM WebSphere Message Queue version 5.3.1

• IBM VSAM under CICS using DB2 Information Integrator Classic

Event Publisher for VSAM and IBM WebSphere Message Queue version 5.3.1

• Attunity for mainframe sources using Attunity Connect version 4.6.1

• NCR Teradata V2R6 with TTU 8.0 and NCR Teradata ODBC 3.0.4 and

V2R6.1 with TTU 8.1 and NCR Teradata ODBC 03.05.00 This support requires the following TTU patches:

• On Windows platforms:

• cliv2.04.08.00.01.exe

• tbld5000.05.00.00.01.exe

• psel5000.05.00.00.01.exe

• pdtc5000.05.00.00.01.exe

• npaxsmod.01.03.01.00.exe

• npaxsmod.01.03.00.02.exe

Data Integrator Release Not es 5

Compatibility and limitations update

• npaxsmod.01.03.00.01.exe

NCR Teradata V2R5 and V2R6 continue to be supported. Supported versions of TTU client include:

Teradata server version Client version

V2R6.1 TTU 8.1 V2R6 TTU 8.0 V2R5.1 TTU 7.1 V2R5 TTU 7.0

With Teradata V2R6, the named pipes mechanism for Teradata bulk loader is now supported.

Note: Teradata does not recommend using Teradata Parallel

Transporter in TTU 7.0 and 7.1.

• Data Integrator uses Apache Axis version 1.1 for its Web Services

support. Axis version 1.1 provides support for WSDL version 1.1 and SOAP version 1.1 with the exception of the Axis servlet engine.

• Data Integrator connectivity to Informix servers is now only supported via

the native Informix ODBC driver. Version 2.90 or higher compatible version of the Informix client SDK is required.

Unsupported products

• DataDirect ODBC Driver version 5.1

• Firstlogic Data Cleansing products including:

• International ACE versions 7.25c, 7.50c, 7.60 or 7.70

• DataRight IQ versions 7.10c, 7.50c, 7.60 and 7.70

• IBM Connector mainframe

• Informix as a repository

• Context-sensitive Help for Data Integrator

• Data Mart Accelerator for Crystal Reports is no longer supported;

however, it is still available on the Business Objects developer community Web site at http://diamond.businessobjects.com/EIM/

DataIntegrator.

Limitations update

These limitations apply to Data Integrator version 11.7.0.0:

6 Data Integrator Release Notes

Compatibility and limitations update

• Files read by an adapter must be encoded in either UTF-8 or the default

encoding of the default locale of the JVM running the adapter.

• All Data Integrator features are available when you use an Attunity

Connector datastore except:

• Bulk loading

• Imported functions (imports Metadata for tables only)

• Template tables (creating tables)

• The datetime data type supports up to 2 sub-seconds only

• Data Integrator cannot load timestamp data into a timestamp column

in a table because Attunity truncates varchar data to 8 characters, which is not enough to correctly represent a timestamp value.

• The Adapter SDK no longer supports Native SQL or Partial SQL.

• Unsupported data type:

• Unsupported data type is only implemented for SQL Server, Oracle,

T eradat a, ODBC, DB2, Informix and Sybase ASE, Sybase IQ, Oracle Applications, PeopleSoft, and Siebel.

• Data Integrator can read, load, and invoke stored procedures

involving unknown data types for SQL Server, Oracle, Teradata, ODBC, DB2, Informix, Sybase ASE, and Sybase IQ assuming these database servers can convert from VARCHAR to the native (unknown) data type and from the native (unknown) data type to VARCHAR.

• Data Integrator might have a problem loading VARCHAR to a

physical CLOB column (for example, bulk loading or auto-correct load could fail).

Note: Use the VARCHAR column in the physical schema for loading.

• Unsupported data type is not supported in the SQL transform.

• PeopleSoft 8 support is implemented for Oracle only.

Data Integrator jobs that ran against previous versions of PeopleSoft are not guaranteed to work with PeopleSoft 8. You must update the jobs to reflect Metadata or schema differences between PeopleSoft 8 and previous versions.

• Stored procedure support is implemented for DB2, Oracle, MS SQL

Server, Sybase ASE, Sybase IQ, and ODBC only.

• On Teradata, the named pipe implementation for Teradata Parallel

Transporter is supported with Teradata Tools and Utilities version 8 or later compatible version. Teradata Tools and Utilities version 7.0 and 7.1 are not supported with named pipes.

Data Integrator Release Not es 7

Compatibility and limitations update

• Bulk loading data to DB2 databases running on AS/400 or MVS systems

is not supported.

• Data Integrator Administrator can be used on Microsoft Internet Explorer

version 6.0 SP1 or 6.0 SP2. Earlier browser versions may not support all of the Administrator functionality.

• Data Integrator’s View Data feature is not supported for SAP R/3 IDocs.

For SAP R/3 and PeopleSoft, the Table Profile tab and Column Profile tab options are not supported for hierarchies.

• Support for the Data Profiler is provided for sources as follows:

Supported Not supported

Attunity Connector for mainframe databases

DB2 Flat file Informix Netezza ODBC (includes MySQL) Oracle Oracle Applications PeopleSoft SAP R/3 Siebel SQL Server Sybase ASE Sybase IQ Teradata

COBOL copybooks Excel IDOC JDE Memory Datastore SAP BW XML

8 Data Integrator Release Notes

Compatibility and limitations update

• Support for the LOOKUP_EXT function is provided for sources as

follows:

Supported Not supported

DB2 Flat file Informix JDE Memory Datastore Netezza ODBC Oracle Oracle Applications PeopleSoft Siebel SQL Server Sybase ASE Sybase IQ Teradata

COBOL copybook Excel IDOC SAP BW SAP R/3 XML

• DB2 Java Library limitations

All Web applications in the Management Console will not work with a DB2 repository under any of the following conditions:

• db2java library is incompatible with DB2 client. For example, DB2

Client is version 8.1 and db2java library is version 8.2, or

• db2java library is not generated for JDBC 2 driver, or

• the java class path variable is not properly set to the corresponding

java library, or

• the DB2 JDBC shared library (e.g. libdb2jdbc.so on AIX) is not

compatible with the Java JDBC 2 driver

Under these conditions, you might see the following behavior:

• The Administrator stops working or crashes after you configure the

DB2 repository. Find any error and warning messages related to the DB2 repository configuration in the log file.

• When testing your DB2 connection from the Administrator, the

following errors appear in the Administrator log:

• BODI-3016409: fail to connect to repository.

• BODI-3013014: didn't load DB2 database driver.

Data Integrator Release Not es 9

+ 25 hidden pages