Centerprise Data Integrator 3.0 Is Released

ibrahim — Wed, 03 Sep 2008 16:33:52 GMT

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.

Astera Company Blog

Centerprise Data Integrator 3.0 Is Released

Key Features

Server

Programming APIs