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."SSIS is easy to use."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"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."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The performance is good."
"It is easy to set up. The deployment is also very quick."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"Workato is low code, intuitive, and easy to use."
"It's easy to understand, makes flows and is efficient."
"It is easier to use than other technical open-source technologies."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"Stability-wise, I rate the solution a ten out of ten."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"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 security could be improved, as it is more important in our context."
"The performance of SSIS could improve when comparing it to Oracle Database."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"The high prices attached to the product can be an area of concern where improvements are required."
"We'd like them to develop data exploration more."
"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."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"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."
"It is tedious to make a tailor-fit function."
"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."
"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."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
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.