We performed a comparison between Informatica PowerCenter 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 product's initial setup phase is very easy."
"The most valuable features are the metadata repository and the data warehouse application console."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"Can manage a huge quantity of data and provide reliability."
"The setup is very simple."
"We have found the PowerCenter and B2B data transformation most valuable."
"The interface is very clean and clear."
"I found the map links, work links, and workflows valuable. They are important features."
"The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources."
"It has improved the costs of managing my customer’s data."
"The loading of data is the most valuable feature of Matillion ETL."
"It is pretty user-friendly, even for people who aren't super technical."
"It's been able to do everything we require."
"It has helped us to get onto the cloud quickly."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Support could be better."
"The solution does not scale."
"I would like to see an improvement in the digital adoption."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"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."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"The tool's lineage is very weak."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"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."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. Informatica PowerCenter is rated 8.0, while Matillion ETL is rated 8.6. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Oracle GoldenGate, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, SSIS and Informatica Cloud Data Integration. See our Informatica PowerCenter 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.