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 is easy to set up. The deployment is also very quick."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The setup is straightforward. It's very easy to install."
"Stability-wise, I rate the solution a ten out of ten."
"Workato is low code, intuitive, and easy to use."
"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."
"It is easier to use than other technical open-source technologies."
"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."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"This solution needs full support for real-time processing."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"The solution could improve on integrating with other types of data sources."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"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."
"A limitation is that their cloud presence is only in North America and Europe."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"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."
"It is tedious to make a tailor-fit function."
SSIS is ranked 2nd in Data Integration with 68 reviews while Workato is ranked 8th in Integration Platform as a Service (iPaaS) with 9 reviews. SSIS is rated 7.8, 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, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue, whereas Workato is most compared with Microsoft Azure Logic Apps, MuleSoft Composer, Azure Data Factory, SnapLogic and Celigo Integration Platform. 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.