We changed our name from IT Central Station: Here's why

Oracle Data Integrator (ODI) vs Zapier comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: January 2022.
564,143 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The scalability is great. It's one of the reasons we chose the solution.""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.""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."

More Oracle Data Integrator (ODI) Pros →

"The solution is a SaaS and does not require a complex setup.""We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."

More Zapier Pros →

Cons
"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.""The resource management aspect of the solution could be improved.""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."

More Oracle Data Integrator (ODI) Cons →

"The pricing of the solution is quite expensive.""System-to-system is fine, but when it comes to system-to-user, where Zapier is helping to communicate to a user, that's a one-way communication. If that user has to perform some action on that notification, the action isn't handled by Zapier. So there's no way to orchestrate that and it's very cumbersome."

More Zapier Cons →

Pricing and Cost Advice
  • "The solution is expensive because of the model they use. The cost is for the license and for support."
  • More Oracle Data Integrator (ODI) Pricing and Cost Advice →

  • "It's very straightforward licensing. There's only one cost you have to pay, and if you want a relevant pricing plan, I think you have two or three different models or packages which include the number of notifications or Zaps, as they call it, that you can program."
  • More Zapier Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
    564,143 professionals have used our research since 2012.
    Questions from the Community
    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 »
    Top Answer: 
    What is the OLAP that you are using? Hosted in Cloud or on-premise?  The target DB should have its tool to extract data.
    Top Answer: 
    I know I'm late to the party but here are my comments to this. I would ask what version of ODI are you running, but for the most part it doesn't matter. I will say that since you are saying Mapping… more »
    Ask a question

    Earn 20 points

    Ranking
    5th
    Views
    20,934
    Comparisons
    14,507
    Reviews
    6
    Average Words per Review
    778
    Rating
    8.7
    11th
    Views
    1,882
    Comparisons
    1,650
    Reviews
    1
    Average Words per Review
    1,103
    Rating
    8.0
    Comparisons
    Also Known As
    ODI
    Learn More
    Overview

    Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. 

    ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes.  It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.  Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

    Zapier is a tool for primarily non-technical users to connect together web apps.

    An integration between two apps is called a Zap. A Zap is made up of a Trigger and one or more Actions or Searches.

    Whenever the trigger happens in one app, Zapier will automatically perform the actions or searches in another app in order.

    Zaps are very lightweight and easy to set up. Zaps do not import or export old data (they only operate on new items created after the Zap is enabled). Zaps are also not kept in sync ("two way syncing") after the Zap is triggered.

    Zaps are deceivingly simple if you're used to dealing with complex and difficult integrations. Their simplicity is what enables anyone to create them.


    Offer
    Learn more about Oracle Data Integrator (ODI)
    Learn more about Zapier
    Sample Customers
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    BuzzFeed, Groupon, Spotify, Columbia University, FOX
    Top Industries
    REVIEWERS
    Financial Services Firm32%
    University9%
    Hospitality Company9%
    Insurance Company9%
    VISITORS READING REVIEWS
    Computer Software Company39%
    Comms Service Provider16%
    Financial Services Firm8%
    Government5%
    REVIEWERS
    Marketing Services Firm25%
    Recruiting/Hr Firm25%
    Leisure / Travel Company13%
    Real Estate/Law Firm13%
    VISITORS READING REVIEWS
    Computer Software Company33%
    Comms Service Provider20%
    Government6%
    Insurance Company4%
    Company Size
    REVIEWERS
    Small Business32%
    Midsize Enterprise13%
    Large Enterprise55%
    REVIEWERS
    Small Business72%
    Midsize Enterprise20%
    Large Enterprise8%
    Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: January 2022.
    564,143 professionals have used our research since 2012.

    Oracle Data Integrator (ODI) is ranked 5th in Data Integration Tools with 6 reviews while Zapier is ranked 11th in Cloud Data Integration with 2 reviews. Oracle Data Integrator (ODI) is rated 8.6, while Zapier is rated 8.6. The top reviewer of Oracle Data Integrator (ODI) writes "I have used it to improve run-times of many corporations' overall integration run-times". On the other hand, the top reviewer of Zapier writes "Streamlines our system-to-system task automation at the scale we need". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Oracle GoldenGate and Talend Open Studio, whereas Zapier is most compared with Workato, AWS AppSync, Coupler.io, Alteryx Designer and Talend Stitch.

    We monitor all Data Integration Tools 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.