Data Transformation Engine Introduction to the Design Studio

Chapter 1 - Design Studio Overview Integration Broker Products

Introduction to the Design Studio

Client Components of the Design Studio

The client components of the Design Studio include the Type Designer, Map

Designer, Database Interface Designer, and Integration Flow Designer. These

designers operate in a Windows environment and provide the graphical interface

for managing the integration of applications and business processes.

♦ Integration Flow Designer — The modeling component used to define and

manage business processes. Use the Integration Flow Designer to define

interactions among maps and systems of maps, to validate the logical

consistency of workflows, and to prepare systems to run.

♦ Type Designer — The data object modeling component used to create and

manage type trees that define properties for data structures, define

containment of data, create data validation rules, and more. The Type Designer

includes an importer tool for automatically generating Mercator type trees for

data that is described in various formats and application structures, such as

XML, COBOL, SAP R/3, Tuxedo, and PeopleSoft. The type trees are maintained

in the Type Designer, although type trees can also be created using the Type

Tree Maker, and the Database Interface Designer.

♦ Map Designer — The modeling component used to formulate transformation

and business rules. The Map Designer uses definitions of data objects created

in the Type Designer as inputs and outputs. The Map Designer provides

functionality to specify rules for transforming and routing data. Maps are

analyzed, compiled, and tested using the Map Designer.

♦ Database Interface Designer — The modeling component used to import

metadata about queries, tables, and stored procedures for data stored in

relational databases. The Database Interface Designer identifies characteristics,

such as update keys and database triggers, of those objects to meet mapping

and execution requirements.

The Design Studio also includes the Type Tree Maker, a scripting tool that

automates the capture of metadata from machine-processible sources to create

graphical metadata for use in Mercator products. The use of the Type Tree Maker

is not discussed in this document; refer to the Type Tree Maker Reference Guide

for more information.