Oracle Data Integrator and Informatica PowerCenter are both leading data integration products. Informatica PowerCenter often holds the upper hand due to its ease of use and comprehensive features that cater to complex ETL processes.
Features: Oracle Data Integrator provides automatic fault detection, real-time data integration, and flexibility through its Knowledge Modules. It processes data directly on the source or target system, which improves performance. Informatica PowerCenter offers robust ETL functionalities, strong transformation capabilities, and extensive connectivity options, making it ideal for big data sources and complex integration tasks.
Room for Improvement: Oracle Data Integrator users face challenges with mastering the tool and suggest enhancements in UI performance and error handling. Better integration with non-Oracle products and support for external version control are also needed. Informatica PowerCenter users wish for simplified transformations and streamlined cloud integration, as well as better documentation and tools for monitoring and automation.
Ease of Deployment and Customer Service: Oracle Data Integrator primarily offers on-premises deployment with some cloud capabilities. Customer service is generally good but can be slow for multi-technology issues. Informatica PowerCenter supports both on-premises and cloud deployments, with generally positive customer service reviews, though some note initial complexity and concerns over support responsiveness.
Pricing and ROI: Oracle Data Integrator is a mid-to-high cost solution with complex pricing that can be affordable for larger enterprises, with users noting an effective ROI from automation. Informatica PowerCenter, though expensive, justifies its cost with comprehensive features, being particularly valuable for large-scale applications. Licensing complexities are noted, but its potential high ROI makes it attractive to enterprises.
I like the technical support provided by Informatica.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
Informatica PowerCenter is stable and can scale well.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
The system supports real-time integration, which is essential for many of my tasks.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
Informatica PowerCenter is a data integration and data visualization tool. The solution works as an enterprise data integration platform that helps organizations access, transform, and integrate data from various systems. The product is designed to support companies in the full cycle of a project, from its initial rollout to critical deployments. Informatica PowerCenter allows developers and analysts to collaborate while accelerating the work process to deploy projects within days instead of months.
The Advanced edition of the product provides an additional real-time engine which allows companies to have always-on enterprise data integration. This ensures seamless collaboration and increment of data lineage visibility and impacts analysis.
The Premium edition of the solution offers an early warning system that detects unexpected behaviors or incorrect utilization of resources in the workflows and alerts companies in the case that these occur. This version of the product also offers automatic data validation, which ensures data accuracy and reduces testing time and expenditure of resources for by up to 90%.
Informatica PowerCenter Features
The product provides users with various features which allow them to execute data integration initiatives such as analytics, data warehousing, data governance, consolidation, and application migration. The features of the solution include:
Informatica PowerCenter Benefits
The benefits of using Informatica PowerCenter include:
Reviews from Real Users
Yahya T., a developer and architect at L'Oreal, says the product is stable, provides good support, and integrating it with other systems is very fast.
Mohamed E., a senior manager for Data management and data governance at a tech company, says PowerCenter is stable, mature, and offers flexibility in building the pipeline and has a drag-and-drop mode because it's GUI-based; technical support is brilliant.
Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.
Oracle Data Integrator Features
ODI has many valuable key features. Some of the most useful ones include:
Oracle Data Integrator Benefits
There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:
Reviews from Real Users
Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.
Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”
Ashok S., Applications Support Manager at a marketing services firm, mentions, "The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
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.