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 most important features are it works well and provides self-service BI."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"The solution is easy to use and developer friendly."
"The UI is very user-friendly."
"SSIS' most valuable feature is its reporting services."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"Data transformations and rollups are easy to accomplish."
"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."
"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."
"The most valuable feature is the metadata generated code."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"It has a built-in automatic scheduling environment."
"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."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"The creation of the measure in the DAC's model could be improved."
"Options for scaling could be improved."
"It's a legacy tool, that is nearing the end of its useful life."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"The high prices attached to the product can be an area of concern where improvements are required."
"The solution could improve by having quicker release updates."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"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."
"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."
"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."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Customization could be better."
"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.