Detailed Comparison Matrix of ETL Solutions
| Feature | Informatica Powercenter |
IBM DataStage |
Microsoft SSIS |
Pervasive Data Integrator |
Talend Integration Suite |
Pentaho Kettle Enterprise |
CloverETL |
|
|---|---|---|---|---|---|---|---|---|
| Easy to Use | Yes
|
No
|
No |
Yes
|
OK
|
Yes
|
Yes
|
Yes
|
| Web-based UI | Yes |
No |
No |
No |
No |
No |
No |
No |
| Multi-role Team Collaboration | Yes |
Yes |
Yes |
No |
No |
Yes |
No |
No |
| Process Centric Approach | Yes |
No |
No |
No |
No |
No |
No |
No |
| Enables SOA | Yes |
No |
No |
No |
No |
No |
No |
No |
| Reusable Services Repository | Yes |
No |
No |
No |
No |
No |
No |
No |
| Single-install,Light Footprint | Yes |
No |
No |
No |
Yes |
Yes |
No |
Yes |
| Large Volume Performance | Yes |
Yes |
Yes |
OK |
OK |
OK |
OK |
Yes |
| Clustering and Job Distribution | Yes |
Yes |
Yes |
No |
No |
Yes |
Yes |
Yes |
| Data Partitioning | Yes |
Yes |
Yes |
No |
Yes |
OK |
No |
Yes |
| Automatic Recovery of Flows | Yes |
Yes |
Yes |
No |
No |
No |
No |
No |
| XA-Transaction Rollbacks | Yes |
Yes |
Yes |
No |
No |
No |
No |
No |
| Meta-Driven Approach vs.Code | Yes |
Yes |
No |
No |
No |
No |
Yes |
Yes |
| Built-in Scheduler | Yes |
Yes |
Yes |
No |
No |
Yes |
No |
No |
| Real-time Triggers | Yes |
Yes |
Yes |
No |
No |
No |
No |
No |
| Non-RDBMS Connections | Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
Yes |
| Web Services Client | Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
| Publish Flows as Web Services | Yes |
Yes |
No |
No |
No |
No |
No |
No |
| Join Multiple Sources | Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
| Split Data Streams | Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
| Graphical Data Mapper | Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
| Complex Transformations | Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
| Data Validations | Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
| Preview Source Data In-Design | Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
Yes |
| Run Mapping Rules In-Design | Yes |
Yes |
Yes |
No |
No |
Yes |
Yes |
Yes |
| Library of New Mapping Functions | Yes |
Yes |
Yes |
No |
No |
No |
No |
No |
| Complex Lookups | Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
| Automatic Documentation | Yes |
Yes |
Yes |
No |
No |
No |
No |
No |
| Human Workflow for Error Handling | Yes |
No |
No |
No |
No |
No |
No |
No |
| Plug-in External Programs | Yes |
Yes |
Yes |
No |
Yes |
No |
No |
No |
| Alerts and Notifications | Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
Yes |
| Version Control | No |
Yes |
Yes |
No |
No |
Yes |
No |
No |
| Deploy in Cloud Option | Yes |
No |
No |
No |
Yes |
No |
Yes |
No |
| Commerical or Open Source | C |
C |
C |
C |
C |
OS |
OS |
OS |
| Price | $ |
$$$$ |
$$$ |
$$ |
$$ |
$$ |
$
|
$ |
Note:
- OK implies limited functionality or that the functionality is available thru third-parties
- The content in this comparison matrix has been collected by reviewing publicly available information. Some of the products may have newer versions with updated features. If you have information to help us correct and update the data in this table, please send us an email at marketing@adeptia.com
- License Pricing estimate for first year cost (basic configuration):
$$$$ $150,000+ $$$ $60,000 to $150,000 $$ $20,000 to $60,000 $ Less than $20,000
Enterprise ETL Vendors
IBM DataStage and Informatica are examples of Enterprise ETL solutions that have extensive background and experience in the ETL market with their ability to scale performance in handling very large data volumes in complex, heterogeneous environments. These products provide comprehensive features and functionality and so require extensive training to use effectively. Other solutions in this category are Oracle Warehouse Builder, SAS Integration Server and Business Objects Data Integrator. Considering the cost and the effort required in implementing these solutions, they are typically best suited for large, complex, enterprise-wide business intelligence scenarios in Fortune 1000 organizations.
Open Source ETL Vendors
On the other spectrum of the market are the Open Source vendors that offer ETL solutions which are now maturing into viable technology alternatives. Talend, Pentaho and CloverETL are examples of solutions available in this category. These providers typically offer a version of their software with a free, open-source license, however, most users find those editions to be too limited for real-life situations. They also typically offer a commercially licensed-version which is more feature rich although it is the same code as the open source, but includes support and warranty. Early adopters of Open Source solutions are typically independent software vendors (ISVs) and systems integrators (SIs) who view these solutions to be attractive alternatives to writing custom code.
Where does Adeptia fit in?
Adeptia ETL Suite is a commercially-licensed packaged software that is targeted to the mid-market and large enterprises that need a good, easy-to-use solution for typical integration and ETL requirements. It is designed to build integration flows very quickly by reusing existing components. It is ideal for creating and centrally managing data flows from within one tool, rather than writing ad-hoc programs and scripts.
Adeptia provides rich functionality at a fraction of the cost of comparative solutions. Adeptia provides technical documentation, as well as training and support options. Adeptia has been in business for 10+ years and its commercial license approach also addresses any risks that customers may associate with open source software.
Adeptia ETL Suite is priced at $1200/month per server. There are NO limits on usage or number of connections. A perpetual, one-time license option is also available.
This may seem as an incredible value given all the functionality that is available in this product as shown in the table above. But this is true, and we welcome you to validate this for yourself.
- You can watch video demos of Adeptia ETL Suite here.
- You can download a 30-day trial of Adeptia ETL Suite here.
- Read here what our customers are saying.
- Request a live demostration by sending us an email at sales@adeptia.com