Sun Data Integrator Features

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.