Informatica Intelligent Data Management Cloud (IDMC) and AWS Database Migration Service are two solutions competing in the data management and migration space. IDMC seems to have the upper hand due to its comprehensive data management approach and robust features.
Features: IDMC offers comprehensive data management with seamless integration of data quality modules, flexible architecture accommodating multiple domains, and valuable features like data profiling and integration flexibility. AWS Database Migration Service focuses on database connectivity and replication, providing robust migration capabilities and cloud integration, making it suitable for database migration tasks.
Room for Improvement: IDMC's interface and data stewardship functionalities need enhancements, and challenges with SAP integration and workflow optimization have been reported. AWS Database Migration Service could benefit from improved operational transparency, reduced migration complexity, and better cost governance and support options for non-AWS environments.
Ease of Deployment and Customer Service: IDMC supports a range of deployment options, including on-premises and hybrid solutions, offering well-regarded customer service with detailed support. AWS Database Migration Service provides speedy cloud-based deployments and average customer service compared to Informatica's more robust support.
Pricing and ROI: IDMC is considered expensive, but its extensive features justify the cost and offer flexible pricing options. It provides substantial ROI through enhanced data quality and governance. AWS Database Migration Service is cheaper, offering cost-effective database migration solutions, though the ROI may not be immediately evident due to potential additional maintenance costs.
I can specify savings of around 40 to 60%.
We see return on investment from this solution in terms of time; time reduction or cost benefits is what we are getting very good results from.
When working with AWS GovCloud, we often did not get an answer in time because AWS seemed more focused on the commercial side.
I am happy with the technical support from AWS.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
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.
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.
Even if there was a failure, we could catch it and rerun it.
AWS's scalable nature involves a human approach, meaning it is not auto-scalable.
While scalability is good, latency exists due to our business nature.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
I find Informatica Intelligent Data Management Cloud (IDMC) to be a sustainable and scalable solution.
For DMS version upgrades, we schedule downtime during business hours so that midnight workloads are not interrupted and morning business can run smoothly.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
DMS works within AWS ecosystem, but they also have to look for third party solutions. Now Snowflake is a bigger player, or Databricks.
Sometimes, those who implement the service face problems and resolve it, but I may not even know what problems they faced.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
I also want to see integration with other Informatica products, such as IICS, to leverage the metadata from EDC.
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.
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.
AWS offers a way to build jobs that are scalable, expandable for new and current tables, and can be deployed quickly.
You can copy the database at first without impacting your current database, and then use CDC to copy incremental changes.
The scalability option is another valuable feature because AWS provides its own compute behind it, so I can scale up and scale down at any given point.
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.
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.
Product | Market Share (%) |
---|---|
AWS Database Migration Service | 13.4% |
Informatica Intelligent Data Management Cloud (IDMC) | 5.4% |
Other | 81.2% |
Company Size | Count |
---|---|
Small Business | 8 |
Midsize Enterprise | 8 |
Large Enterprise | 17 |
Company Size | Count |
---|---|
Small Business | 42 |
Midsize Enterprise | 24 |
Large Enterprise | 134 |
AWS Database Migration Service, also known as AWS DMS, is a cloud service that facilitates the migration of relational databases, NoSQL databases, data warehouses, and other types of data stores. The product can be used to migrate users' data into the AWS Cloud or between combinations of on-premises and cloud setups. The solution allows migration between a wide variety of sources and target endpoints; the only requirement is that one of the endpoints has to be an AWS service. AWS DMS cannot be used to migrate from an on-premises database to another on-premises database.
AWS Database Migration Service allows users to perform one-time migrations, as well as replications of ongoing changes to keep sources and targets in sync. Organizations can utilize the AWS Schema Conversion Tool to translate their database schema to a new platform and then use AWS DMS to migrate the data. The product offers cost efficiency as a part of the AWS Cloud, as well as speed to market, flexibility, and security.
The main use cases of AWS Database Migration Service include:
AWS Database Migration Service Components
AWS Database Migration Service consists of various components which function together to achieve users’ data migration. A migration on AWS DMS is structured in three levels: a replication instance, source and target endpoints, and a replication task. The components include the following actions:
AWS Database Migration Service Benefits
AWS Database Migration Service offers its users a wide range of benefits. Among them are the following:
Reviews from Real Users
Vishal S., an infrastructure lead at a computer software company, likes AWS Database Migration Service because it is easy to use and set up.
Vinod K., a data analyst at AIMLEAP, describes AWS DMS as an easy solution to save and extract data.
Informatica Intelligent Data Management Cloud (IDMC) integrates data quality, governance, and integration with flexible architecture. It supports multiple domains and a data models repository, delivering AI-enhanced data management across cloud-native platforms.
IDMC provides seamless integration and governance capabilities that support diverse data environments. Its comprehensive suite includes customizable workflows, data profiling, and metadata management. AI features, a data marketplace, and performance scalability enhance data management. While its interface poses challenges, its robust matching and cloud-native integration facilities are essential for complex data ecosystems. Users employ IDMC for connecting systems, ensuring data quality, and supporting data compliance but seek better pre-built rules, services, and improved connectivity, especially with platforms like Salesforce. Licensing, cost, and added AI functionalities are areas for potential refinement.
What are the key features of IDMC?IDMC is implemented across industries for data integration, metadata management, and governance. Organizations use it to connect systems, migrate data to cloud environments, and maintain data quality. They manage master data and automate business processes, facilitating data lineage and ensuring compliance with privacy regulations.
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.