CENTERPRISE DATA INTEGRATOR
Centerprise Data Integrator brings a unique blend of power and ease of use to your data integration tasks. Whether you are processing incoming data files from your business partners or integrating disparate applications in the enterprise, Centerprise delivers the flexibility, reliability, and the performance you need.
KEY BENEFITS
-
Quickly develop and deploy integration jobs
-
Process large data volumes efficiently using the high performance parallel processing engine
-
Connect to a variety of data sources including popular databases, file formats, and XML
-
Detailed profile of transfer data including aggregate statistics and record level error information
-
Automate jobs to run hourly, daily, monthly, or on file drops
- Change Data Capture to reduce bandwith and speed up large transfer jobs
- Connectivity to Salesforce
Data Integrator Overview
Click to view a larger screenshot.
-
Perform data transformations using a drag-and-drop interface
-
Specify field-to-field, lookups, and expression transformations
-
Use pivot and unpivot transformations to work with repeating groups
-
One-click data preview and profile capability while
building transformations
Click to view a larger screenshot.
-
Define rules to perform validations on source or destination data.
-
Preview data quality results at individual record and aggregate level.
-
Data profiling provides aggregate view of data quality, and field level statistics
Click to view a larger screenshot.
- Connect with a large collection of
databases
-
Salesforce CRM Connectivity
-
Support for fixed length, delimited, and Excel files
-
XML source support including node traversal and aggregate functions
EASE OF USE
-
Designed to be used without any training. Does not require any programming background.
-
Familiar Microsoft Outlook style user interface that can be customized to suit your usage patterns
-
Intelligent defaults remember your preferences and minimize data entry
-
Automation pervasive throughout the product saves a great deal of manual work including layout building and mapping
PERFORMANCE
Click to view a larger screenshot.
-
Multithreaded parallel processing architecture delivers performance to handle large data volumes
-
High performance database writer. Native bulk insert and parallel database writes for selected databases
-
Performance increases proportionately with additional hardware provided. Doubling the number of CPUs, for instance, would roughly double the throughput
Click to view a larger screenshot.
-
APIs provide complete access to object model for transfers, batches, and data profiles
-
Extensive API samples are included in the product to help you jumpstart your development
-
All metadata are stored as open XML. This includes transfer mapping, batches, data models, transfer logs, and data profiles
-
Streamlined interfaces enable you to quickly develop plugins to perform a variety of functions.
-
APIs can be used to build transfers, modify existing transfers, run and schedule
transfers, as well as read transfer logs and data profiles
Click to view a larger screenshot.
- Automate transfer and batch executions using the full featured scheduler
-
Trigger specific transfers based on file drops
-
Send notification emails regarding transfer status
VISIBILITY
Click to view a larger screenshot.
-
Complete visibility into transfer jobs
- Detailed information about errors, warnings, and data profile available for all transfer jobs
-
Server monitoring provides exact status of each running or completed job
