IBM InfoSphere DataStage vs. SQL Server Integration Services

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
IBM InfoSphere DataStage
Score 8.5 out of 10
N/A
IBM InfoSphere DataStage is an ETL platform for integrating data across enterprise systems, available on-premise or on cloud.N/A
SSIS
Score 8.2 out of 10
N/A
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A
Pricing
IBM InfoSphere DataStageSQL Server Integration Services
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
IBM InfoSphere DataStageSSIS
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
IBM InfoSphere DataStageSQL Server Integration Services
Considered Both Products
IBM InfoSphere DataStage
Chose IBM InfoSphere DataStage
Currently not using any of the Informatica tools, so, I don't have a real way of comparing the tools. But comparison against Microsoft SSIS (SQL Server Integration Services) I'd say DataStage stacks favorably. DataStage is a powerful tool for ETL processes that integrates …
Chose IBM InfoSphere DataStage
DataStage offers better integration capabilities without the need to write code manually. It also has a native ETL engine whereas MSIS requires a SQL Server. It has better integration capabilities with data quality, data profiling and data governance tools. The main drawback of …
SSIS
Chose SQL Server Integration Services
SSIS is a very basic, developer-oriented ETL tool and while it lacks many of the nice UX features of its competitors it is a powerful tool that comes as a part of SQL Server and, in the hands of experienced developers with domain knowledge, can meet most organizations' ETL …
Top Pros
Top Cons
Features
IBM InfoSphere DataStageSQL Server Integration Services
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
IBM InfoSphere DataStage
9.1
9 Ratings
9% above category average
SQL Server Integration Services
7.6
55 Ratings
9% below category average
Connect to traditional data sources9.59 Ratings8.855 Ratings
Connecto to Big Data and NoSQL8.78 Ratings6.342 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
IBM InfoSphere DataStage
9.5
9 Ratings
12% above category average
SQL Server Integration Services
8.2
55 Ratings
2% below category average
Simple transformations9.89 Ratings8.755 Ratings
Complex transformations9.29 Ratings7.754 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
IBM InfoSphere DataStage
9.0
9 Ratings
11% above category average
SQL Server Integration Services
7.6
53 Ratings
6% below category average
Data model creation9.36 Ratings8.729 Ratings
Metadata management8.68 Ratings7.435 Ratings
Business rules and workflow8.08 Ratings7.944 Ratings
Collaboration9.09 Ratings7.540 Ratings
Testing and debugging9.59 Ratings6.550 Ratings
feature 19.54 Ratings7.34 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
IBM InfoSphere DataStage
8.9
8 Ratings
9% above category average
SQL Server Integration Services
7.2
43 Ratings
12% below category average
Integration with data quality tools8.88 Ratings7.738 Ratings
Integration with MDM tools9.08 Ratings6.738 Ratings
Best Alternatives
IBM InfoSphere DataStageSQL Server Integration Services
Small Businesses
Dataloader.io
Dataloader.io
Score 8.3 out of 10
Dataloader.io
Dataloader.io
Score 8.3 out of 10
Medium-sized Companies
InfoSphere
InfoSphere
Score 10.0 out of 10
InfoSphere
InfoSphere
Score 10.0 out of 10
Enterprises
InfoSphere
InfoSphere
Score 10.0 out of 10
InfoSphere
InfoSphere
Score 10.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
IBM InfoSphere DataStageSQL Server Integration Services
Likelihood to Recommend
8.7
(9 ratings)
8.1
(55 ratings)
Likelihood to Renew
-
(0 ratings)
10.0
(3 ratings)
Usability
9.0
(2 ratings)
9.3
(8 ratings)
Performance
9.0
(2 ratings)
8.8
(12 ratings)
Support Rating
9.2
(5 ratings)
8.2
(14 ratings)
Implementation Rating
-
(0 ratings)
10.0
(2 ratings)
User Testimonials
IBM InfoSphere DataStageSQL Server Integration Services
Likelihood to Recommend
IBM
Excellent Cloud data mapping tool and easy creating multiple project data analytics in real-time and the report distribution are excellent via this IBM product. Easy tool to provide data visualization and the integration is effective and helpful to migrating huge amounts of data across other platforms and different websites insights gathering.
Read full review
Microsoft
There are always alternative options available to meet the demand for integration. In my opinion, SQL Server Integration Services has a wide variety of capabilities that makes it a very versatile tool for developing dependable integration strategies. When determining which tools to utilize, vendor interfaces may play a significant role, and technologies like PowerShell have been used by colleagues to aid in this decision. For even more user-friendliness, our SSIS solution additionally makes use of a third-party plugin.
Read full review
Pros
IBM
  • Data movement
  • Seamless integration of scripts and etl jobs
  • Descriptive logging
  • Ability to work with myriad of data assets
  • Direct integration for Governance catalog
