Try our new research platform with insights from 80,000+ expert users

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

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Cloud Data Integration
3rd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
181
Ranking in other categories
Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (7th), 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
7.8
Number of Reviews
7
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Raj Sethupathi - PeerSpot reviewer
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.
Peeyush Chouksey - PeerSpot reviewer
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.

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 Axon is that it is flexible and user-friendly."
"The scalability is very high."
"Informatica is good for integrating data and cloud applications. We have connectors for integrating cloud applications like Salesforce. You can quickly integrate anything with an exposed API or a REST API. The industry is increasingly shifting to the cloud, so we need more products that can connect to cloud-based applications. The integration is seamless and works in real time. It's also secure because you don't need to expose databases or tables."
"We use parts and standardization for most of our testing. We purchase the US Postal Service address database, which is updated periodically. Many useful tools, such as Google Maps, can detect and mark new businesses or changes in business locations. Informatica captures and updates this information. Some periodic maintenance is involved, but setting it up is not overly complicated."
"One of the most valuable features is that I don't need to buy a subscription for any functionality. With Informatica Cloud Data Management, I have all the functionality and features available. If I need to make an integration, I can go to that integration service. If I need to mask, provide, or clean some information, I can easily just pick up that feature and use it. It's very simple, and I have all the functions and capabilities I need to work with data."
"The way that the solution scans is very useful."
"The most valuable features are the structure masking and platform masking."
"The fuzzy matching capability is a great feature."
"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."
"Having a single vendor supporting the entire suite of applications."
"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"It's on the cloud, so it's scalable and quite easy to work with."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"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

"We currently have issues with real-time integration."
"When it comes to UI look and feel and user experience, Informatica is not as good as other solutions."
"Informatica's support understands the solution, but they lack the experience we need for our use case. That was one thing that we prioritized when we started searching for this kind of solution."
"The solution should improve its integration."
"If I want to scan the metadata from the data lineage or the Python code, such areas can get tedious in the tool."
"Database access is highly restricted particularly if you're using the cloud version."
"The configurations could be better. It is a bit confusing because we must develop two tools when building a data model in Informatica MDM. Even though Informatica MDM is a single tool, we have our hub console plus the provisioning tool within that. Whatever data model we are building in the hub console, we have to develop it in the provisioning tool again. It is double the work to create a data model. We are also using external calls or the Java custom plans functions. This can be both positive and negative. Since MDM as a client does not support any complex validation, we have to depend on the external call or a Java call. Every time we deployed, the entire solution was impacted if something went wrong."
"Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them."
"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."
"I've found technical support not very effective. They should work to improve their services."
"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."
"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."
"Bulk uploading can be a problem when you hit the upper limit."
"This is an expensive solution compared to other products on the market."
 

Pricing and Cost Advice

"Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor."
"The solution's pricing model is easy, but it is very expensive."
"The pricing is high compared to other tools on the market."
"I rate the product's price a seven on a scale of one to ten, where one is the cheapest and ten is the most expensive. The product is a bit expensive."
"We saw an ROI. We have been able to get data from various sources and consolidate it into a data lake, which is helping us in data analytics."
"I have no idea what the price actually is. It is probably not going to be the cheapest, but it is a pretty stable and robust platform from the backend standpoint."
"Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful."
"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."
"The price is competitive compared to Boomi which is much higher."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Insurance Company
6%
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 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...
 

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
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Amplifon
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Oracle Data Integrator Cloud Service and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.