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

IBM InfoSphere Information Server vs SSIS comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

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

Categories and Ranking

IBM InfoSphere Information ...
Ranking in Data Integration
31st
Average Rating
8.4
Reviews Sentiment
6.6
Number of Reviews
7
Ranking in other categories
Metadata Management (7th)
SSIS
Ranking in Data Integration
4th
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
72
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2025, in the Data Integration category, the mindshare of IBM InfoSphere Information Server is 0.9%, up from 0.7% 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

UmeshKumar1 - PeerSpot reviewer
Prompt support, reliable, but lacking scalability
IBM InfoSphere Information Server has multiple tools in that product suite. However, we mainly use it as an integration tool I have been using IBM InfoSphere Information Server for approximately five years. IBM InfoSphere Information Server is stable. IBM InfoSphere Information Server should be…
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

"The integration with different technologies is the most valuable feature."
"IBM InfoSphere Information Server is stable."
"This solution is extremely flexible and scalable."
"Stability-wise, I rate the solution a ten out of ten."
"It's a competent product."
"It has good data integration and good processes."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"SSIS integrates well with SQL servers and Microsoft products."
"Overall, it's a good product."
"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."
"The initial setup of this solution is very straightforward."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
 

Cons

"This solution would benefit from the engine being made more lightweight."
"There are certain shortcomings in the cloud side of the solution, where improvements are required."
"IBM InfoSphere Information Server should be more scalable. It should have the option to change the configuration to run on a single, non-multiple node, or multi-threading processing."
"Their technical support needs improvement."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"The solution could improve on integrating with other types of data sources."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."
"The creation of the measure in the DAC's model could be improved."
 

Pricing and Cost Advice

"The licensing cost of IBM InfoSphere Information Server depends on how many users there are."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"We have an enterprise license for this solution."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
"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."
"Our license with SSIS is annual."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
832,138 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
20%
Government
15%
Insurance Company
11%
Computer Software Company
8%
Financial Services Firm
18%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM InfoSphere Information Server?
Stability-wise, I rate the solution a ten out of ten.
What needs improvement with IBM InfoSphere Information Server?
There are certain shortcomings in the cloud side of the solution, where improvements are required. In our company, we are presently in the process of doing a PoC phase since we have the solution cu...
What is your primary use case for IBM InfoSphere Information Server?
I use IBM InfoSphere Information Server in retail banking for transformation purposes.
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 SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
 

Also Known As

InfoSphere Information Server, IBM Information Server
SQL Server Integration Services
 

Overview

 

Sample Customers

Canadian National Railway Company, Chickasaw Nation Division of Commerce, Swedish Armed Forces, BG RCI, Janata Sahakari Bank Ltd., University of Arizona, Biogrid Australia
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 IBM InfoSphere Information Server vs. SSIS and other solutions. Updated: January 2025.
832,138 professionals have used our research since 2012.