Data Transformation Engine Intelligent Business Integration Reference Guide

Chapter 1 - Introduction Design Environment – Design Studio

Intelligent Business Integration Reference Guide

Type trees can be created in a number of ways:

♦ The Type Designer includes an importer tool for automatically generating type

trees for data described in XML, COBOL, SAP R/3, Tuxedo, and PeopleSoft

formats or application data structures.

♦ The Type Designer enables creation of type trees “from scratch” as well as

modification and customization of existing type trees; including those

generated by importers, DTD, or provided by Mercator. For example, the EDI

type trees provided with the Mercator Integration Broker can be customized to

reflect a trading partner agreement.

♦ Mercator provides type trees for industry-standard formats such as S.W.I.F.T.,

FIX, X12 EDI, EDIFACT, ACORD, Tradacoms, and Odette.

♦ The Database Interface Designer provides a feature that establishes a session

with any relational database management system and automatically imports

definitions from the database catalogs.

Importers define a transformation between well-known metadata formats such as:

! Extensible Markup Language (XML) document type definitions (DTDs)

! Extensible Markup Language (XML) schemas

! Web Services Description Language (WSDL) web service definitions

! OAG Business Object Documents (BODs)

! COM type libraries

! COBOL Copybooks

! Java classes

! Interface definitions for packaged applications such as SAP, PeopleSoft, and

Siebel.