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."It has good data integration and good processes."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"SSIS' most valuable feature is its reporting services."
"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 interface is very user-friendly."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"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."
"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."
"Naturally produces a way to easily debug your DW data solutions."
"Support is absolutely excellent, efficient, and timely."
"I found the initial setup very easy."
"It has a built-in automatic scheduling environment."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"I like the data vault implementations."
"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."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The creation of the measure in the DAC's model could be improved."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Performance could be better."
"It needs more integration tools, so you can connect to different sources."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Technical support isn't the best."
"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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"No support for change data capture or delta detection - that must be custom coded ."
"Improve the object renaming ability (it works, but it could be more automated)."
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.