We are pleased to announce the release of release Centerprise Data Integrator 3.0. This release represents a major upgrade with a completely redesigned user interface and hundreds of additional
features. APIs have been refined and extended. Server received major functionality, security, and performance
upgrade.

As with all of our products, usability, ease of deployment, and performance are major considerations and you will see that reflected throughout the product. 

We have added a number of exciting features including data models, visual query builder, pivot/unpivot mapping, and XML support. The integration server has received major focus in this release in the areas of scalability, usability, performance, and security.

The suite has been in beta testing with select customers for some time. We have posted a wealth of information about Centerprise 3.0 on the site. If you would like to test drive Centerprise, please contact sales@astera.com.

Key Features

Centerprise Data Integrator designed for superior usability and performance.  Every feature is carefully designed to make it easy to use while providing features that meet the demands of data transformation and integration professionals.

• Transform data between flat files, XML, and databases. Support for fixed length, delimited, Excel files with over a hundred encodings and languages.
• Extensive data mapping features including direct, lookup, and expression maps. Powerful and easy to use pivot and unpivot mapping.
• Full featured XML mapping capability including aggregate functions, node traversal, and schema generation.
• Database support includes SQL Server, Oracle, DB2, Sybase, MySQL, and Access. Support for other databases through a powerful ODBC implementation. These include QuickBooks, Postgres, Progress
  (OpenEdge), Informix, dBase, Paradox, Ingres, FoxPro, Teradata, MimerSQL, and Pervasive.
• Data quality and profiling capabilities enable you to define business rules for data quality checking and view field, rule, or record level data profile statistics.
• Instant preview capability to preview the result of data profile rules, mapping, or any other actions with a single click.
• High degree of automation reduces or eliminates manual work in many areas. This includes automatic determination of layout fields, data types, and lengths by reading the source files as well the functionality to define layouts using layout spec spreadsheets.
• Transfer jobs can comprise a single transfer or a batch of transfers.
• Quickly create batch to migrate data between databases.
• Reverse engineer existing database into a visual data model. Use the data model to view table structures, data, and easily build complex data exports.
• Query editor and database browser provide a consistent interface for editing, running queries and viewing database schema across all databases.

Server

Centerprise Server features a multithreaded engine that delivers very high performance. Its parallel processing architecture enables it to scale to take advantage of multicore and multiprocessor systems. Performance of Centerprise Integration Server scales approximately linearly to the processing power available.

• Server and Job monitoring enables you to view, monitor, and cancel jobs currently running on the server. You can also view detailed log of completed jobs including summary and detailed error information.
• Powerful scheduler gives you the ability to schedule jobs for hourly, daily, weekly, or monthly runs. You can also trigger jobs based on file drops to specified directories.
• Send notification email for server job events such as start, completion, or termination due to error.
• User and group level access control for the server. User permissions can include restrictions on job submission, cancellation, and viewing.
• Centerprise Suite is developed as a 100% managed .net application providing superior reliability and streamlined deployment.

Programming APIs

Centerprise provides a set of Microsoft.net APIs to create, run, and monitor data transformation and integration jobs. In essence, Developers using Centerprise.net have programmatic access to virtually all the features available in Centerprise Integration Studio and Centerprise Integration Server.

• Plugin Development. Centerprise provides a simple API to develop and integrate plugin for transfer jobs. These plugins are can be
  attached to transfers and perform a variety of functions.
• Custom Functions for Rules Engine. You can add custom function to rules engine that call outside components or services. These functions can then be used in rules expressions for validation, mapping, filtering, etc.
• Create, modify, and run transfer jobs using the framework. Centerprise APIs provide access to the entire object model of transfer objects enabling you to add the power and functionality of Centerprise to your applications.
• Interaction with Server. Using APIs, you can submit, schedule, cancel or monitor jobs as well as administer server.
• Create, modify, and run transfer jobs using the framework. Centerprise APIs provide access to the entire object model of transfer objects enabling you to add the power and functionality of Centerprise to your applications.
• Using APIs, submit, schedule, cancel or monitor jobs as well as administer server.