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 design of the product is extremely well built and it is highly configurable."
"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 documentation process is fast with the tool."
"Implementing Confluent's schema registry has significantly enhanced our organization's data quality assurance."
"Kafka Connect framework is valuable for connecting to the various source systems where code doesn't need to be written."
"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 solution can handle a high volume of data because it works and scales well."
"It is also good for knowledge base management."
"The UI is very user-friendly."
"The initial setup of this solution is very straightforward."
"SSIS' best feature is SFTP connectivity."
"The setup is straightforward. It's very easy to install."
"Overall, it's a good product."
"The simplicity of the solution is great. The solution also offers excellent integration."
"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."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"In Confluent, there could be a few more VPN options."
"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."
"It could have more integration with different platforms."
"Confluent has a good monitoring tool, but it's not customizable."
"The pricing model should include the ability to pick features and be charged for them only."
"It could be improved by including a feature that automatically creates a new topic and puts failed messages."
"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."
"Confluence could improve the server version of the solution. However, most companies are going to the cloud."
"Future releases should improve the data lineage, as it currently is not good."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"At one point, we did have to purchase an add-on."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"The high prices attached to the product can be an area of concern where improvements are required."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
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.