Informatica PowerExchange vs Oracle Data Integrator (ODI) vs Talend Open Studio comparison

Cancel
You must select at least 2 products to compare!
Informatica Logo
2,714 views|2,036 comparisons
88% willing to recommend
Oracle Logo
15,558 views|8,845 comparisons
84% willing to recommend
Talend Logo
12,831 views|9,729 comparisons
97% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Informatica PowerExchange, Oracle Data Integrator (ODI), and Talend Open Studio based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration.
To learn more, read our detailed Data Integration Report (Updated: April 2024).
768,886 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The user interface and user experience are perfectly all right.""Mainstream integration and real-time integration are the best features.""The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable.""From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface.""Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking.""This product is easy to install and it can be done in a few hours.""Provides a significant amount of control over the landscape and overall implementation.""The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."

More Informatica PowerExchange Pros →

"Oracle provides great documentation.""It is an ETL tool, which does the extract, transform, and load.""Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support.""​The installation of the client ODI Studio is easy.​""The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module.""ODI's most valuable features are it utilizes the database engine and is very lightweight.""One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value.""The most valuable feature is Data movement."

More Oracle Data Integrator (ODI) Pros →

"The most valuable feature for me when it comes to this solution is that it's easy to use.""This is a user-friendly solution that is easy to use.""This solution has improved our overall time to value for data ingestion.""You can use Talend as a stand-alone application without customization to collect data and generate reports over dashboards. It's got great functionality.""It's a good tool. It has the ability to take apart and install whatever we need. It's very good for data, transformation, and loading.""Talend Open Studio is easy to create jobs. We use the basic functionality and it is very good.""We're sold on the customization part of the solution.""The main differentiator that I have seen between Talend and other data integration tools is the ability to view the data pipeline in the form of a program."

More Talend Open Studio Pros →

Cons
"The connectivity with T24 core banking could be improved.""Technical support can be improved with respect to delays in ticket response time.""I would like to have easier integration with cloud platforms.""Integration with the largest number of databases and other systems would be important.""I would like the stability to improve.""Should diversify more, maybe with a reporting and visualization utility,""The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue.""The solution needs better integration with other tools."

More Informatica PowerExchange Cons →

"​The stability of the software could be improved. Sometimes, the software just crashes. ​""If you have something like Cisco on top of it, you will have endless problems.""The resource management aspect of the solution could be improved.""The solution lacks some functions and features.""The initial setup is a bit complex compared to other tools.""I would only point out some minor bugs or glitches in the development interface (ODI studio).""ODI could improve by focusing on streamlining its features without unnecessary overhead.""Stability could be improved because some operators have issues."

More Oracle Data Integrator (ODI) Cons →

"I would say that writing to JSON is kind of a pain. It reads from a JSON file pretty well, but writing to a JSON file is not so great because its components are not good.""It needs better installation configuration for other databases. Although the installation allows you to select another database, this doesn't mean that all connection points in the application point to the database selected. You actually need to do a search through the entire install to locate the configuration settings and change them.""We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features.""In terms of what can be improved, the scheduling is not there in the sister version, while it is there in the cloud one, which is a paid version. If all kinds of scheduling could be available on the Open Studio that we generally use and practice on, that would be great. The scheduling of the data migration is currently not available in the sister version of Talend Open Studio that we are working on. It is available in the advanced version of the Talend. This is the one thing that can be improvised.""There used to be many Youtube channels that offered Talend training, but now there don't seem to be any. The solution should offer more online training resources.""In terms of features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM.""I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes.""The user interface could be made simpler."

More Talend Open Studio Cons →

