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 June 2025, in the Data Integration category, the mindshare of Ab Initio Co>Operating System is 1.6%, up from 0.7% 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.7%, down from 7.9% 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.
Albert Lacerda - PeerSpot reviewer
Efficient data processing and seamless cloud integration have been achieved through powerful data pipelines
One of the best aspects of SSIS ( /products/ssis-reviews ) is that it is built into Microsoft SQL Server ( /products/sql-server-reviews ), so there are no additional costs involved. Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent. I can process 1.2 million lines of data in a few minutes, even when running over a VPN connection.

Quotes from Members

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

Pros

"Ab Initio Co>Operating System support is the best I have encountered."
"The graphical interface of Ab Initio Co>Operating System is very easy to understand and allows me to visualize the data flow effectively."
"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."
"The process of using the tool's scalability option is well documented."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"It is easy to set up. The deployment is also very quick."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It is easy to set up the product."
"The setup is straightforward. It's very easy to install."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
 

Cons

"An awesome improvement would be big data solutions, for example, implementing some kind of business intelligence or neural networks for artificial intelligence."
"Ab Initio Co>Operating System is a very expensive product."
"Co>Operating System would be improved with more integrations for less well-known technologies."
"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"I would like to see better integration with Power BI."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"We'd like more integration capabilities."
 

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."
"SSIS' licensing is a little high, but it gives good value for money."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"SSIS is fairly well-priced - I would rate it at four out of five."
"All of my clients have this product included as part of their Microsoft license."
"We have an enterprise license for this solution."
"The solution comes free of cost."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
854,618 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
36%
Computer Software Company
10%
Insurance Company
7%
University
5%
No data available
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Manufacturing 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?
If Ab Initio Co>Operating System could provide an environment that allows users to practice or use it on their own...
What is your primary use case for Ab Initio Co>Operating System?
I am primarily in charge of building applications using Ab Initio Co>Operating System.
What advice do you have for others considering Ab Initio Co>Operating System?
If Ab Initio Co>Operating System provided an environment for users to practice on their own computers, it would be...
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: May 2025.
854,618 professionals have used our research since 2012.