test

Sun Master Data Management Suite Primer

Standard Development Tasks

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

  1. Connect to the source and target databases from the Services window in NetBeans.

  2. Create a new Data Integrator Module project in NetBeans.

  3. Using the Data Integrator Wizard, specify the source database and tables and the target database and tables.

  4. Using either the Data Integrator Wizard or the ETL Collaboration Editor, specify join conditions and map the source fields or columns to the target fields or columns.

  5. Specify the execution strategy.

  6. Add the ETL service to a composite application.

  7. Build and deploy the composite application.