Try our new research platform with insights from 80,000+ expert users

Ab Initio Co>Operating System vs Informatica Enterprise Data Lake vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Mindshare comparison

As of April 2025, in the Data Integration category, the mindshare of Ab Initio Co>Operating System is 1.5%, up from 0.6% compared to the previous year. The mindshare of Informatica Enterprise Data Lake is 0.2%, up from 0.2% compared to the previous year. The mindshare of SSIS is 7.9%, down from 8.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

AM
Enables creation of sophisticated applications with powerful parallelism and quick, effective support
The most valuable features of Ab Initio Co>Operating System are its performance and the ability to implement parallelism. There are three kinds of parallelism in Ab Initio Co>Operating System, which allow us to create very sophisticated solutions for almost any kind of application. This parallelism is one of the strongest features. Additionally, its scalability offers a unique way to escalate applications that differs from other technologies. In terms of data processing, the emphasis is on understanding the data. Data profiling is fundamental, and Ab Initio Co>Operating System integrates tools to perform this within the GDE, as well as specialized products for this purpose. Data profiling graphs can be implemented when necessary to understand the data sources.
reviewer2330691 - PeerSpot reviewer
A scalable tool that needs a lot of maintenance due to its unstable nature
Governance, data dictionary, and data cataloging are not available in Informatica Enterprise Data Lake. A lot of businesses are facing issues related to understanding the area revolving around insights of data. At Informatica Enterprise Data Lake's level, in our company, we have a lot of redundant data in a lot of our core systems. The basic thing that our company wants is for the product to develop a reporting layer and access data from the document layer so that we can avoid duplication in projects, databases, and data. There is a lot of maintenance to be done owing to the instability users may face every time because of the huge processing capacity as the company has around more than 50 nodes, which causes a lot of maintenance issues because of which a lot of people don't benefit from the platform as it functions in a slow manner. Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems. Every time, we have to find different tools we can use in our company with the solution since it doesn't support many real-time systems. Even if our company invests in some tools, Informatica Enterprise Data Lake creates too many small files with some issues, which we cannot read because we invested in HBase and Kudu, but performance-wise, the process is slow.
BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Co>Operating System's most valuable feature is its ability to process bulk data effectively."
"Ab Initio reaches the highest performance and is very flexible in processing huge amounts of data."
"Ab Initio Co>Operating System support is the best I have encountered."
"The process of using the tool's scalability option is well documented."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The most important features are it works well and provides self-service BI."
"It is easy to set up the solution."
"Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent."
"It is easy to set up the product."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"It's already very user-friendly and has a good dashboard."
 

Cons

"Co>Operating System would be improved with more integrations for less well-known technologies."
"An awesome improvement would be big data solutions, for example, implementing some kind of business intelligence or neural networks for artificial intelligence."
"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"The performance of this solution is not as good as other tools in the market."
"I would like to see better technical documentation because many times information is missing."
"It's a legacy tool, that is nearing the end of its useful life."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Video training would be a helpful addition."
"SSIS has a difficult learning curve when dealing with complex transformations."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
 

Pricing and Cost Advice

"Co>Operating System's pricing is on the expensive end since it tends to be used by big enterprises."
"The licenses attached to the solution are highly priced."
"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."
"People have to opt for a perpetual-based licensing model."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"The solution is available at a lesser price than that of Informatica."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"SSIS' licensing is a little high, but it gives good value for money."
"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
849,600 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
38%
Computer Software Company
10%
Insurance Company
7%
University
5%
No data available
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
No data available
 

Questions from the Community

What needs improvement with Ab Initio Co>Operating System?
Ab Initio Co>Operating System has its own paradigm, requiring a new approach to problem-solving that differs from ...
What is your primary use case for Ab Initio Co>Operating System?
My main experience with Ab Initio Co>Operating System has been in banking. I have architected and developed many a...
What advice do you have for others considering Ab Initio Co>Operating System?
On a scale of one to ten, I would rate Ab Initio Co>Operating System a nine. It is a very good technology for solv...
What do you like most about Informatica Enterprise Data Lake?
The process of using the tool's scalability option is well documented.
What is your experience regarding pricing and costs for Informatica Enterprise Data Lake?
The licenses attached to the solution are highly priced. Informatica has licensing models for every product and for e...
What needs improvement with Informatica Enterprise Data Lake?
Governance, data dictionary, and data cataloging are not available in Informatica Enterprise Data Lake. A lot of busi...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called ...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Also Known As

Co>Operating System
Informatica Intelligent Data Lake, Intelligent Data Lake
SQL Server Integration Services
 

Overview

 

Sample Customers

A multinational transportation company
Information Not Available
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: March 2025.
849,600 professionals have used our research since 2012.