Informatica IDMC and Fivetran are leading competitors in the data management and integration category. While Informatica offers a wider range of enterprise data management features, Fivetran stands out for its simplicity and efficient data replication capabilities.
Features: Informatica IDMC integrates MDM, data quality, and data integration modules, offering golden record management, data cleansing, and deduplication features. It supports flexible architectures and domain management. Fivetran provides easy-to-use managed pipelines for data replication and integrates transformation tools like DBT, enabling robust ETL workflows without the need for additional tools.
Room for Improvement: Informatica IDMC users report integration and interface usability challenges, as well as limitations with SAP and data stewardship. Fivetran faces criticism for high pricing on large data volumes and limited customization options. Enhancements in data observability and reverse ETL capabilities could expand its data management offerings.
Ease of Deployment and Customer Service: Informatica IDMC supports on-premises, hybrid, and cloud deployments, offering flexibility but potential complexity. Its customer support is generally responsive but with some areas needing improvement. Fivetran's cloud deployment is quick and simple, while customer service receives varied reviews, being strong in ongoing support, though service quality can be inconsistent.
Pricing and ROI: Informatica IDMC is perceived as expensive due to its comprehensive features, yet customers find value in its enterprise-grade capabilities. Fivetran uses a consumption-based pricing model, which may become costly with high data usage but provides scalability and affordability for smaller operations. Both solutions deliver significant ROI through improved data management efficiencies.
It saves us the effort of having one to two data engineers managing the tasks that Fivetran handles.
The technical support provided by Fivetran has generally been good, with a response time and competence that I would rate as good.
The response time is pretty good because we have someone in-house, who is an expert from Informatica, in our team who can help us with any sort of queries usually.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
If they are unsure how to resolve an issue, they keep customers informed, providing updates about progress and ensuring communication with the product team to deliver accurate responses.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
During the duration of the time that we used Fivetran, it was highly stable.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
From a cost perspective, if the number of connectors is lesser, then Fivetran is not the most cost-efficient option.
Fivetran could improve by adapting more for technical users and by providing more options for such users.
I also want to see integration with other Informatica products, such as IICS, to leverage the metadata from EDC.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
The observability concept in Informatica Intelligent Data Management Cloud (IDMC) needs improvement as the capabilities are not up to the mark compared to the industry.
Our current yearly contract for Fivetran is approximately $70,000.
It ranges from a quarter million to a couple of million a year.
The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview.
I think the costs are reasonable for the kinds of features that Informatica Intelligent Data Management Cloud (IDMC) has.
The most valuable feature of Fivetran is its built-in connectors for a wide range of data sources.
The ability to seamlessly integrate with a large variety of data sources is valuable.
In on-premise, we call it EDC for metadata management, while in cloud-based technologies, it is known as the Metadata Command Center, which serves the same purpose as EDC concerning CDGC.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
Informatica Intelligent Data Management Cloud (IDMC) can connect to pretty much any application, including Oracle Analytics and Power BI, and it works quite seamlessly.
Fivetran, the global leader in data movement, is trusted by companies like OpenAI, LVMH, Pfizer, Verizon and Spotify to centralize data from SaaS applications, databases, files, and other sources into cloud destinations, including data lakes. With high-performance pipelines, seamless interoperability, and enterprise-grade security, Fivetran empowers organizations to modernize their data infrastructure, power analytics and AI, ensure compliance, and achieve transformative business outcomes. Learn more at Fivetran.com
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?
What benefits and ROI should be considered?
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.
We monitor all 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.
