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."The solution is easy to use and developer friendly."
"SSIS integrates well with SQL servers and Microsoft products."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The initial setup of this solution is very straightforward."
"The data reader is the most valuable feature."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"I found the initial setup very easy."
"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."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Support is absolutely excellent, efficient, and timely."
"The tool supports multiple target update methods."
"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 automation and workflows are very strong, and you can build the workflows very easily and quickly."
"Workato is low code, intuitive, and easy to use."
"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."
"It is easier to use than other technical open-source technologies."
"It's easy to understand, makes flows and is efficient."
"Stability-wise, I rate the solution a ten out of ten."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"It's a legacy tool, that is nearing the end of its useful life."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"I would like to see better integration with Power BI."
"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."
"Tuning using this solution requires extensive expertise to improve performance."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"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."
"Customization could be better."
"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)."
"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."
"It is tedious to make a tailor-fit function."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"I would like to see the dashboarding and reporting processes improved."
"A limitation is that their cloud presence is only in North America and Europe."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"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."
Earn 20 points