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."Kafka Connect framework is valuable for connecting to the various source systems where code doesn't need to be written."
"The monitoring module is impressive."
"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."
"Their tech support is amazing; they are very good, both on and off-site."
"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."
"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 Confluent is the wide range of features provided. They're leading the market in this category."
"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 SSIS is that it can handle real complex transformations."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The most important features are it works well and provides self-service BI."
"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."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It is easy to set up the product."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The Schema Registry service could be improved. I would like a bigger knowledge base of other use cases and more technical forums. It would be good to have more flexible monitoring features added to the next release as well."
"The formatting aspect within the page can be improved and more powerful."
"It could be more user-friendly and centralized. A way to reduce redundancy would be helpful."
"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."
"there is room for improvement in the visualization."
"There is a limitation when it comes to seamlessly importing Microsoft documents into Confluent pages, which can be inconvenient for users who frequently work with Microsoft Office tools and need to transition their content to Confluent."
"In Confluent, there could be a few more VPN options."
"Tuning using this solution requires extensive expertise to improve performance."
"I would like to see better integration with Power BI."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"The security could be improved, as it is more important in our context."
"Options for scaling could be improved."
"Future releases should improve the data lineage, as it currently is not good."
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.