Oracle Data Integrator (ODI) vs. Zapier

As of May 2019, Oracle Data Integrator (ODI) is ranked 1st in Data Integration Tools with 15 reviews vs Zapier which is ranked 2nd in Cloud Data Integration with 13 reviews. The top reviewer of Oracle Data Integrator (ODI) writes "It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors". The top reviewer of Zapier writes "Ability to connect almost any API to another API". Oracle Data Integrator (ODI) is most compared with Informatica PowerCenter, SSIS and Oracle GoldenGate. Zapier is most compared with Workato, Dell Boomi AtomSphere and Mule Anypoint Platform.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: May 2019.
340,124 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
It's completely user-friendly.​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.It has the ability to easily load slowly changing dimensions.​The installation of the client ODI Studio is easy.​Besides loading data, we do most of our transformations in ODI.In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way.Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.

Read more »

The connection between Facebook lead forms and MailChimp integrations is the most valuable feature.The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses.

Read more »

Cons
Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasonsIt lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.​The stability of the software could be improved. Sometimes, the software just crashes. ​If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value.I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product.Technical Support could be better.It needs easier security.

Read more »

Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client.Being able to share Zaps and organize them with teammates would allow sharing and refining scenarios and even combining steps that require different people's credentials.

Read more »

Pricing and Cost Advice
We found that the cost compared to other integration tools is a little high, but the solution works great.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.

Read more »

Think your Zaps through to make sure you don't use more Zaps than you need.There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while.

Read more »

report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
340,124 professionals have used our research since 2012.
Ranking
1st
Views
41,890
Comparisons
12,273
Reviews
15
Average Words per Review
412
Avg. Rating
7.9
2nd
Views
1,380
Comparisons
760
Reviews
23
Average Words per Review
390
Avg. Rating
8.6
Top Comparisons
Compared 18% of the time.
Compared 30% of the time.
Compared 16% of the time.
Compared 13% of the time.
Also Known As
ODI
Learn
Oracle
Zapier
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 UniversityBuzzFeed, Groupon, Spotify, Columbia University, FOX
Top Industries
REVIEWERS
Financial Services Firm26%
Insurance Company11%
Hospitality Company11%
Retailer11%
VISITORS READING REVIEWS
Financial Services Firm19%
Comms Service Provider17%
University13%
Logistics Company12%
REVIEWERS
Recruiting/Hr Firm29%
Marketing Services Firm29%
Transportation Company14%
Real Estate/Law Firm14%
Company Size
REVIEWERS
Small Business30%
Midsize Enterprise11%
Large Enterprise60%
VISITORS READING REVIEWS
Small Business4%
Midsize Enterprise13%
Large Enterprise83%
REVIEWERS
Small Business68%
Midsize Enterprise23%
Large Enterprise9%
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: May 2019.
340,124 professionals have used our research since 2012.
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.

Sign Up with Email