We performed a comparison between Informatica Cloud Data Integration, Matillion ETL, and Talend Open Studio based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."
"The serverless capability and the packaging application of the solution are valuable."
"The product is scalable and excellent for enterprise-level organizations."
"It has a more UI-based tool, and the scripting is good."
"It has become an easy way to exchange information through any cloud application."
"It is one of the best tools available for data integration."
"It is quite easy to use and flexible."
"Data synchronization tasks."
"It is pretty user-friendly, even for people who aren't super technical."
"The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"It has good integrations with Amazon Redshift and other AWS services."
"There are many architectures: hybrid, cloud, and on-prem."
"We're sold on the customization part of the solution."
"Talend Studio has the ability to use it to ensure data quality."
"Talend is safe to use because it is very restrictive. It is easy to use when one learns how to manipulate data with SQL."
"The main differentiator that I have seen between Talend and other data integration tools is the ability to view the data pipeline in the form of a program."
"The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."
"The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB."
"The initial setup was quite straightforward. The deployment took between two and three days."
"The cloud version could be better in terms of pricing."
"The biggest challenge I see is the IDE's for the cloud and automization are different."
"We would like to have accessibility to the repository."
"There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another."
"Cost-wise, it could be better."
"The error information provided is not informative, as compared to Power Center."
"The integration process is not easy."
"It would be helpful if there was a GenAI feature integrated into the system, especially regarding the data quality."
"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"The product must enhance its near-real-time data capture feature."
"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."
"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."
"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."
"Multiple products are there within the product suite. That can be actually trimmed down."
"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."
"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 server-side should be completely revamped."
"Talend Open Studio has a lot of capabilities, but there is some restriction. For example, if we want to connect to an SAP system, Open Studio cannot do it. We need to go with an enterprise version. Additionally, the monitoring features could improve."
"In the next release, Open Studio should include cloud storage as an input."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
More Informatica Cloud Data Integration Pricing and Cost Advice →