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."
"The documentation process is fast with the tool."
"Confluence's greatest asset is its user-friendly interface, coupled with its remarkable ability to seamlessly integrate with a vast range of other solutions."
"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."
"Kafka Connect framework is valuable for connecting to the various source systems where code doesn't need to be written."
"The most valuable is its capability to enhance the documentation process, particularly when creating software documentation."
"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."
"One of the best features of Confluent is that it's very easy to search and have a live status with Jira."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"It is easy to set up. The deployment is also very quick."
"It is easy to set up the solution."
"The scalability of SSIS is good."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The solution is easy to use and developer friendly."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It's a competent product."
"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."
"It could have more integration with different platforms."
"It would help if the knowledge based documents in the support portal could be available for public use as well."
"Confluent's price needs improvement."
"Areas for improvement include implementing multi-storage support to differentiate between database stores based on data age and optimizing storage costs."
"There is no local support team in Saudi Arabia."
"The pricing model should include the ability to pick features and be charged for them only."
"The product should integrate tools for incorporating diagrams like Lucidchart. It also needs to improve its formatting features. We also faced issues while granting permissions."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"It hangs a lot of the time."
"Tuning using this solution requires extensive expertise to improve performance."
"I would like to see better integration with Power BI."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"The creation of the measure in the DAC's model could be improved."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
Confluent is ranked 4th in Streaming Analytics with 20 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.