We performed a comparison between Confluent and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Streaming Analytics solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I would rate the scalability of the solution at eight out of ten. We have 20 people who use Confluent in our organization now, and we hope to increase usage in the future."
"The client APIs are the most valuable feature."
"The most valuable feature that we are using is the data replication between the data centers allowing us to configure a disaster recovery or software. However, is it's not mandatory to use and because most of the features that we use are from Apache Kafka, such as end-to-end encryption. Internally, we can develop our own kind of product or service from Apache Kafka."
"I find Confluent's Kafka Connectors and Kafka Streams invaluable for my use cases because they simplify real-time data processing and ETL tasks by providing reliable, pre-packaged connectors and tools."
"Kafka Connect framework is valuable for connecting to the various source systems where code doesn't need to be written."
"It is also good for knowledge base management."
"The benefit is escaping email communication. Sometimes people ignore emails or put them into spam, but with Confluence, everyone sees the same text at the same time."
"We mostly use the solution's message queues and event-driven architecture."
"The UI is very user-friendly."
"The interface is very user-friendly."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The scalability of SSIS is good."
"The solution is stable."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"It could be improved by including a feature that automatically creates a new topic and puts failed messages."
"Confluence could improve the server version of the solution. However, most companies are going to the cloud."
"The product should integrate tools for incorporating diagrams like Lucidchart. It also needs to improve its formatting features. We also faced issues while granting permissions."
"It would help if the knowledge based documents in the support portal could be available for public use as well."
"there is room for improvement in the visualization."
"They should remove Zookeeper because of security issues."
"Areas for improvement include implementing multi-storage support to differentiate between database stores based on data age and optimizing storage costs."
"The formatting aspect within the page can be improved and more powerful."
"It needs more integration tools, so you can connect to different sources."
"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."
"The solution could improve by having quicker release updates."
"Future releases should improve the data lineage, as it currently is not good."
"The solution could improve on integrating with other types of data sources."
"Options for scaling could be improved."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
Confluent is ranked 4th in Streaming Analytics with 21 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Confluent is rated 8.4, while SSIS is rated 7.6. The top reviewer of Confluent writes "Has good technical support services and a valuable feature for real-time data streaming ". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Confluent is most compared with Amazon MSK, Amazon Kinesis, Databricks, AWS Glue and Oracle GoldenGate, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Confluent vs. SSIS report.
We monitor all Streaming Analytics 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.