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."The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"SSIS is easy to use."
"The solution is stable."
"The performance is good."
"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."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"It has a built-in automatic scheduling environment."
"The most valuable feature is the metadata generated code."
"Data transformations and rollups are easy to accomplish."
"The tool supports multiple target update methods."
"I found the initial setup very easy."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"Support is absolutely excellent, efficient, and timely."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"The performance of this solution is not as good as other tools in the market."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"It hangs a lot of the time."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"The security could be improved, as it is more important in our context."
"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."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Technical support isn't the best."
"Customization could be better."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
"No support for change data capture or delta detection - that must be custom coded ."
"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."
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 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.
