We performed a comparison between Boomi AtomSphere Integration and StreamSets based on real PeerSpot user reviews.
Find out in this report how the two Integration Platform as a Service (iPaaS) solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The Salesforce and NetSuite Application specific “connectors” provide a layer of abstraction on top of the SOAP-based APIs to streamline integration development."
"It is easy to learn and implement."
"The product's integration features are quite rich and low code. It is easy to use."
"I have found the solution to be scalable."
"We work on the flow between systems and the most valuable features for that purpose are the mapping of data, interface mapping, and data integration."
"Boomi AtomSphere Integration is stable."
"I really appreciate the on-the-go access through the browser and the B2B integration."
"Low-code development is the most valuable feature."
"For me, the most valuable features in StreamSets have to be the Data Collector and Control Hub, but especially the Data Collector. That feature is very elegant and seamlessly works with numerous source systems."
"The ability to have a good bifurcation rate and fewer mistakes is valuable."
"The entire user interface is very simple and the simplicity of creating pipelines is something that I like very much about it. The design experience is very smooth."
"It is really easy to set up and the interface is easy to use."
"In StreamSets, everything is in one place."
"The UI is user-friendly, it doesn't require any technical know-how and we can navigate to social media or use it more easily."
"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."
"The scheduling within the data engineering pipeline is very much appreciated, and it has a wide range of connectors for connecting to any data sources like SQL Server, AWS, Azure, etc. We have used it with Kafka, Hadoop, and Azure Data Factory Datasets. Connecting to these systems with StreamSets is very easy."
"Have to create some of our own pre-built connectors."
"They should create a custom connector option. With this, they could improve where the user can create the connector, based on their usage."
"There should be more scripting possibilities."
"There are very few string handling functions and few mathematical functions are available."
"There are still some areas that need improvement. For example, when updates are going on, the product becomes very slow."
"The API can use some work to come up to speed with the competition but Dell has plans and is working on resolving that."
"Boomi AtomSphere Integration is not yet exposed to the world as a good product owing to certain shortcomings in the area of marketing where improvements are required."
"Lots of enhancements are needed in the API portal so that the developers can view the definitions, try out the APIs, etc."
"The design experience is the bane of our existence because their documentation is not the best. Even when they update their software, they don't publish the best information on how to update and change your pipeline configuration to make it conform to current best practices. We don't pay for the added support. We use the "freeware version." The user community, as well as the documentation they provide for the standard user, are difficult, at best."
"The data collector in StreamSets has to be designed properly. For example, a simple database configuration with MySQL DB requires the MySQL Connector to be installed."
"In terms of the product, I don't think there is any room for improvement because it is very good. One small area of improvement that is very much needed is on the knowledge base side. Sometimes, it is not very clear how to set up a certain process or a certain node for a person who's using the platform for the first time."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
"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."
"I would like to see further improvement in the UI. In addition, upgrades are not automatic and they should be automated. Currently, we have to manually upgrade versions."
"The execution engine could be improved. When I was at their session, they were using some obscure platform to run. There is a controller, which controls what happens on that, but you should be able to easily do this at any of the cloud services, such as Google Cloud. You shouldn't have any issues in terms of how to run it with their online development platform or design platform, basically their execution engine. There are issues with that."
Boomi AtomSphere Integration is ranked 5th in Integration Platform as a Service (iPaaS) with 25 reviews while StreamSets is ranked 8th in Data Integration with 24 reviews. Boomi AtomSphere Integration is rated 7.8, while StreamSets is rated 8.4. The top reviewer of Boomi AtomSphere Integration writes "Stable product, suitable for limited integrations and lacks flexibility ". On the other hand, the top reviewer of StreamSets writes "We no longer need to hire highly skilled data engineers to create and monitor data pipelines". Boomi AtomSphere Integration is most compared with Microsoft Azure Logic Apps, webMethods Integration Server, Oracle Integration Cloud Service, SSIS and Azure Data Factory, whereas StreamSets is most compared with Fivetran, Azure Data Factory, Informatica PowerCenter, SSIS and Oracle GoldenGate. See our Boomi AtomSphere Integration vs. StreamSets report.
We monitor all Integration Platform as a Service (iPaaS) 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.