We performed a comparison between SSIS and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The data reader is the most valuable feature."
"The initial setup was easy."
"SSIS integrates well with SQL servers and Microsoft products."
"It's a competent product."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The performance is good."
"Data transformations and rollups are easy to accomplish."
"Support is absolutely excellent, efficient, and timely."
"The tool supports multiple target update methods."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Naturally produces a way to easily debug your DW data solutions."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Video training would be a helpful addition."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"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."
"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."
"Technical support isn't the best."
"Improve the object renaming ability (it works, but it could be more automated)."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"No support for change data capture or delta detection - that must be custom coded ."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
Earn 20 points
SSIS is ranked 2nd in Data Integration with 69 reviews while WhereScape RED is ranked 48th in Data Integration. SSIS is rated 7.6, while WhereScape RED is rated 8.2. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of WhereScape RED writes "Quick to set up, flexible, and stable". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas WhereScape RED is most compared with Azure Data Factory, Informatica PowerCenter, Matillion ETL, Talend Open Studio and Denodo.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.