Data Transformation Engine Intelligent Business Integration Reference Guide

Chapter 1 - Introduction Design Environment – Design Studio

Intelligent Business Integration Reference Guide

The Database Interface Designer makes it possible to:

♦ Specify databases, user IDs, passwords to connect to as sources and

destinations

♦ Define query statements

♦ Generate type trees automatically for queries, stored procedure input and

output parameters or tables

♦ Define specific columns to update for update transactions

♦ Define tables for which inserts, updates, and deletions will trigger maps via the

Mercator Event Server

Note Refer to the Database Interface Designer Reference Guide for more information.