We performed a comparison between SSIS and Talend Data integration based on real PeerSpot user reviews.Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
"The performance is good."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"SSIS is easy to use."
"SSIS' best feature is SFTP connectivity."
"The solution is stable."
"It is easy to set up the solution."
"The performance and stability are good."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"We have multiple use cases for this solution. We integrate with Salesforce, SAP and Oracle databases to build business logic and provide reporting."
"I'm very passionate about this solution because if you look at any other tool that costs around $200 - $300,000, like Delphix which costs you a million dollars, Talend is very cheap and is almost is at par with what others can do. There is one thing which Delphix does which Talend cannot do, but overall, I would say apart from that, if you're looking for a solution, you should give it a try."
"The product's integration with PostgreSQL and Jira has been helpful for us. Its performance is good. However, we do not use it for large data sets."
"Talend Data integration has a wide library of connectors."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"I would like to see better technical documentation because many times information is missing."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"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."
"The performance of this solution is not as good as other tools in the market."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"It would be nice if you could run SSIS on other environments besides Windows."
"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."
"The tool's technical support needs to be better. It doesn't have a local data center but pushes everything to the cloud. They need to check in with customers to see if they're happy and how well the solutions work. They need to assign a customer success manager for the accounts they sell."
"Due to using the open-source version of Talend Data Integration, which lacks a scheduler, our current approach involves developing jobs in Talend, exporting them as Java packages, and utilizing an external scheduler, such as Windows Scheduler, to manage the scheduling process."
"Sometimes there are bugs which are unidentified and we have to follow-up with the Talend team to resolve them. In a critical situation, it takes time for them to update patches."
"There are no concurrent licenses, they only have seat licenses on cloud. That's the whole challenge. For example, if in any project your headcount increases or decreases, you do not have that concurrence and you have a seat license, you run into challenges because you have to procure a few more licenses for getting the job done."
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
Talend Data Integration is a powerful solution that enables integration with various databases, including Salesforce, SAP, and Oracle, to build business logic and provide reporting. It offers TMC (for creating sub-admins, which are useful for organizations with multiple applications using Talend), profiling, and project creation. The cloud solution also provides automated upgrades, while on-premises solutions require manual upgrades.
Talend Cloud Integration has helped organizations by allowing teams to use remote engine concept on AWS, spin up their job servers, process their own data on the cloud, and seamlessly integrate cloud-to-cloud environments.
SSIS is ranked 2nd in Data Integration with 33 reviews while Talend Data integration is ranked 24th in Cloud Data Integration with 3 reviews. SSIS is rated 7.6, while Talend Data integration is rated 8.0. The top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". On the other hand, the top reviewer of Talend Data integration writes "Data integration solution that assists with integration with Salesforce, SAP and Oracle". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue, whereas Talend Data integration is most compared with Talend Open Studio, SAP Cloud Platform, Microsoft Azure Logic Apps, AWS Glue and Oracle Data Integrator (ODI). See our SSIS vs. Talend Data integration report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration 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.