Data Transformation Engine Introduction to the Design Studio

Chapter 1 - Design Studio Overview Theory of Operation
Introduction to the Design Studio
10
Theory of Operation
♦ Use the Integration Flow Designer to design systems of maps to model your
data transformation business processes.
♦ Use the Map Designer to develop these maps.
! The Map Designer uses the Command Server to run maps.
♦ Use the Type Designer to define your source and target data structures.
♦ Use the Database Interface Designer to import metadata and identify
characteristics of those objects to meet mapping and execution requirements
such as update keys and database triggers.
♦ Finally, use the Integration Flow Designer to create your system definition,
map overrides, and server deployment
1. Analyze the data
3. Specify mapping
r
r
u
u
l
l
e
e
s
s
Map Designer
4. Execute map
and verif
y
results
Command Server
2. Define the data
Type Designer / Importers
Database Interface Designer
Use these Design Studio client applications as design-time products to model,
develop, and test your data transformation and application integration maps and
systems. Integrate both content transformation and content-based routing
through the Design Studio graphical interface.