Centerprise Integration Studio
Designed for business users, Centerprise Integration Studio is a powerful data transformation and tape cracking tool that
facilitates fast data import, mapping, cleansing and export.
With its support of various databases and file types, Centerprise makes it easy to filter and validate data, create mapping
expressions and lookups and design transformation settings that can be saved and reused.
Centerprise features include:
- Data transfer wizards that quickly guide you through common data transformation tasks;
- Automatic and user controlled mapping,
including direct, expression-based and lookups;
- Rule-based data validation, which helps ensure data quality
- Dealing with file format inconsistencies,
including out-of-sequence or missing headers, extra columns, or incorrect headers;
- Powerful, yet easy-to-use rules language
for defining validations, filters, transformation and other conditions;
- Extensive feature set for updating existing database records, including conditional updates and
data synchronization;
- Data export and a "point-and-click"
query capability that makes extracting data simple without writing complicated SQL queries;
- Detail and aggregate level data profiling
that supports data quality measurement and data cleansing;
- Support of file types including delimited, fixed-length and Microsoft Excel, and
databases such as Microsoft SQL Server, Oracle, DB2, Sybase and Microsoft Access
- The ability to save and reuse transfer settings for future transformation tasks;
- Scalability of the parallel processing transformation engine allowing it to efficiently handle very large data volumes.
- 100% managed .Net code which ensures higher degree of reliability, exception handling, and performance, and .Net APIs which provide programmatic access to all features of the product
