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."The most valuable is its capability to enhance the documentation process, particularly when creating software documentation."
"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."
"Implementing Confluent's schema registry has significantly enhanced our organization's data quality assurance."
"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."
"The monitoring module is impressive."
"We mostly use the solution's message queues and event-driven architecture."
"The documentation process is fast with the tool."
"Kafka Connect framework is valuable for connecting to the various source systems where code doesn't need to be written."
"SSIS' most valuable feature is its reporting services."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"It is easy to set up the solution."
"The interface is very user-friendly."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The performance is good."
"Overall, it's a good product."
"The UI is very user-friendly."
"The pricing model should include the ability to pick features and be charged for them only."
"Currently, in the early stages, I see a gap on the security side. If you are using the SaaS version, we would like to get a fuller, more secure solution that can be adopted right out of the box. Confluence could do a better job sharing best practices or a reusable pattern that others have used, especially for companies that can not afford to hire professional services from Confluent."
"They should remove Zookeeper because of security issues."
"Confluence could improve the server version of the solution. However, most companies are going to the cloud."
"Areas for improvement include implementing multi-storage support to differentiate between database stores based on data age and optimizing storage costs."
"It could be improved by including a feature that automatically creates a new topic and puts failed messages."
"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."
"Confluent's price needs improvement."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"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."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"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."
"It would be nice if you could run SSIS on other environments besides Windows."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
Confluent is ranked 4th in Streaming Analytics with 19 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.