The following are the list of features for Sun Data Integrator:
Requires little database expertise to build high performing ETL processes.
Metadata auto discovery enables user to design ETL processes faster.
Takes advantage of database bulk, no-logging tuning where applicable for faster data warehouse loads.
Support for creating automatic joins based Primary Key and Foreign Key relationships, and creates code to ensure data integrity.
Takes advantage of database engine by pushing as much of the workload on to the target and source database.
Supports extensive non-relational data formats
Transforms, filters, and sorts at the source where appropriate.
Supports data cleansing operators to ensure data quality. Provides a dictionary driven system for complete parsing of names and addresses of individuals and organizations, products, and locations. Supports data normalization and de-normalization.
Converts data into a consistent, standardized form to enable loading to a conformed target databases.
Supports built–in data integrity checks.
Supports data type conversion, null value handling, and customized transformation.
Provides a robust error handler to ensure data quality and a comprehensive system for reporting and responding to all error events.
Supports change management functions or versioning.
Allows concurrent or parallel processing of multiple source data streams.
Supports full refresh and incremental extraction.
Is fully integrated with NetBeans to provide a complete development environment.
Supports Data Federation, enabling you to use SQL to define ETL processes.
Provides near real-time click-stream data warehousing (in conjunction with the JDBC Binding Component).
Supports Enterprise Resource Project and Customer Relation Manager data sources in conjunction with various components from Java CAPS.
Provide platform independence and scalability to enterprise data warehousing applications.
Allows you to define complex transformations using built-in transformation objects.
Allows you to schedule ETL sessions based on time or on the occurrence of a specified event (in conjunction with Java CAPS components).
Can participate as a partner in BPEL business processes. Sun Data Integrator exposes the ETL process as web service.
Can extract data from outside a firewall in conjunction with FTP and HTTP Connectors.
Provides reporting and analysis of transformations that failed or were rejected, and then allows you to resubmit them after correcting the data.
Provides extensive reporting of the results of ETL sessions, including automatic notification of significant failures of the process.