We performed a comparison between StreamSets 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."StreamSets Transformer is a good feature because it helps you when you are developing applications and when you don't want to write a lot of code. That is the best feature overall."
"It's very easy to integrate. It integrates with Snowflake, AWS, Google Cloud, and Azure. It's very helpful for DevOps, DataOps, and data engineering because it provides a comprehensive solution, and it's not complicated."
"I really appreciate the numerous ready connectors available on both the source and target sides, the support for various media file formats, and the ease of configuring and managing pipelines centrally."
"Important features include that it comprises lots of functionality to connect data from various sources through connector availability, scheduling pipelines at any time, and integration with third-party and security solutions for encryption."
"Also, the intuitive canvas for designing all the streams in the pipeline, along with the simplicity of the entire product are very big pluses for me. The software is very simple and straightforward. That is something that is needed right now."
"It is a very powerful, modern data analytics solution, in which you can integrate a large volume of data from different sources. It integrates all of the data and you can design, create, and monitor pipelines according to your requirements. It is an all-in-one day data ops solution."
"The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."
"The most valuable features are the option of integration with a variety of protocols, languages, and origins."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"It's easy to understand, makes flows and is efficient."
"Workato is low code, intuitive, and easy to use."
"It is easier to use than other technical open-source technologies."
"Stability-wise, I rate the solution a ten out of ten."
"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."
"I would like to see it integrate with other kinds of platforms, other than Java. We're going to have a lot of applications using .NET and other languages or frameworks. StreamSets is very helpful for the old Java platform but it's hard to integrate with the other platforms and frameworks."
"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."
"We create pipelines or jobs in StreamSets Control Hub. It is a great feature, but if there is a way to have a folder structure or organize the pipelines and jobs in Control Hub, it would be great. I submitted a ticket for this some time back."
"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."
"Sometimes, when we have large amounts of data that is very efficiently stored in Hadoop or Kafka, it is not very efficient to run it through StreamSets, due to the lack of efficiency or the resources that StreamSets is using."
"Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful."
"Using ETL pipelines is a bit complicated and requires some technical aid."
"The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base."
"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."
"I would like to see the dashboarding and reporting processes improved."
"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."
"A limitation is that their cloud presence is only in North America and Europe."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
StreamSets is ranked 8th in Data Integration with 24 reviews while Workato is ranked 8th in Integration Platform as a Service (iPaaS) with 9 reviews. StreamSets is rated 8.4, while Workato is rated 8.4. The top reviewer of StreamSets writes "We no longer need to hire highly skilled data engineers to create and monitor data pipelines". On the other hand, the top reviewer of Workato writes " Great automation and strong workflows useful for integration". StreamSets is most compared with Fivetran, Informatica PowerCenter, Azure Data Factory, SSIS and IBM InfoSphere DataStage, whereas Workato is most compared with Microsoft Azure Logic Apps, Azure Data Factory, MuleSoft Composer, Oracle Integration Cloud Service and SnapLogic. See our StreamSets 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.