We performed a comparison between JumpMind SymmetricDS, SSIS, and Talend Open Studio based on real PeerSpot user reviews.
Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication."It is fully featured. It has allowed me to do everything I wanted to do."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The scalability of SSIS is good."
"SSIS' most valuable feature is its reporting services."
"The interface is very user-friendly."
"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 initial setup of this solution is very straightforward."
"The most important features are it works well and provides self-service BI."
"The standout feature for me is the user-friendly nature of the components."
"We have contacted their technical support. They are great. They offer very professional help. If I need some technical answer, they are very professional. They are quick, professional, and very accurate."
"We're sold on the customization part of the solution."
"This solution has improved our overall time to value for data ingestion."
"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement."
"The rapidity of integration with data may be one of the valuable features."
"You can use Talend as a stand-alone application without customization to collect data and generate reports over dashboards. It's got great functionality."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"It would be nice if you could run SSIS on other environments besides Windows."
"At one point, we did have to purchase an add-on."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"I would say that writing to JSON is kind of a pain. It reads from a JSON file pretty well, but writing to a JSON file is not so great because its components are not good."
"The documentation is lacking within the product. They need to get better at all aspects of describing how it works and how to use it."
"In terms of features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM."
"It needs better installation configuration for other databases. Although the installation allows you to select another database, this doesn't mean that all connection points in the application point to the database selected. You actually need to do a search through the entire install to locate the configuration settings and change them."
"The physical appearance of the product is an area of concern where improvements are required."
"We don't get continuous replication of the data."
"The security features could be improved."
"Talend Open Studio's interface does not provide a good experience...I would like to see better documentation and a more enhanced graphical interface in Talend Open Studio."