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."A person with a good IT background and HTML will not have any trouble with Confluent."
"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 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."
"The documentation process is fast with the tool."
"The monitoring module is impressive."
"Kafka Connect framework is valuable for connecting to the various source systems where code doesn't need to be written."
"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."
"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."
"It is easy to set up the product."
"It is easy to set up. The deployment is also very quick."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"SSIS' best feature is SFTP connectivity."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"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's a competent product."
"It could be improved by including a feature that automatically creates a new topic and puts failed messages."
"Confluent has a good monitoring tool, but it's not customizable."
"Confluent's price needs improvement."
"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."
"there is room for improvement in the visualization."
"There is no local support team in Saudi Arabia."
"Confluence could improve the server version of the solution. However, most companies are going to the cloud."
"It could have more integration with different platforms."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Improvement as per customer requirements."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"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."
"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."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
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.