We performed a comparison between SSIS, WhereScape RED, and Workato based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."SSIS' best feature is SFTP connectivity."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"SSIS' most valuable feature is its reporting services."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The scalability of SSIS is good."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"It's saved time using visualization descriptions."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"I like the data vault implementations."
"The most valuable feature is the metadata generated code."
"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."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"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."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"Stability-wise, I rate the solution a ten out of ten."
"It's easy to understand, makes flows and is efficient."
"It is very easy to use. It takes complex workloads away, and it provides very smooth integration. It has got a lot of out-of-the-box connectors. It has got a lot of out-of-the-box APIs, which makes it really easy to integrate with applications for different use cases, whether it is in finance, HR, or customer operations. It is by far our favorite integration product."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"It is easier to use than other technical open-source technologies."
"Workato is low code, intuitive, and easy to use."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"It would be nice if you could run SSIS on other environments besides Windows."
"Performance could be better."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Technical support isn't the best."
"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 ."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Improve the object renaming ability (it works, but it could be more automated)."
"Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"The only minor drawback would be if there was a UI at the front of it, for apps and for a portal as well, it would make it really easy. It would be really useful if there were more apps capabilities."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"I would like to see the dashboarding and reporting processes improved."
"It is tedious to make a tailor-fit function."
"A limitation is that their cloud presence is only in North America and Europe."
Earn 20 points