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."The product's deployment phase is easy."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"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."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"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."
"It is easy to set up the solution."
"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."
"Workato is low code, intuitive, and easy to use."
"It is easier to use than other technical open-source technologies."
"It's easy to understand, makes flows and is efficient."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"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."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"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."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The performance of this solution is not as good as other tools in the market."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"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."
"The solution could improve by having quicker release updates."
"It is tedious to make a tailor-fit function."
"A limitation is that their cloud presence is only in North America and Europe."
"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."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"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."
"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.