We performed a comparison between Informatica PowerExchange and Matillion ETL 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 transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The data transformation is the solution's most valuable feature."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"This product is easy to install and it can be done in a few hours."
"The user interface and user experience are perfectly all right."
"The most valuable feature is connectivity to data sources."
"It is easy to integrate the solution with other tools."
"Mainstream integration and real-time integration are the best features."
"It is pretty user-friendly, even for people who aren't super technical."
"The product's initial setup phase was easy."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"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 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."
"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."
"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."
"Technical support can be improved with respect to delays in ticket response time."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
"The product is not suitable for application integration."
"The product's high costs can be an area of concern where improvements are required."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"Pushdown optimization could be improved."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"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."
"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."
"In the next release, we would like to have connections to more databases."
"The product must enhance its near-real-time data capture feature."
"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."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"The tool's lineage is very weak."
Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. Informatica PowerExchange is rated 7.8, while Matillion ETL is rated 8.6. The top reviewer of Informatica PowerExchange writes "Comprehensive, capable of handling large volumes, and helpful for fast-paced movement of data". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Qlik Replicate, Azure Data Factory and Informatica Cloud Data Integration, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, Informatica PowerCenter and SSIS. See our Informatica PowerExchange vs. Matillion ETL 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.