With a high degree of automation coupled with intelligent defaults, Centerprise Data Integrator quickly evolves into a smart and perceptive partner for your data transformation tasks. The application also comes packed with a feature-rich query tool that works consistently across all supported databases.
Some of the distinguishing features of Centerprise Data Integrator include:
· Interactive drag-and-drop data mapping
· Record preview and field level data preview during mapping
· Map data using direct field-to-field, list lookup, database table lookup, and expression mappings
· A Microsoft Excel-style formula language that includes a large library of built-in functions to handle complex mapping situations
· Support for Microsoft SQL Server, Oracle, MySQL, IBM DB2, Sybase, Microsoft Access databases, as well as Salesforce service which Centerprise treats as a database connection
· Transferring data between tree layouts, such as XML files
· High-speed data transfer engine, which supports rapid data movement between all supported databases and file formats
· Easy-to-save and reuse data maps
· Delimited, fixed length, Microsoft Excel and XML files processed in over a hundred languages and encodings
· A full-featured query tool providing a consistent interface across all the supported databases
· Query editor with syntax highlighting, unlimited undo/redo, and printing capability