Standard Development Tasks

The following steps outline the basic procedure for developing an ETL process using Sun Data Integrator.

1. Create a virtual database.

2. Add the external tables containing the content to aggregate.

3. Create a new Data Mashup project in NetBeans.

4. Using the wizard, create the Data Mashup file.

5. Using the Data Mashup Editor, specify join and filter conditions.

6. Add the Data Mashup service to a composite application.

7. Build and deploy the composite application.

8. Test the deployment.