Equalum vs Oracle Data Integrator (ODI) comparison

Cancel
You must select at least 2 products to compare!
Equalum Logo
1,280 views|490 comparisons
100% willing to recommend
Oracle Logo
15,558 views|8,845 comparisons
84% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Equalum and Oracle Data Integrator (ODI) 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,246 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
"Equalum provides a single platform for core architectural use cases, including CDC replication, streaming ETL, and batch ETL. That is important to our clients because there is no other single-focus product that covers these areas in that much detail, and with this many features on the platform. The fact that they are single-minded and focused on CDC and ETL makes this such a rich solution. Other solutions cover these things a little bit in their multi-function products, but they don't go as deep.""It's got it all, from end-to-end. It's the glue. There are a lot of other products out there, good products, but there's always a little bit of something missing from the other products. Equalum did its research well and understood the requirements of large enterprise and governments in terms of one tool to rule them all, from a data migration integration perspective.""The main impact for Oracle LogMiner is the performance. Performance is drastically reduced if you use the solution’s Oracle Binary Log Parser. So, if we have 60 million records, initially it used to take a minute. Now, it takes a second to do synchronization from the source and target tables.""Equalum has resulted in system performance improvements in our organization. Now, I am ingressing data off of multiple S3 sources, doing data processing, and formatting a schema. This would usually take me a couple of days, but now it takes me hours.""It's a really powerful platform in terms of the combination of technologies they've developed and integrated together, out-of-the-box. The combination of Kafka and Spark is, we believe, quite unique, combined with CDC capabilities. And then, of course, there are the performance aspects. As an overall package, it's a very powerful data integration, migration, and replication tool.""All our architectural use cases are on a single platform, not multiple platforms. You don't have to dump into different modules because it is the same module everywhere.""I found two features in Equalum that I consider the most valuable. One is that Equalum is a no-code tool. You can do your activities on its graphical interface, which doesn't require complex knowledge of extracting, changing, or loading data. Another feature of Equalum that I like the most is that it monitors the data transfers and tells you if there's any issue so that you can quickly check and correct it. Equalum also tells you where the problem lies, for example, if it's a hardware or communication issue.""Equalum is real-time. If you are moving from an overnight process to a real-time process, there is always a difference in what reports and analytics show compared to what our operational system shows. Some of our organizations, especially finance, don't want those differences to be shown. Therefore, going to a real-time environment makes the data in one place match the data in another place. Data accuracy is almost instantaneous with this tool."

More Equalum Pros →

"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support.""Oracle provides great documentation.""The most valuable feature of ODI is the to use of the whole ETL to create a data lake.""The most valuable feature is Data movement.""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.""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.""What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company.""In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."

More Oracle Data Integrator (ODI) Pros →

Cons
"They need to expand their capabilities in some of the targets, as well as source connectors, and native connectors for a number of large data sources and databases. That's a huge challenge for every company in this area, not just Equalum.""Right now, they have a good notification system, but it is in bulk. For example, if I have five projects running and I put a notification, the notification comes back to me for all five projects. I would like the notification to come back only for one project.""There is not enough proven integration with other vendors. That is what needs to be worked on. Equalum hasn't tested anything between vendors, which worries our clients. We need more proven vendor integration. It is an expensive product and it needs to support a multi-vendor approach.""The deployment of their flows needs improvement. It doesn't work with a typical Git branching and CI/CD deployment strategy.""If you need to use the basic features of Equalum, for example, you don't even need data integration, then many competitors in the market can give you basic features. For instance, if you need batch ETL, you can pick among solutions in the market that have been around longer than Equalum. What needs improvement in Equalum is replication, as it could be faster. Equalum also needs better integration with specific databases such as Oracle and Microsoft SQL Server.""Their UI could use some work. Also, they could make it just a little faster to get around their user interface. It could be a bit more intuitive with things like keyboard shortcuts.""I should be able to see only my project versus somebody else's garbage. That is something that would be good in future. Right now, the security is by tenants, but I would like to have it by project, e.g., this project has this source and flows in these streams, and I have access to this on this site."

More Equalum Cons →

"The initial setup is complex, especially if you also have to install a console.""​The stability of the software could be improved. Sometimes, the software just crashes. ​""It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons""The price needs to be lowered. It's too expensive.""The initial setup is a bit complex compared to other tools.""ODI could improve the ease of use. There is a steep learning curve to use the solution.""The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects.""At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."

More Oracle Data Integrator (ODI) Cons →

Pricing and Cost Advice
  • "They have a very simple approach to licensing. They don't get tied up with different types of connectivity to different databases. If you need more connectors or if you need more CPU, you just add on. It's component-based pricing."
  • "Equalum was reasonably priced. It is not like those million dollar tools, such as Informatica."
  • "Equalum is rather expensive compared to its competitors. So, you have to make up that cost in time savings, and we usually do that. If we are saving money, it is because we are reducing our development time."
  • "As soon as you have more than six users, Equalum is lower in cost [than Talend] and if the group gets bigger, it's quite a big delta. If more users want to use it, you don't end up with an increase in licensing costs, so that makes it very easy. And if you need more licenses or more sources, it's a very simple upgrade methodology."
  • "Equalum licensing costs vary, but I won't be able to give information on its fees."
  • More Equalum 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 →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    768,246 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:You'd want to use the Equalium Oracle Binary Log Parser because it's just better than the LogMiner. Sure, LogMiner is made by Oracle and probably the team knows some insight to make it efficient that… more »
    Top Answer:I'm using Equalum's data replication software for Oracle because that's the one database it's designed for. While it may sound limiting, when you find out how many solutions it can provide for you if… more »
    Top Answer:No, it's not free but you can benefit from a free trial, though. There's an option to try their platform for a limited amount of time, so that may be useful to help you decide if you want to continue… more »
    Top Answer:Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that come… more »
    Ranking
    30th
    out of 100 in Data Integration
    Views
    1,280
    Comparisons
    490
    Reviews
    1
    Average Words per Review
    628
    Rating
    9.0
    4th
    out of 100 in Data Integration
    Views
    15,558
    Comparisons
    8,845
    Reviews
    16
    Average Words per Review
    429
    Rating
    8.2
    Comparisons
    Also Known As
    ODI
    Learn More
    Equalum
    Video Not Available
    Overview

    Equalum is a fully-managed, end-to-end data integration and real-time data streaming platform, powered by industry-leading change data capture (CDC) tech and modern data transformation capabilities (streaming ETL and ELT). Equalum's enterprise-grade platform features intuitive UI allowing you to build robust, real-time data pipelines in minutes.

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

    Sample Customers
    SIEMENS, GSK, Wal-Mart, T Systems
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    Top Industries
    VISITORS READING REVIEWS
    Manufacturing Company18%
    Computer Software Company17%
    Financial Services Firm8%
    Pharma/Biotech Company7%
    REVIEWERS
    Financial Services Firm24%
    Comms Service Provider11%
    Computer Software Company8%
    University5%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company14%
    Government8%
    Manufacturing Company8%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise14%
    Large Enterprise57%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise17%
    Large Enterprise62%
    REVIEWERS
    Small Business32%
    Midsize Enterprise16%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise12%
    Large Enterprise71%
    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,246 professionals have used our research since 2012.

    Equalum is ranked 30th in Data Integration with 7 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Equalum is rated 9.2, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Equalum writes "Frees staff to focus on data workflow and on what can be done with data, and away from the details of the technology". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". Equalum is most compared with Azure Data Factory, Confluent, EDB Postgres Replication Server and Fivetran, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate.

    See our list of best Data Integration vendors and best Cloud Data Integration vendors.

    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.