Informatica Intelligent Data Management Cloud (IDMC) vs Matillion ETL comparison

Informatica and Matillion are both solutions in the Cloud Data Integration category. Informatica is ranked #3 with an average rating of 7.8, while Matillion is ranked #5 with an average rating of 8.4. Additionally, 93% of Informatica users are willing to recommend the solution, compared to 96% of Matillion users who would recommend it.

Informatica Intelligent Dat...

Read 181 Informatica Intelligent Data Management Cloud (IDMC) reviews

4,204 Views
3,058 Comparison Views

93% willing to recommend

Matillion ETL

Read 26 Matillion ETL reviews

2,014 Views
1,412 Comparison Views

96% willing to recommend

Informatica Intelligent Dat...

Matillion ETL

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 3, 2024

Informatica IDMC and Matillion ETL compete in the data integration and management solutions category. Based on the features and user feedback, Informatica IDMC seems to have an edge due to its comprehensive data management capabilities and versatility, although Matillion ETL shines in rapid deployment and ease of use.

Features: Informatica IDMC offers seamless integration, robust data management, and a flexible architecture supporting multiple domains. Users appreciate its improved interface and the Match-and-Merge feature. Matillion ETL excels with its integration with AWS services, built-in verification, and Python components. Its graphical interface and rapid deployment are praised, especially for data extraction and integration.

Room for Improvement: Informatica IDMC could enhance its interface and reporting capabilities. Users suggest improvements in application integration and data handling features. Challenges with error reporting and region-specific performance are noted. Matillion ETL requires better scalability and integration capabilities. Users need improved real-time data streaming, customizability, and more stable API updates to handle concurrent workloads.

Ease of Deployment and Customer Service: Informatica IDMC supports diverse deployment environments, including on-premises, hybrid, and cloud, but its complex setup affects issue resolution times despite knowledgeable support staff. Matillion ETL offers smooth deployment on the public cloud, especially through AWS. Users report excellent customer service, with prompt and effective assistance enhancing its user experience.

Pricing and ROI: Informatica IDMC has a high price point but offers significant ROI through enhanced data management and operational efficiency. Its pricing model is variable and negotiable based on data volume. Matillion ETL's pay-as-you-go model is cost-effective for cloud deployments via AWS Marketplace, making it suitable for smaller teams with its flexible pricing based on running hours.

To learn more, read our detailed Informatica Intelligent Data Management Cloud (IDMC) vs. Matillion ETL Report (Updated: December 2024).

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC) vs. Matillion ETL

December 2024

Download the complete report

Helped 823,875 peers since 2012

Categories and Ranking

Informatica Intelligent Dat...

Ranking in Cloud Data Integration

3rd

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

181

Ranking in other categories

Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (6th), Business-to-Business Middleware (3rd), API Management (7th), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (4th), Product Information Management (PIM) (1st), Data Observability (2nd)

Matillion ETL

Ranking in Cloud Data Integration

5th

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

No ranking in other categories

Featured Reviews

Raj Sethupathi

Data Integration Consultant GCP/AWS at Infogrators Inc

Offers profiling and address standardization but can be complicated

Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.

Read full review

AntonHaupt

Data Architect at Capitec

Efficient data integration and transformation with seamless cloud-native integration

In our small business unit, we currently have around four users, with two of them utilizing Matillion within our organization. Considering our growing needs, we're contemplating transitioning to an enterprise SaaS solution where we would share the same instance. Currently, each user is billed individually, but consolidating to a shared instance seems more efficient. Scalability is excellent when using the SaaS solution, easily reaching a rating of ten out of ten. Each data pipeline request is encapsulated within a Docker container and spun off, allowing for instant scalability. Overall, I would rate it a nine out of ten in terms of performance and scalability.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services."

"The technical support services are good."

"Informatica provides a comprehensive solution for on-the-fly or real-time data masking."

"MDM doesn't require a separate IDQ."

"The most valuable feature is the building of mockups and tasks."

"The Provisioning tool is something that is really handy for everyone. It is my pick as the best feature."

"It has all the advantages of the Cloud in that you can use it without worrying about infrastructure, upkeep, or upgrades."

"Axon does one interesting thing that I don't think other tools do as well. It lets you rate data and incorporates Informatica's data quality feature into it. There are little indications and graphics that show you how good the data quality is, and you can drill into it to see where potential issues lie."

More Informatica Intelligent Data Management Cloud (IDMC) pros

"The product has a good user interface."

"The solution's most valuable feature is the CDC (Change Data Capture) component."

"It is pretty user-friendly, even for people who aren't super technical."

"The most valuable feature of Matillion ETL is its user-friendly graphical interface."

"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."

"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."

"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's highly scalable. It takes upon itself the Redshift scalability, so it's very good."

More Matillion ETL pros

Cons

"New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."

"I would also like to have profiling functionalities and quality transformations in the cloud."

"I have encountered some issues using the substitution, which is one of the techniques of data masking."

"Informatica Cloud Data Integration could improve the price by making it less expensive."

"I think everything related to the APIs and the manageability of the APIs in Informatica MDM are areas where improvements are required."

"Certain applications are not being synced with the ION."

"Permissions, scalability, and connection with other informatic tools are the main areas that need development. Integration with other tools, such as IDQ, is challenging. The management of data discovery is highly challenging because many data points have identical definitions."

"Cost-wise, it could be better."

More Informatica Intelligent Data Management Cloud (IDMC) cons

"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."

"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."

