We performed a comparison between SSIS and WhereScape RED based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The technical support is very good."
"The simplicity of the solution is great. The solution also offers excellent integration."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"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."
"The performance and stability are good."
"The solution is stable."
"SSIS integrates well with SQL servers and Microsoft products."
"SSIS' best feature is SFTP connectivity."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"It has a built-in automatic scheduling environment."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"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."
"The most valuable feature is the metadata generated code."
"I like the data vault implementations."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"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."
"The solution could improve by having quicker release updates."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"It's a legacy tool, that is nearing the end of its useful life."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"No support for change data capture or delta detection - that must be custom coded ."
"Technical support isn't the best."
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, Denodo and Talend Open Studio. See our SSIS vs. WhereScape RED report.
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.