Oracle Data Integrator (ODI) vs Talend Open Studio vs Unifi comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
15,103 views|8,603 comparisons
84% willing to recommend
Talend Logo
12,417 views|9,443 comparisons
97% willing to recommend
Unifi Software Logo
272 views|229 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Oracle Data Integrator (ODI), Talend Open Studio, and Unifi 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).
769,662 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
"​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.""It's scalable.""The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance.""I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.""ODI's most valuable features are it utilizes the database engine and is very lightweight.""The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good.""All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner.""ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."

More Oracle Data Integrator (ODI) Pros →

"Talend Studio has the ability to use it to ensure data quality.""The standout feature for me is the user-friendly nature of the components.""We're sold on the customization part of the solution.""The initial setup was quite straightforward. The deployment took between two and three days.""The drag-and-drop feature in the interface is very good.""Talend can connect to multiple data sources, including relational data sources, ERP, CRM, and others.""This product is very easy to use.""The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB."

More Talend Open Studio Pros →

"The controller makes it easy to control everything from one platform. The management is easy.""It's easy to manage and support the user, our guests, and our customers if they have a problem."

More Unifi Pros →

Cons
"If you have something like Cisco on top of it, you will have endless problems.""We used a third party to do the implementation of ODI.""The initial setup is a bit complex compared to other tools.""It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.""The solution lacks some functions and features.""ODI could improve by focusing on streamlining its features without unnecessary overhead.""Stability could be improved because some operators have issues.""There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."

More Oracle Data Integrator (ODI) Cons →

"The high price of the solution is an area of concern where improvements are required.""We don't get continuous replication of the data.""Inter-version compatibility is a problem, and migration projects between versions are required.""If I compare Open Studion to other solutions, their interface is robust but not so fancy looking. This is an area that could use improvement. I would like to see an updated interface.""Talend should improve the log and error handling to better track the errors you find during development. Sometimes it's challenging to see what's causing an issue, and tracking that on Talend is complicated.""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.""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.""Having additional training materials, such as a video tutorial, would be an improvement."

More Talend Open Studio Cons →

"It's stable, but it depends on the office and location.""There are issues with certain Apple devices."

More Unifi Cons →

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 →

  • "There is no license. The solution is free."
  • More Unifi Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    769,662 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for… more »
    Top Answer:ODI significantly improves data integration and management by allowing customization of data types from various sources… more »
    Top Answer:The pricing for ODI varies depending on factors like usage and deployment model. While it might be expensive for small… 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.
    Top Answer:The controller makes it easy to control everything from one platform. The management is easy.
    Top Answer:In a high-density location, we're running into connectivity drops. There may be too many rouge devices broadcasting, and… more »
    Ranking
    4th
    out of 101 in Data Integration
    Views
    15,103
    Comparisons
    8,603
    Reviews
    18
    Average Words per Review
    431
    Rating
    8.3
    5th
    out of 101 in Data Integration
    Views
    12,417
    Comparisons
    9,443
    Reviews
    15
    Average Words per Review
    559
    Rating
    7.9
    47th
    out of 101 in Data Integration
    Views
    272
    Comparisons
    229
    Reviews
    1
    Average Words per Review
    484
    Rating
    7.0
    Comparisons
    Also Known As
    ODI
    Open Studio
    Learn More
    Overview

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

    The Unifi Data Platform breaks down the barriers of operational data silos and democratizes information across the enterprise. At the heart of the platform is a comprehensive suite of self-service data discovery and preparation tools to empower business users. Employing machine learning and artificial intelligence technologies, and optimized for the cloud, Unifi predicts what the business user wants to visualize and then connects the resulting data natively to the BI tool for fast, accurate results.

    Sample Customers
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    Almerys, BF&M, Findus
    Big Incites, Cloudera, Flywheel Data, Hortonworks, MapR, Platfora, Qlik, Tableau Software, zData Inc.
    Top Industries
    REVIEWERS
    Financial Services Firm24%
    Comms Service Provider11%
    Computer Software Company8%
    University5%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company15%
    Government8%
    Manufacturing Company8%
    REVIEWERS
    Computer Software Company29%
    Insurance Company12%
    Financial Services Firm12%
    University12%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Manufacturing Company7%
    Government6%
    VISITORS READING REVIEWS
    Financial Services Firm33%
    Real Estate/Law Firm16%
    Manufacturing Company13%
    Government7%
    Company Size
    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%
    VISITORS READING REVIEWS
    Small Business28%
    Midsize Enterprise9%
    Large Enterprise63%
    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.
    769,662 professionals have used our research since 2012.