Read full review
Microsoft
  • Standard ETL use cases for daily loads
  • Loading incoming data from Vendors which is placed on FTP and adding them to the SQL Warehouse
  • Creating outgoing data files and writing them to Vendor FTPs
  • Easy Active Directory integration for seamless connections to SQL Server
  • CI/CD by hosting the code on visualstudio.com
Read full review
Cons
IBM
  • Connector Stages to Snowflake on the cloud. We had some issues initially but since then had been corrected.
  • Accessing tool from a browser (zero foot-print). Currently we need to either install locally or connect to a server to do ETL work.
  • Diversify ways of authenticating users.
Read full review
Microsoft
  • Connection managers for online data sources can be tricky to configure.
  • Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
  • Mapping destination using OLE DB command is difficult as destination columns are unnamed.
  • Excel or flat file connections are limited by version and type.
Read full review
Likelihood to Renew
IBM
No answers on this topic
Microsoft
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
Read full review
Usability
IBM
Because it is robust, and it is being continuously improved. DS is one of the most used and recognized tools in the market. Large companies have implemented it in the first instance to develop their DW, but finding the advantages it has, they could use it for other types of projects such as migrations, application feeding, etc.
Read full review
Microsoft
SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
Read full review
Performance
IBM
It could load thousands of records in seconds. But in the Parallel version, you need to understand how to particionate the data. If you use the algorithms erroneously, or the functionalities that it gives for the parsing of data, the performance can fall drastically, even with few records. It is necessary to have people with experience to be able to determine which algorithm to use and understand why.
Read full review
Microsoft
SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
Read full review
Support Rating
IBM
I believe that IBM generally has one of the worst and most complex assistance systems (physical and online) that exists.
Read full review
Microsoft
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
Read full review
Implementation Rating
IBM
No answers on this topic
Microsoft
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Read full review
Alternatives Considered
IBM
It's obvious since they both are from the same vendors and it makes it easier and can get better rates for licensing. Also, sales rapes are very helpful in case of escalations and critical issues.
Read full review
Microsoft
I had nothing to do with the choice or install. I assume it was made because it's easy to integrate with our SQL Server environment and free. I'm not sure of any other enterprise level solution that would solve this problem, but I would likely have approached it with traditional scripting. Comparably free, but my own familiarity with trad scripts would be my final deciding factor. Perhaps with some further training on SSIS I would have a different answer.
Read full review
Return on Investment
IBM
  • Reduce development time by 65% compared with hand coding.
  • Reduces ETL process maintenance times.
  • Better data governance for technical and non-technical people.
  • Improve time to market for initiatives that require data integration.
Read full review
Microsoft
  • Data integrity across various products allows unify certain processes inside the organization and save funds by reducing human labour factor.
  • Automated data unification allows us plan our inputs better and reduce over-warehousing by overbuying
  • The employee number, responsible for data management was reduced from 4 to 1 person
Read full review
ScreenShots