The development phase consists of standard tasks for specifying source and target databases and advanced tasks for further customizing the data transformation logic.
The following steps outline the basic procedure for developing an ETL process using Sun Data Integrator.
Create a virtual database.
Add the external tables containing the content to aggregate.
Create a new Data Mashup project in NetBeans.
Using the wizard, create the Data Mashup file.
Using the Data Mashup Editor, specify join and filter conditions.
Add the Data Mashup service to a composite application.
Build and deploy the composite application.
Test the deployment.
You can perform additional tasks during the development phase to customize your Data Mashup application further.
Data Transformation – Add operators to join and filter conditions to create advanced SQL queries.
Business Process Integration - Call a Data Mashup process from a BPEL business process, web service, Java client, or other application.
Multiple-Channel Deployment - Weave Data Mashup with XSLT using the CASA Editor to create multiple assemblies with different style sheets to support multiple distribution channels.
The Data Mashup Wizard takes you through the steps to set up an Enterprise Data Mashup and, based on the information you specify, creates a collaboration that defines the configuration of the process.
Once you define the Data Mashup framework using the wizard, you can further customize the configuration Collaboration Editor.