The Data Integrator Editor allows you to configure your ETL processes by modifying the source code or by using a graphical editor. It has many predefined data transformation, validation, and cleansing functions, and also allows you to add user-defined functions. This editor is a design-time component that you use to design the ETL collaborations and to create the artifacts that can be deployed as a Data Integrator Service Engine.
The Data Integrator editor contains various modules and functions embedded in it, including the following:
Model (SQL Framework)
View (JGo Graph Library view)
Controller
Wizards (New ETL File wizard and Mashup wizard)
Database Evaluators
Code Generator