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 technical support is very good."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The UI is very user-friendly."
"It is easy to set up. The deployment is also very quick."
"The most important features are it works well and provides self-service BI."
"It's a competent product."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"A helpful feature for us is the integration with NoSQL databases."
"A very user friendly solution."
"The standout feature for me is the user-friendly nature of the components."
"It's a good tool. It has the ability to take apart and install whatever we need. It's very good for data, transformation, and loading."
"Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement."
"The data integration aspect of the solution is excellent."
"Talend Studio has the ability to use it to ensure data quality."
"The product's initial setup phase was easy."
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"Video training would be a helpful addition."
"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."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"I would like to see more features in terms of the integration with Azure Data Factory."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"The high prices attached to the product can be an area of concern where improvements are required."
"We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features."
"The price for Talend Data Integration should be less expensive."
"We don't get continuous replication of the data."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"It gets the job done but it's a bit slow."
"The solution should offer better integration with other products."
"The solution needs more integrations."
"The profiling perspective needs improvement. Instead of using it in the studio, we are using a different tool which is also provided by Talend. It's redundant."