We performed a comparison between SSIS and Workato 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 the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"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."
"We can connect with multiple data sources easily using an external connector in SSIS."
"SSIS integrates well with SQL servers and Microsoft products."
"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."
"Workato is low code, intuitive, and easy to use."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"It is easier to use than other technical open-source technologies."
"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."
"Stability-wise, I rate the solution a ten out of ten."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"It hangs a lot of the time."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The security could be improved, as it is more important in our context."
"The performance of SSIS could improve when comparing it to Oracle Database."
"The creation of the measure in the DAC's model could be improved."
"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 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."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"A limitation is that their cloud presence is only in North America and Europe."
"It is tedious to make a tailor-fit function."
"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."
"I would like to see the dashboarding and reporting processes improved."
SSIS is ranked 2nd in Data Integration with 69 reviews while Workato is ranked 8th in Integration Platform as a Service (iPaaS) with 9 reviews. SSIS is rated 7.6, while Workato is rated 8.4. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of Workato writes " Great automation and strong workflows useful for integration". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas Workato is most compared with Microsoft Azure Logic Apps, MuleSoft Composer, Azure Data Factory, Oracle Integration Cloud Service and Tray.io. See our SSIS vs. Workato report.
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.