We performed a comparison between JumpMind SymmetricDS and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Replication solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is fully featured. It has allowed me to do everything I wanted to do."
"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 product."
"The performance is good."
"It is easy to set up. The deployment is also very quick."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It's saved time using visualization descriptions."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"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's a legacy tool, that is nearing the end of its useful life."
"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."
"Improvement as per customer requirements."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
JumpMind SymmetricDS is ranked 13th in Data Replication while SSIS is ranked 2nd in Data Integration with 69 reviews. JumpMind SymmetricDS is rated 9.0, while SSIS is rated 7.6. The top reviewer of JumpMind SymmetricDS writes "Excellent change data capture utility for distributed multi site environment". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". JumpMind SymmetricDS is most compared with Oracle GoldenGate, AWS Database Migration Service, Confluent, Qlik Replicate and Azure Data Factory, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our JumpMind SymmetricDS vs. SSIS report.
We monitor all Data Replication 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.