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."One of the best features of Confluent is that it's very easy to search and have a live status with Jira."
"With Confluent Cloud we no longer need to handle the infrastructure and the plumbing, which is a concern for Confluent. The other advantage is that all portfolios have access to the data that is being shared."
"Kafka Connect framework is valuable for connecting to the various source systems where code doesn't need to be written."
"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."
"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."
"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."
"The most valuable feature of Confluent is the wide range of features provided. They're leading the market in this category."
"Confluence's greatest asset is its user-friendly interface, coupled with its remarkable ability to seamlessly integrate with a vast range of other solutions."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The initial setup was easy."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"It has good data integration and good processes."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The interface is very user-friendly."
"The product's deployment phase is easy."
"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."
"It could be more user-friendly and centralized. A way to reduce redundancy would be helpful."
"It requires some application specific connectors which are lacking. This needs to be added."
"The pricing model should include the ability to pick features and be charged for them only."
"there is room for improvement in the visualization."
"It could have more themes. They should also have more reporting-oriented plugins as well. It would be great to have free custom reports that can be dispatched directly from Jira."
"They should remove Zookeeper because of security issues."
"There is no local support team in Saudi Arabia."
"Confluence could improve the server version of the solution. However, most companies are going to the cloud."
"The creation of the measure in the DAC's model could be improved."
"The solution could improve by having quicker release updates."
"I would like to see better integration with Power BI."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"We'd like them to develop data exploration more."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"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."
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.