No more typing reviews! Try our Samantha, our new voice AI agent.

IBM InfoSphere Information Server vs SSIS comparison

Why PeerSpot?
 

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
35th
Average Rating
8.2
Reviews Sentiment
5.8
Number of Reviews
9
Ranking in other categories
Metadata Management (8th)
SSIS
Ranking in Data Integration
2nd
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
76
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2026, in the Data Integration category, the mindshare of IBM InfoSphere Information Server is 0.8%, down from 0.9% compared to the previous year. The mindshare of SSIS is 4.0%, down from 5.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
SSIS4.0%
IBM InfoSphere Information Server0.8%
Other95.2%
Data Integration
 

Featured Reviews

MI
Senior Data Engineer at Mohammed Mansour Alrumiah
Faced challenges with customer support and documentation but have benefited from reliable data integration over the years
As for utilizing the platform's metadata management feature, I have not worked on that feature yet, but personally, I have done that. To evaluate the effectiveness of IBM InfoSphere Information Server's data integration capabilities, if IBM is providing all the solutions we are using, then it is definitely a helpful thing. Mostly, the other thing is that it is a big area including data governance, data lineage, data management, and metadata, but every customer is not putting that much effort and money on that. They mostly migrate the data, use it, and forget it, but slowly things are changing. I am working in Saudi Arabia, so here also data governance, data management, and those kinds of things are getting attention. Regarding how scalable IBM InfoSphere Information Server is, I need to learn how to tune performance and scalability on the cloud. I am familiar with localized hardware, but on the cloud, I still have to do the work around it. In the beginning, we estimate the load and based on that, we put the hardware, but if there is continuous increase, I believe IBM also faces problems. Scalability needs to be improved because once the demand comes, you should be able to improve it, but for that, documentation on how to add hardware or resources to the software needs to be proper. I do not have much hands-on experience with that.
reviewer2318280 - PeerSpot reviewer
Tech Lead at a consultancy with 11-50 employees
Reporting has become streamlined for year-end data checks but integration still needs improvement
When I talk about SQL Server, I am working with SSIS, the data integration tool. I am not entirely sure if I use SSIS as a library of transformations or if I personally work with an extensive library of transformations. I have integrated SSIS with SQL Server Management Studio, and I am very satisfied with the integration as it is integrated well. I am not using the debugging feature in SSIS because the developers would be the ones that would actually utilize it. I have noticed that in 2022, AI functionality has actually been implemented already. I would rate this review overall at a 7.

Quotes from Members

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

Pros

"This solution has reduced the time it takes for ETL. We took an existing Teradata ETL application from three days to eight minutes."
"Data connections, data partitioning, flexibility, and performance are the most valuable features."
"Deploying the solution is straightforward for me."
"The initial IBM InfoSphere Information Server is straightforward and you can choose what type of installation you want, such as a customized installation, with clear-cut documentation that, if followed, works fine and the installation has not given us issues."
"IBM InfoSphere Information Server is stable."
"This solution is extremely flexible and scalable."
"Over the years of working with IBM InfoSphere Information Server, I see basically the strength of the tool, capability, and load balancing, which I see is really good."
"Stability-wise, I rate the solution a ten out of ten."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"I have never had a situation where a particular transformation was not possible in SSIS."
"It's already very user-friendly and has a good dashboard."
"There is a huge community to find the tutorials you need."
"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."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
 

Cons

"There are certain shortcomings in the cloud side of the solution, where improvements are required."
"Customer Service: It's poor."
"We have decided to decrease the usage of metadata management because we did not see any significant advantages."
"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."
"Unlike other tools, IBM tools do not provide much help from the internet, so additional support should be available."
"Heavy use of scratch disk which sometimes leads to failure."
"This solution would benefit from the engine being made more lightweight."
"Their technical support needs improvement."
"We'd like them to develop data exploration more."
"SSIS should not be used whatsoever anymore."
"The logging capabilities could be improved, particularly for error logging."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc. Also, handling of the different data types will be a big challenge here; so expecting improvement in these areas."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"Need to improve error logging although it does provide error logs but there is still more room for improvement in this area."
"The security could be improved, as it is more important in our context."
 

Pricing and Cost Advice

"The licensing cost of IBM InfoSphere Information Server depends on how many users there are."
"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."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
"We purchased the standard edition of SQL Server and SSIS came with it free of charge."
"The solution comes free of cost."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"People have to opt for a perpetual-based licensing model."
"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 is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
920,769 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
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
14%
Construction Company
13%
Comms Service Provider
11%
Manufacturing Company
8%
Financial Services Firm
13%
Manufacturing Company
8%
Outsourcing Company
8%
Construction Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business5
Midsize Enterprise1
Large Enterprise5
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise19
Large Enterprise58
 

Questions from the Community

What needs improvement with IBM InfoSphere Information Server?
We are using the on-premises version of IBM InfoSphere Information Server, but we feel that all new development is mainly for the cloud. We receive corrections of errors, but we do not see new func...
What is your primary use case for IBM InfoSphere Information Server?
My usual use case for IBM InfoSphere Information Server is ETL, where we take data from one source to another data warehouse solution.
What advice do you have for others considering IBM InfoSphere Information Server?
We are about to change our platform from IBM AIX to SUSE Linux, as our whole platform is changing, so everyone should change from IBM to SUSE Linux. It would be very difficult for us to have a diff...
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 is your experience regarding pricing and costs for SSIS?
Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.
What needs improvement with SSIS?
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly. The initial setup for SSIS is somewhat complex in the beginning, but once you und...
 

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: October 2026.
920,769 professionals have used our research since 2012.