|
|
This Page is a Features Analysis of some commercial Data Migration Tools.
All of these Tools can perform Extraction, Validation, Conversion and Loading into a Target Data Destination,(usually a Database). The Analysis shown here is in the context of the Data Architecture described elsewhere on this Site. The Analysis is intended to help identify products which meet the requirements of the Architecture.
Here's a short list of some recommended Data Migration Tools, and
SQL Porter looks good. Real-Time means that changes to Data Sources can be automatically monitored
and rippled through to the Target Data Destinations.
| ||||||
VENDOR | Informatica | DataJunction | ETI Corporation | Metagon | Sagent | seeBeyond |
PRODUCT | Informatica | Data Junction | ETI*Extractor | DQ Broker | Sagent | e*Gate |
Price Range | $2,895 - $9,145 (single user) |
$25,000 - $250,000 | $250,000 | |||
Approach | All Products Use a Data Dictionary to store Mappings defined in a Transformation Definition Language. | |||||
Comment | Excellent All-rounder | Consistent Award Winner | Industrial-Strength | A Serious Competitor | Well-Established | |
Data Dictionary | Yes | Yes | Yes | Yes | ||
Job Scheduler | Yes | Yes | ||||
Open Info. Model (OIM)
from MetaData Coalition |
Yes | Yes | ||||
Publish & Subscribe | Yes | |||||
Real-Time
Within 5 seconds acceptable |
Yes | No ? | Yes ? | Yes | Yes | |
Replication | No ? | Yes ? | Yes | |||
UML | ||||||
Validation of Source Data | Yes | Yes | Yes | Yes | ||
XML | Yes | Yes |
VENDOR | DataMirror | Comment | |||
PRODUCT | iDeliver | Transform Server | Constellar HUB | Web Integrator | |
Price | $70,000 | $70,000 | $250,000 | ||
Approach | Uses a Data Dictionary to store Mappings defined in a Transformation Definition Language. | ||||
Comment | Entry Level | ||||
Data Dictionary | Yes | Yes | Yes | Yes | |
Job Scheduler | |||||
Publish & Subscribe | Yes | ||||
Real-Time | Within 5 seconds acceptable | ||||
UML | Planned | ||||
Validation of Source Data | Required | ||||
XML | |||||
| |||||
|