Pricing and Cost Advice
  • "An annual package license fee is required."
  • "The cost of PowerExchange is reasonable. It does not rely on complicated formulas or unrealistic equations. The pricing model is straightforward. There is one component, and real-time integration is included. Some other solutions require purchasing additional modules or third-party plugins for this capability."
  • "It's expensive. In fact, nobody would buy any product of Informatica if the price was the only consideration. It costs money, and it doesn't come cheap, but it provides value for money in many ways."
  • "There is a need to pay towards the licensing cost of the product. It is an expensive product."
  • "Many users don't prefer to use the product, considering the high costs attached to the licensing part of the solution."
  • "The product is not very expensive."
  • More Informatica PowerExchange Pricing and Cost Advice →

  • "Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good."
  • "We found that the cost compared to other integration tools is a little high, but the solution works great."
  • "The solution is expensive because of the model they use. The cost is for the license and for support."
  • "ODI comes included when buying the cloud version of the Oracle database license."
  • "There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
  • "Per user, it is $900 USD per year, though they will give some discount. However, even a 60% to 70% of discount for each won't help us much. On top of that, there is the perpetual license you must pay at the outset."
  • "I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
  • "The Oracle Data Integrator (ODI) pricing isn't expensive, but it's not cheap, so it's in the middle. I'd rate the pricing as three out of five."
  • More Oracle Data Integrator (ODI) Pricing and Cost Advice →

  • "Pricing and licensing are fairly straightforward. It is reasonably priced and managed."
  • "Talend is free and you can download it."
  • "The paid version of this solution has a very high price, but even with the limitations, the Community version works fine."
  • "Price could be lower. It is getting too expensive when compared to some other solutions, which is actually a little bit concerning."
  • "There are many versions available and one is open-sourced which is free."
  • "The cost for one year for the ETL tools, not for the big data, is 6K per year. It is a good price."
  • "It does the job well for nothing — without cost. That's the advantage of this product."
  • "Talend Open Studio is priced too high."
  • More Talend Open Studio Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    768,886 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:The product is not very expensive. However, the price can grow depending on the customer’s needs and the data feed they… more »
    Top Answer:Informatica is now moving to the cloud. PowerExchange is not being promoted as it used to be. The product is not… more »
    Top Answer:Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for… more »
    Top Answer:We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from… more »
    Top Answer:It is easy to use and covers most of the functions needed. We can use the code without any extra effort. The open source… more »
    Top Answer:The product’s pricing is reasonable. It has an annual subscription.
    Ranking
    21st
    out of 100 in Data Integration
    Views
    2,714
    Comparisons
    2,036
    Reviews
    9
    Average Words per Review
    654
    Rating
    7.9
    4th
    out of 100 in Data Integration
    Views
    15,558
    Comparisons
    8,845
    Reviews
    16
    Average Words per Review
    429
    Rating
    8.2
    5th
    out of 100 in Data Integration
    Views
    12,831
    Comparisons
    9,729
    Reviews
    15
    Average Words per Review
    559
    Rating
    7.9
    Comparisons
    Also Known As
    PowerExchange, Connectors
    ODI
    Open Studio
    Learn More
    Overview

    Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.

    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:

    • Automatic documentation generation
    • Visualization of data flows in the interfaces
    • Customization of generated code
    • Automatic reverse-engineering of existing applications or databases
    • Graphical development and maintenance of transformation and integration interfaces
    • Robust data integrity control features, assuring the consistency and correctness of data
    • Powerful core differentiators
    • Heterogeneous ELT, declarative design and knowledge modules
    • Flexibility and modularity
    • Oracle Data Integrator repository
    • Topology navigator
    • Operator Navigator
    • Security Navigator
    • Integrator Console
    • ODI domains

    Oracle Data Integrator Benefits

    There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:

    • Efficient architecture: Oracle Data Integrator has a simple architecture that utilizes the source and target servers to perform complex transformations, making it an efficient solution.
    • Supports all platforms: ODI gives you platform independence by supporting all platforms, hardware, and OSes with the same software.
    • Cost-effective: Oracle Data Integrator reduces costs associated with initial hardware and software acquisition, and also decreases maintenance costs because it eliminates the need for an ETL Server and an ETL engine.
    • Automatic detection of faulty data: By using ODI, faulty data is recycled before insertion in the target application, providing you with a data quality firewall.
    • Easy development and maintenance: With a low learning curve, Oracle Data Integrator increases developer productivity while facilitating ongoing maintenance. 
    • Active integration: ODI includes all styles of data integration: data-based, event-based and service-based.

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

    Talend Open Studio is a free, open source ETL tool for data integration and Big Data. The solution enables you to extract diverse datasets and normalize and transform them into a consistent format which can be loaded into a number of third-party databases and applications.

    Talend Open Studio Features

    Talend Open Studio has many valuable key features. Some of the most useful ones include:

    • Automatic identification of data types and potential errors
    • tMap module
    • Graphical conversion tools
    • Charts
    • Database SCD Tools
    • Business intelligence formats (Jasper, OLAP, SPSS, Splunk)
    • ETL and ELT support
    • Eclipse-based development tooling
    • Versioning
    • Large library of connectors
    • Data flow orchestration
    • File management without scripting
    • Data transformations

    Talend Open Studio Benefits

    There are several benefits to implementing Talend Open Studio. Some of the biggest advantages the solution offers include:

    • Reduces the time taken to develop the integration.
    • Provides a wide selection of source and target connectors.
    • Monitor and manage problematic deployments with ease.
    • Allows developers to have the lowest cost of ownership for any solution.
    • Improves collaboration between different teams who need access to data.
    • Automated data integration process synchronizes the data and eases real time and periodic reporting, which would be time-consuming if done manually.
    • Achieve better data quality because data matures and improves over time.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Talend Open Studio solution.

    Elio B., Data Integration Specialist/CTO at Asset messages, says, "The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."

    A Practice Head, Analytics at a tech services company mentions, “The data integration aspect of the solution is excellent. The product's data preparation features are very good. There's very useful data stewardship within the product. From a technical standpoint, the solution itself is pretty good. There are very good pre-built connectors in Talend, which is good for many clients or businesses, as, in most cases, companies are dealing with multiple data sources from multiple technologies. That is where a tool like Talend is extremely helpful.”

    Prerna T., Senior System Executive at a tech services company, comments, “The best thing I have found with Talend Open Studio is their major support for the lookups. With Salesforce, when we want to relate our child objects to their parent object, we need to create them via IDs. Then the upsert operation, which will allow you to relate a child object to the event, will have an external ID. That is the best thing which keeps it very sorted. I like that.”

    An Implementation Specialist, Individual Contributor at a computer software company, states, “I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields.” He also adds, “It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool.”

    PeerSpot user Badrakh V., Information System Architect at Astvision, explains, "The most valuable features are the ETL tools."

    Sample Customers
    ACH Food, BNSF Railway Company, Illinois State University
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    Almerys, BF&M, Findus
    Top Industries
    REVIEWERS
    Computer Software Company25%
    Insurance Company25%
    Comms Service Provider13%
    Financial Services Firm13%
    VISITORS READING REVIEWS
    Financial Services Firm27%
    Insurance Company12%
    Computer Software Company12%
    Government7%
    REVIEWERS
    Financial Services Firm24%
    Comms Service Provider11%
    Computer Software Company8%
    University5%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company14%
    Government8%
    Manufacturing Company8%
    REVIEWERS
    Computer Software Company29%
    Insurance Company12%
    University12%
    Financial Services Firm12%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Manufacturing Company7%
    Government6%
    Company Size
    REVIEWERS
    Small Business37%
    Midsize Enterprise11%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business12%
    Midsize Enterprise8%
    Large Enterprise80%
    REVIEWERS
    Small Business32%
    Midsize Enterprise16%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise12%
    Large Enterprise71%
    REVIEWERS
    Small Business42%
    Midsize Enterprise25%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise15%
    Large Enterprise66%
    Buyer's Guide
    Data Integration
    April 2024
    Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration. Updated: April 2024.
    768,886 professionals have used our research since 2012.