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 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."
"We mostly use the solution's message queues and event-driven architecture."
"Their tech support is amazing; they are very good, both on and off-site."
"The solution can handle a high volume of data because it works and scales well."
"It is also good for knowledge base management."
"The client APIs are the most valuable feature."
"The monitoring module is impressive."
"Implementing Confluent's schema registry has significantly enhanced our organization's data quality assurance."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"It is easy to set up. The deployment is also very quick."
"Overall, it's a good product."
"The data reader is the most valuable feature."
"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."
"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."
"It would help if the knowledge based documents in the support portal could be available for public use as well."
"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."
"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."
"Areas for improvement include implementing multi-storage support to differentiate between database stores based on data age and optimizing storage costs."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"It would be nice if you could run SSIS on other environments besides Windows."
"I would like to see better technical documentation because many times information is missing."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"It needs more integration tools, so you can connect to different sources."
"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 solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
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.