"While the UI is good, it could be improved in its efficiency and made easier to use."

"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."

"Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems."

"Matillion’s on-premises capabilities don’t allow you to build something customized."

"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."

"The product's scalability needs improvement. Perhaps adding more connectors would be beneficial."

More Matillion ETL cons

Pricing and Cost Advice

"We got a 50% discount."

"The pricing structure is good, but having to pay for extra drivers to be used in an ICS environment makes me a little nervous."

"I rate the licensing cost of Informatica MDM a five out of ten."

"The product is highly-priced."

"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing nine and a half out of ten."

"I rate Informatica MDM's price a six on a scale of one to ten, where one is a low price, and ten is a high price."

"Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor."

"A yearly subscription is paid based on the number of people using the solution. Price-wise, it falls under the medium range since it is neither very costly nor too cheap."

More Informatica Intelligent Data Management Cloud (IDMC) pricing and cost advice

"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."

"The cost of the solution is high and could be reduced."

"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."

"Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."

"A rough estimation of the cost is around 20,000 dollars a month, however, this is dependent on the machine used and how Matillion ETL is used."

"I think it is cost conscious. It used to be very cheap and they have more recently bumped up the pricing, so it is competitive now."

"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."

"The product must improve its pricing."

More Matillion ETL pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

823,875 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

12%

Manufacturing Company

10%

Government

Financial Services Firm

16%

Computer Software Company

14%

Manufacturing Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How does Azure Data Factory compare with Informatica Cloud Data Integration?

Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...

See all answers

Which Informatica product would you choose - PowerCenter or Cloud Data Integration?

Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...

See all answers

What are the biggest benefits of using Informatica Cloud Data Integration?

When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...

See all answers

What do you like most about Matillion ETL?

The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.

See all answers

What is your experience regarding pricing and costs for Matillion ETL?

The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...

See all answers

What needs improvement with Matillion ETL?

Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.

See all answers

Comparisons

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 8% of the time

Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 7% of the time

Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 5% of the time

Microsoft Purview Data Governance vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

AWS Glue vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

Azure Data Factory vs Matillion ETL

Compared 13% of the time

SSIS vs Matillion ETL

Compared 9% of the time

AWS Glue vs Matillion ETL

Compared 9% of the time

Snowflake vs Matillion ETL

Compared 7% of the time

Boomi iPaaS vs Matillion ETL

Compared 3% of the time

More Matillion ETL Competitors

Product Reports

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC)

December 2024

Informatica Intelligent Data Management Cloud (IDMC) report

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Buyer's Guide

Matillion ETL

November 2024

Download Matillion ETL product report

Also Known As

ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery

Learn More

Informatica

Matillion

Overview

Informatica Intelligent Data Management Cloud (IDMC) is a robust platform used by banks, financial institutions, and health sector organizations for data management, governance, and compliance.

IDMC provides comprehensive tools for data discovery, profiling, masking, and transformation. It supports Salesforce integration, real-time data streaming, and scalable data management solutions. Health organizations manage national product catalogs while financial entities focus on data protection and regulatory compliance. Its intuitive interface, flexible features, and robust tools make it valuable across sectors, though enhancements in data integration and human workflow are being sought.

What are the most important features?

Data discovery: Facilitates identifying and understanding data sources.
Data profiling: Analyzes old databases for data quality.
Data and platform masking: Ensures data protection.
Salesforce integration: Seamless connectivity with Salesforce.
Mastering data: Centralizing and standardizing data.
UI intuitiveness: User-friendly interface.
Feature map flexibility: Adapts to user needs.
Business glossary creation: Defines business terms.
Data lineage: Tracks data flow and transformations.
Automation: Streamlines data processes.
Enterprise data cataloging: Organizes extensive data assets.
Scalability: Supports expanding data requirements.
Easy setup: Quick deployment process.
Bulk upload: Efficiently handles large data volumes.
Customizable data management: Tailors data solutions.
Real-time data streaming: Manages live data streams.
Integration with Hadoop and NoSQL: Connects with big data platforms.

What benefits and ROI should be considered?

Regulatory compliance: Ensures adherence to regulations.
Data protection: Safeguards sensitive information.
Enhanced data quality: Improves accuracy and reliability.
Centralized data: Consolidates data for better management.
Process automation: Reduces manual tasks and errors.

Banks and financial institutions use IDMC for data masking, transformation, and compliance, while health sector organizations leverage it for national product catalogs. Industry applications focus on automating business processes, centralizing data, and managing data catalogs to meet regulatory demands and ensure data protection.

Matillion ETL is a powerful tool for extracting, transforming, and loading large amounts of data from various sources into cloud data warehouses like Snowflake. Its ability to load data dynamically and efficiently using metadata is a standout feature, as is its open-source ETL with good performance and high efficiency.

The solution has a graphical interface for jobs, is easily adjustable and extensible, and allows for scheduling and error reporting. Matillion ETL has helped organizations move to a cloud-based solution, bridge the gap between on-premises and on-cloud, and perform complex migration projects.

Sample Customers

The Travel Company, Carbonite

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc

Buyer's Guide

Informatica Intelligent Data Management Cloud (IDMC) vs. Matillion ETL

December 2024

Free Report: Informatica Intelligent Data Management Cloud (IDMC) vs. Matillion ETL

Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Matillion ETL and other solutions. Updated: December 2024.

DOWNLOAD NOW

823,875 professionals have used our research since 2012.

See our Informatica Intelligent Data Management Cloud (IDMC) 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.