SSIS vs Workato comparison

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"It is easy to set up the product."

"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."

"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."

"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"The scalability of SSIS is good."

"It is easy to set up the solution."

"Workato is low code, intuitive, and easy to use."

"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."

"It's easy to understand, makes flows and is efficient."

"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."

"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."

"Generic processes should be used instead of custom code for each table."

"Video training would be a helpful addition."

"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."

"I would like to see better technical documentation because many times information is missing."

"I would like to see more features in terms of the integration with Azure Data Factory."

"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."

"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."

"A limitation is that their cloud presence is only in North America and Europe."

"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."

"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."

"It is tedious to make a tailor-fit function."

"People have to opt for a perpetual-based licensing model."

"Our license with SSIS is annual."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"We have an enterprise license for this solution."

"It would be beneficial if the solution had a less costly cloud offering."

"The solution is available at a lesser price than that of Informatica."

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"On a scale of one to ten, the pricing is around a six. We have a consumption model and the pricing is higher. If you are using any kind of ML-based approach, machine learning, or some advanced analytics, you may have to pay more."

"Workato is an expensive solution."

"Speaking about price, I would say that it's market-related. Also, there are costs in addition to the standard license fees since different add-ons depend on what you require."