![Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_64/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACAGSGT)
Oracle Data Integrator and Informatica PowerExchange are prominent data integration solutions, offering unique feature sets. ODI is often favored for its flexibility and integration capabilities, while PowerExchange is recognized for real-time data processing and robust support for legacy systems.
Features: ODI stands out for its ELT capabilities, using source or target database power to avoid additional servers. Its Knowledge Module feature allows users to customize integration strategies, which increases adaptability in processing diverse data sources. Informatica PowerExchange excels in real-time data processing and change data capture, ensuring seamless interaction with non-Oracle systems. It is especially effective for integrating data from legacy systems and operational hubs.
Room for Improvement: ODI users suggest improvements in its error handling, user interface, and version control integration. Simplifying multi-user setups would also enhance its usability. For PowerExchange, users see potential in improving pricing strategies, performance with large datasets, and support service effectiveness.
Ease of Deployment and Customer Service: ODI is adaptable to on-premises, public, and hybrid cloud environments, offering varied deployment options. However, user feedback on support experiences is mixed, indicating some inconsistencies. PowerExchange focuses on on-premises and hybrid deployments, with user-reported comprehensive on-premises support. Customer service is deemed adequate but faces challenges regarding pricing and capacity management.
Pricing and ROI: ODI's pricing model involves multiple licensing options, which may prove complex for smaller companies but can yield significant returns when optimized. Informatica PowerExchange offers a straightforward per-capacity pricing model, though considered expensive due to processing power needs. Both tools reportedly deliver good return on investment through effective implementation, leveraging automation and reducing operational overhead.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
Their support aligns with what I have experienced with Informatica data quality teams, and it is quite effective.
Informatica's technical support team is very supportive and provides help whenever required.
The support was good enough, and they were able to resolve all the issues I raised in the past.
The technical support of Oracle is very good; they support the Oracle Data Integrator (ODI) solution effectively.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
In terms of performance stability, I have not experienced any downtimes, crashes, or performance issues with the Oracle Data Integrator (ODI).
The addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data.
Integrating AI with ODI that provides recommendations on how to fix those data quality issues after analyzing and profiling business data would be excellent.
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.
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
The pricing aspect of Oracle Data Integrator (ODI) is reasonable; it brings significant value to the table.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
It also reduces the number of APIs needed for new integrations by offering a unified exchange platform.
The primary advantage of Informatica PowerExchange is being able to extract data from source systems that Informatica does not natively support.
PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products.
The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click.
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 PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_40/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACAGSGT){kind=small}
| Company Size | Count |
|---|---|
| Small Business | 8 |
| Midsize Enterprise | 3 |
| Large Enterprise | 12 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 43 |
![Informatica PowerCenter vs Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACAGSGT){kind=small}
![Qlik Talend Cloud vs Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/bceq7xfg24vcset503xm0hyyr88r.jpg?_a=BACAGSGT){kind=small}
![IBM InfoSphere Information Server vs Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/vrgt1zpi8gqi3wy9lt9smu963yx9.jpg?_a=BACAGSGT){kind=small}
![SharePlex vs Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/gx7fdc2s39xboxn6pa3oukdu9s75.png?_a=BACAGSGT){kind=small}
Informatica PowerExchange [EOL] offers advanced data integration capabilities, emphasizing data transformation, real-time integration, and connectivity to diverse data sources, ensuring seamless access and management of big data in complex environments.
Informatica PowerExchange [EOL] is a robust tool for managing data integration and transformation processes. It supports connectivity to numerous sources, enabling real-time data capture and transformation. With native connectors and APIs, it allows seamless integration, ensuring data mapping across data formats. While strong at data handling and integration, improvements in pricing, real-time processing, and enhanced technical support are necessary. Expanded cloud integration and improved high availability will further bolster its efficiency in managing extensive datasets, supporting ETL, and integrating systems like SAP.
What are the most important features of Informatica PowerExchange?Informatica PowerExchange [EOL] is implemented widely in sectors requiring robust data integration solutions. It serves industries such as finance, healthcare, and retail, facilitating the creation of data warehouses and lakes. Used for ETL processes and operational analytics, it integrates systems like Hadoop, Oracle, and legacy environments, driving efficient communication and information sharing.
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.
![Informatica PowerExchange [EOL] vs. Oracle Data Integrator (ODI) report](https://www.peerspot.com/assets/media/images/icons/pdf-c33db68f.svg){kind=icon}
