Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Data Integrator Cloud Service comparison

Informatica Intelligent Data Management Cloud (IDMC) vs. Oracle Data Integrator Cloud Service

Download the complete report

Helped 824,067 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)

Oracle Data Integrator Clou...

Ranking in Cloud Data Integration

23rd

Average Rating

8.0

Reviews Sentiment

6.9

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

Peeyush Chouksey

Associate Manager at Accenture

Allows us to integrate different cloud services with different applications

It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot. When it comes to mapping, you are quite restricted. If you have to use a specific, typical function, you need to do a Java callout or something. OSB has a lot of features they are using like Java APIs because it's on-premises.

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 feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server."

"I give the stability a ten out of ten."

"I am impressed by the solution's interface."

"Informatica Data Quality is a product that is worth the money."

"The most valuable features of Informatica MDM are its reliability, match functions, and integration capabilities. The out-of-box functionality of deduplication and built-in data models ensure faster implementation."

"I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."

"Multifeatured and easily scalable data catalog, with good data domain discovery and data profiling features."

"The solution's most valuable features are its data quality, match-merge engine, and CLAIRE AI engine, which helps with AI automation."

More Informatica Intelligent Data Management Cloud (IDMC) pros

"The solution is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and pick the day and time to do so."

"Oracle integration cloud has got the adapters for all their products, which makes integration faster."

"It's on the cloud, so it's scalable and quite easy to work with."

"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."

"Having a single vendor supporting the entire suite of applications."

"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."

"The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration."

Cons

"There are some limitations with Informatica Axon when one tries to connect or integrate it with Jira."

"The product interface could be improved to be more intuitive."

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

"The stability and the integration of the solution have room for improvement."

"They could improve technical support because it is not good enough at the moment."

"The advertising makes promises about data analytics that it does not keep."

"Informatica Axon does not provide complete transparency about the level of detailing you need and the logic used in ETL."

"It is more complicated to extract data using the product compared to Visio. The system could display the details on the screen."

More Informatica Intelligent Data Management Cloud (IDMC) cons

"Bulk uploading can be a problem when you hit the upper limit."

"I've found technical support not very effective. They should work to improve their services."

"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."

"The pricing could be more competitive."

"It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process straightforward."

"This is an expensive solution compared to other products on the market."

"I would like to see different cloud adapters or connectors in case of integration. When you have Oracle to Oracle, they are good. They have really good connectors, but if it is a different ERP, like Obsidian, that is where they are faced with problems in OIC."

Pricing and Cost Advice

"The price is neither too high nor too low."

"It is cost effective and an easily accessible tool."

"Informatica is very expensive."

"Informatica Axon is expensive."

"Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well."

"Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality."

"It is an expensive solution. I would say it is the most expensive solution in the market."

"It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there."

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

"The price is competitive compared to Boomi which is much higher."

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

824,067 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

No data available

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

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

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

What do you like most about Oracle Data Integrator Cloud Service?

The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process.

What is your experience regarding pricing and costs for Oracle Data Integrator Cloud Service?

The price is competitive compared to Boomi which is much higher.

What needs improvement with Oracle Data Integrator Cloud Service?

It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process str...

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Comparisons

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

No data available

Product Reports

Informatica Intelligent Data Management Cloud (IDMC)

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Informatica Intelligent Data Management Cloud (IDMC) report

Oracle Data Integrator Cloud Service

Download Oracle Data Integrator Cloud Service product report

Oracle Data Integrator Cloud Service 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

No data available

Learn More

Informatica

Oracle

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.

Oracle Data Integrator Cloud Service provides pushdown data processing; high performance ETL with less data movement which is best for the Cloud. Oracle Data Integrator Cloud Service executes data transformations where the data lies without having to copy data unnecessarily to remote locations.

Sample Customers

The Travel Company, Carbonite

Amplifon

Informatica Intelligent Data Management Cloud (IDMC) vs. Oracle Data Integrator Cloud Service