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.
Connect to the source and target databases from the Services window in NetBeans.
Create a new Data Integrator Module project in NetBeans.
Using the Data Integrator Wizard, specify the source database and tables and the target database and tables.
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.
Specify the execution strategy.
Add the ETL service to a composite application.
Build and deploy the composite application.
You can perform additional tasks during the development phase to customize your ETL application further.
Customized Data Transformation – Use data transformation operators to define advanced standardization and cleansing rules for the source data.
Master Index Staging – Create a staging database populated with the initial bulk data that will be loaded into a new master index application. The staging database is used by the master index Data Cleanser and Data Profiler prior to loading the data.
ETL Process Integration - Call an ETL collaboration from a BPEL business process, web service, Java client, or other application.
Extraction Scheduling - Configure a time or event that triggers a data extraction from the data source. You can extract data in batch mode or continuously based on database triggers.
Parallel Processing - Configure the ETL process to run on multiple threads for better performance and faster execution.
The Data Integrator Wizard takes you through each step of the ETL setup process and, based on the information you specify, creates a collaboration that defines the configuration of the ETL process.
Once you define the data integration framework using the wizard, you use the ETL Collaboration Editor to further customize its configuration.