What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
143 Ratings

Matillion

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
143 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100
104 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100

Likelihood to Recommend

Matillion

Matillion is great for handling bulk and 'delta' loads to your warehouse, i.e. updating the warehouse with only those records updated since the last execution of the pipeline. The components and Python scripting provide a huge amount of flexibility in what the pipeline does, but you do need to have the expertise to know how to implement it properly.Matillion has been less good at extracting data from APIs. The functionality was found to be complex and it was unclear how to manage things like pagination and rate limiting in API calls.
Anonymous | TrustRadius Reviewer

Oracle Data Integrator

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.
Paolo Borghi | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Matillion
7.9
Oracle Data Integrator
Connect to traditional data sources
Matillion
8.3
Oracle Data Integrator
Connecto to Big Data and NoSQL
Matillion
7.6
Oracle Data Integrator

Data Transformations

Matillion
8.1
Oracle Data Integrator
Simple transformations
Matillion
8.6
Oracle Data Integrator
Complex transformations
Matillion
7.5
Oracle Data Integrator

Data Modeling

Matillion
7.2
Oracle Data Integrator
Data model creation
Matillion
7.6
Oracle Data Integrator
Metadata management
Matillion
6.6
Oracle Data Integrator
Business rules and workflow
Matillion
7.4
Oracle Data Integrator
Collaboration
Matillion
6.8
Oracle Data Integrator
Testing and debugging
Matillion
6.3
Oracle Data Integrator
feature 1
Matillion
8.2
Oracle Data Integrator

Data Governance

Matillion
6.5
Oracle Data Integrator
Integration with data quality tools
Matillion
6.6
Oracle Data Integrator
Integration with MDM tools
Matillion
6.3
Oracle Data Integrator

Cloud Data Integration

Matillion
Oracle Data Integrator
7.8
Pre-built connectors
Matillion
Oracle Data Integrator
7.8
Connector modification
Matillion
Oracle Data Integrator
7.8
Support for real-time and batch integration
Matillion
Oracle Data Integrator
7.5
Data quality services
Matillion
Oracle Data Integrator
8.6
Data security features
Matillion
Oracle Data Integrator
7.8
Monitoring console
Matillion
Oracle Data Integrator
7.5

Pros

Matillion

  • The workspace is drag and drop, which makes it intuitive and easy to use.
  • Server creation and management is robust. We haven't had to worry too much about it once we got it created.
  • The job scheduler is very simple and intuitive.
  • Matillion allows you to run Python, which grants almost unlimited flexibility, even without using any other components.
Hyrum Ward | TrustRadius Reviewer

Oracle Data Integrator

  • 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.
Anonymous | TrustRadius Reviewer

Cons

Matillion

  • Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users.
  • Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies.
  • Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.
Patrick Hildreth | TrustRadius Reviewer

Oracle Data Integrator

  • 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.
James Parks | TrustRadius Reviewer

Likelihood to Renew

Matillion

Matillion 7.1
Based on 2 answers
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.
Sudarshan Kothari | TrustRadius Reviewer

Oracle Data Integrator

Oracle Data Integrator 10.0
Based on 4 answers
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.
Anonymous | TrustRadius Reviewer

Usability

Matillion

Matillion 7.8
Based on 87 answers
Pretty good UI, especially for a completely web-based system. Source control integration is a bit clunky at times, but overall makes code versioning and branching much more simple, since it's largely within the same context as the rest of the code. Finding some core settings can be difficult - they're just not where one would expect them to be.
Britton Gray | TrustRadius Reviewer

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Support Rating

Matillion

Matillion 7.6
Based on 4 answers
For most of users support can provide needed help. And it is always in a really short time frame.In some really advanced cases there was necessary to include highly tech people and there was a lot of back and forth. Because I have a case that is not resolved for more than a year and the bug is based on initial bad implementation (Google AdManager component) I would suggest that sometimes don't rush to publish something that is not ready.
Aleksa Topalović | TrustRadius Reviewer

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Implementation Rating

Matillion

Matillion 8.2
Based on 1 answer
Not really a part of the implementation to give fare insight.
Anonymous | TrustRadius Reviewer

Oracle Data Integrator

Oracle Data Integrator 7.0
Based on 1 answer
No answer on this topic is available.

Alternatives Considered

Matillion

There's a number of systems not available to enter in here that we also took a look at: AWS Data pipeline, Airflow, Xplenty, etc. The reason we chose Matillion is for the balance of features (ability to connect into cloud data sources like Jira), a simple interface to put together Data pipelines (that required little to no coding), and a reasonable price point. Matillion is pretty unique in that it hits a balance of all three of those requirements.
Kris Shinn | TrustRadius Reviewer

Oracle Data Integrator

I have used the Pentaho Data Integrator ETL tools in different projects with the SQL Server Integration Services product from the Microsoft product family. Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. The end-user interface of SQL Server Integration Services (SSIS) is quite simple and straightforward. It also has an active user community. You can find solutions in these communities for the problems you are experiencing. Since the Pentaho Data Integrator ETL is an open-source application, you can bring your ETL design costs to a very reasonable level. This project will contribute positively to your expenses.
zahit bogus | TrustRadius Reviewer

Scalability

Matillion

Matillion 6.7
Based on 79 answers
Instance size can be upgraded or downgraded with few clicks and hourly billing rate will change immediately. No need to restart Matillion instance. Matillion Enterprise edition has several benefits and will be activated automatically by configuring ">=m4." large instance size
Anonymous | TrustRadius Reviewer

Oracle Data Integrator

No score
No answers yet
No answers on this topic

Return on Investment

Matillion

  • Matillion has dramatically decreased the time it takes to create new ETL
  • Matillion has reduced the amount of time it takes to execute our daily ETL processing (by 50% or more)
  • Matillion has increased the number of people who can develop ETL by making ETL development easier
  • Matillion has increased the variety of data sources we can bring into our data warehouse
  • Matillion has made it a little harder to manage source control and deployment
Matthew Burr | TrustRadius Reviewer

Oracle Data Integrator

  • Lead time to complete data integration and transformation project was reduced due to Oracle Data Integrator tools that helped in setting up transformations relatively quickly once it was set up.
  • Reduced lead time helped in reducing project cost as less resources were spent in data conversion project.
  • Overall data consolidation project resulted in quick integration of data from varied DBMS and data sources.
Anonymous | TrustRadius Reviewer

Screenshots

Pricing Details

Matillion

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Oracle Data Integrator

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Matillion
7.6
Oracle Data Integrator
8.4

Likelihood to Renew

Matillion
7.1
Oracle Data Integrator
10.0

Usability

Matillion
7.8
Oracle Data Integrator

Support Rating

Matillion
7.6
Oracle Data Integrator

Implementation Rating

Matillion
8.2
Oracle Data Integrator
7.0

Scalability

Matillion
6.7
Oracle Data Integrator

Add comparison