Matillion vs. Oracle Data Integrator (ODI)

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Matillion
Score 7.2 out of 10
N/A
Matillion is a data pipeline platform used to build and manage pipelines. Matillion empowers data teams with no-code and AI capabilities to be more productive, integrating data wherever it lives and delivering data that’s ready for AI and analytics.
$2.50
Pay as you go per user
Oracle Data Integrator (ODI)
Score 7.2 out of 10
N/A
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.N/A
Pricing
MatillionOracle Data Integrator (ODI)
Editions & Modules
Developer: For Individuals
$2.50/credit
Pay as you go per user
Basic
$1000
per month 500 prepaid credits (additional credits: $2.18/credit)
Advanced
$2000
per month 750 prepaid credits (additional credits: $2.73/credit)
Enterprise
Request a Quote
No answers on this topic
Offerings
Pricing Offerings
MatillionOracle Data Integrator (ODI)
Free Trial
YesNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsBilled directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.
More Pricing Information
Community Pulse
MatillionOracle Data Integrator (ODI)
Considered Both Products
Matillion
Chose Matillion
Matillion is cloud-native, therefore it doesn't need virtual machines to set up. It is easier to use compared with some of them. It always does query pushdown, while other ones don't'. It is integrated with Snowflake, while other ETLs need to use workarounds in order to perform …
Oracle Data Integrator (ODI)

No answer on this topic

Features
MatillionOracle Data Integrator (ODI)
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Matillion
7.8
135 Ratings
7% below category average
Oracle Data Integrator (ODI)
9.6
11 Ratings
14% above category average
Connect to traditional data sources7.8134 Ratings9.911 Ratings
Connecto to Big Data and NoSQL7.794 Ratings9.39 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Matillion
7.0
136 Ratings
16% below category average
Oracle Data Integrator (ODI)
9.9
11 Ratings
19% above category average
Simple transformations7.5136 Ratings9.911 Ratings
Complex transformations6.5135 Ratings9.911 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Matillion
7.5
128 Ratings
5% below category average
Oracle Data Integrator (ODI)
9.2
11 Ratings
15% above category average
Data model creation9.133 Ratings9.310 Ratings
Metadata management9.140 Ratings9.510 Ratings
Business rules and workflow7.4119 Ratings9.111 Ratings
Collaboration5.6120 Ratings8.510 Ratings
Testing and debugging5.8121 Ratings9.311 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Matillion
8.2
23 Ratings
0% above category average
Oracle Data Integrator (ODI)
9.1
9 Ratings
11% above category average
Integration with data quality tools8.222 Ratings9.59 Ratings
Integration with MDM tools8.220 Ratings8.77 Ratings
Best Alternatives
MatillionOracle Data Integrator (ODI)
Small Businesses
Skyvia
Skyvia
Score 10.0 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
MatillionOracle Data Integrator (ODI)
Likelihood to Recommend
6.9
(137 ratings)
8.0
(29 ratings)
Likelihood to Renew
8.6
(6 ratings)
10.0
(4 ratings)
Usability
6.5
(136 ratings)
-
(0 ratings)
Support Rating
7.4
(7 ratings)
-
(0 ratings)
Implementation Rating
8.2
(1 ratings)
7.0
(1 ratings)
Product Scalability
6.4
(130 ratings)
-
(0 ratings)
Vendor post-sale
9.1
(1 ratings)
-
(0 ratings)
Vendor pre-sale
9.1
(1 ratings)
-
(0 ratings)
User Testimonials
MatillionOracle Data Integrator (ODI)
Likelihood to Recommend
Matillion
In a fast-growing startup-like environment, you’d want a graphical user interface representation of all your data work instead of using tools like Airflow. It’s good to deal with many ad hoc tasks, including in-house and external APIs, data lakes, and data warehouses. It’s also cheaper.
Read full review
Oracle
Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on). I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good. It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
Read full review
Pros
Matillion
  • Matillion has a rich transformation library. It provides multiple functionalities, such as join, group by, pivot, various sources, and sinks.
  • It provides the security capability as well. All the credentials can be securely stored in Matillion.
  • Reusable templates can be built which reduces the redundancy.
  • Time to production is very minimal.
Read full review
Oracle
  • Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
  • Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
  • Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
  • The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
Read full review
Cons
Matillion
  • Matillion is brilliant at importing data -- it would be amazing to have more ways to export data, from emailed exports to API pushes.
  • Any Python that takes more than a few lines of code requires an external server to run it. It would be great to have more integration (perhaps in a connected virtual environment) to easily integrate customized code.
  • Troubleshooting server logs requires quite a bit of technical expertise. More human readable detailed error handling would be greatly appreciated.
Read full review
Oracle
  • ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
  • ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
  • ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.
Read full review
Likelihood to Renew
Matillion
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.
Read full review
Oracle
It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger.
Read full review
Usability
Matillion
We are able to bring on new resources and teach them how to use Matillion without having to invest a significant amount of time. We prefer looking for resources with any type of ETL skill-set and feel that they can learn Matillion without problem. In addition, the prebuilt objects cover more than 95% of our use cases and we do not have to build much from scratch.
Read full review
Oracle
No answers on this topic
Support Rating
Matillion
Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Read full review
Oracle
No answers on this topic
Implementation Rating
Matillion
We were able to control on access and built various enviroment for implementation
Read full review
Oracle
No answers on this topic
Alternatives Considered
Matillion
Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum is essential to deciding which tool fits better. For the transformation part, dbt is purely (SQL-) code-based. So, it is mainly whether your developers prefer a GUI or code-based approach.
Read full review
Oracle
I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets.
Read full review
Scalability
Matillion
We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.
Read full review
Oracle
No answers on this topic
Return on Investment
Matillion
  • Matillion has been the backbone of my company's analytical functionalities for 10+ years, so it has a good ROI.
  • The price is ok for what our company built with it, but it starts to be less competitive if the tool is not used at its fullest.
Read full review
Oracle
  • From a business intelligence perspective, it allows us to provide users with the necessary data and information to make informed decisions.
  • Compared with other Oracle products and licensing, I do not think the pricing was unreasonable.
  • It is part of a larger install, so for ease of use, we purchased it with other Oracle products.
Read full review
ScreenShots

Matillion Screenshots

Screenshot of Matillion's GUI, used to orchestrate jobs with control data flow functionality, automating the ETL process.Screenshot of where structured and semi-structured data can be prepared to create clean data sets that can be used with any BI/reporting/visualization tool of choice. Matillion reads and combines data across a target warehouse external storage, such as S3 or Blob.Screenshot of Matillion's self-validating components, sample and row counts. If a job does fail, the warehouse queue services available with Matillion can be used get an alert to a connected email or Slack account.Screenshot of the SQL component used to run custom scripts from within Matillion. With hundreds of pre-built connectors out of the box, Matillion can handle complex transformation needs.