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.

DataMapper 2008 Professional Edition Released.

mike — Sat, 19 Apr 2008 18:19:04 GMT

We are pleased to announce the production release of Astera DataMapper 2008 Professional Edition. DataMapper 2008 has been developed in close collaboration with a number of data conversion professionals from business and IT. The product has been in beta testing with select customers and the feedback regarding functionality, ease of use, and price has been very positive. Many customers tell us that the product offers substantially more functionality and usability than products costing several times more.

From a performance point of view, DataMapper 2008 is comparable to high-end ETL products. Designed from the ground up as a multi-threaded parallel processing engine, DataMapper delivers performance and scalability unmatched in its category.

The Pro Edition is intended both for business users and developers. The user interface is designed for business users and building data transfers does not require programming expertise. Smart file parsers accurately detect data types and lengths in a large majority of cases while powerful data transformation features enable you to easily create fairly complex transfers. Database writing engine provides control over database writes including updating existing records, and transaction management.

For developers, Astera DataMapper 2008 Pro brings APIs that enable you to integrate DataMapper into your applications. Moreover, you can easily add custom functions to Astera Rules Language. These custom functions can even call outside components and services. In many cases, customers have built custom libraries to implement frequently used transformations.

We are committed to continually evolving DataMapper and are working on some exciting new features for upcoming releases. Your feedback helps drives our feature selection. Please let us know the features you would like to see in future releases and, who knows, you may see them sooner than you think.
Here is a snapshot of key DataMapper features. Look here for more information. A detailed feature matrix is available here.

Source types include files, databases and SQL Query. Destination types include files and databases
Build maps using the interactive drag-and-drop mapping and AutoMap
features. Use lookups and expressions for more involved mappings.
Data Preview feature helps you validate and fix mappings before
running transfer while Data Profiling feature provides an aggregate
overview of your data
Data Migration Batch helps you define multi-table data transfers between databases
Multi-threaded data transfer engine supports high-speed data movement between all supported databases and file formats
Schedule transfer for one-time, hourly, daily, weekly, or monthly runs
Supports SQL Server, Oracle, DB2, Sybase, MySQL, and Access databases.
File types include delimited, fixed length, and Excel. Capability to process files in over a hundred languages and encodings
Transfer Batch helps you create a collection of transfers and run them sequentially
A full-featured query tool provides a consistent interface across all the supported databases
Query editor with syntax highlighting, unlimited undo/redo, and printing capability
Control over database writes including updating existing records,
conditional updates, transaction management, and system generated key
options.

Astera Company Blog

Centerprise Data Integrator 3.0 Is Released

Key Features

Server

Programming APIs

DataMapper 2008 Professional Edition Released.