Centerprise Integration Studio

Database features

Data Updates

Centerprise features several options to update records in existing database tables. These include:

• Actions to execute based on whether a record exists in the database
• Conditional updates, where you can specify rule-based criteria for the updates to occur.

Data Exports

An intuitive visual query builder allows for building sophisticated queries using point and click. You can define complex data filters using Centerprise query builder. Centerprise generates SQL statements that you can preview before exporting data.

The ability to generate and execute lengthy SQL statements without extensive knowledge of SQL makes this feature ideal for a business user.

Data Synchronization

Centerprise data synchronization is designed for situations where an existing database is updated periodically with a feed from another source. In many instances, only a small subset of data has changed since the last update. For these situations, data synchronization can provide enormous performance boost by writing to database only the rows that are different between the source and destination and skipping the rest.

Connectivity

Centerprise 2.0 supports many popular databases including:

• Microsoft SQL Server
• Oracle
• DB2
• Sybase
• Microsoft Access

For a complete list of database platforms and versions, click here.

Back to overview.