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
20 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.5 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 Warehouse Builder

The best place for Oracle Warehouse Builder is at the business IT level. It's not suited for business-level users. They are easy confused. One way to reduce the confusion for the developers is to set up the workspaces based on the requirements that are discovered in design sessions. Once this is complete, the implementation of Oracle Warehouse Builder can take flight and be successful.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Matillion
7.9
Oracle Warehouse Builder
9.5
Connect to traditional data sources
Matillion
8.3
Oracle Warehouse Builder
10.0
Connecto to Big Data and NoSQL
Matillion
7.6
Oracle Warehouse Builder
9.0

Data Transformations

Matillion
8.1
Oracle Warehouse Builder
10.0
Simple transformations
Matillion
8.6
Oracle Warehouse Builder
10.0
Complex transformations
Matillion
7.5
Oracle Warehouse Builder
10.0

Data Modeling

Matillion
7.2
Oracle Warehouse Builder
8.2
Data model creation
Matillion
7.6
Oracle Warehouse Builder
10.0
Metadata management
Matillion
6.6
Oracle Warehouse Builder
6.0
Business rules and workflow
Matillion
7.4
Oracle Warehouse Builder
9.0
Collaboration
Matillion
6.8
Oracle Warehouse Builder
8.9
Testing and debugging
Matillion
6.3
Oracle Warehouse Builder
7.0
feature 1
Matillion
8.2
Oracle Warehouse Builder

Data Governance

Matillion
6.5
Oracle Warehouse Builder
8.0
Integration with data quality tools
Matillion
6.6
Oracle Warehouse Builder
8.0
Integration with MDM tools
Matillion
6.3
Oracle Warehouse Builder
8.0

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 Warehouse Builder

  • Easy transformation.
  • Easy implementation from Oracle to Oracle systems.
  • Ease of usage and easy to learn.
  • Starting component of metadata management.
Gurcan Orhan | 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 Warehouse Builder

  • What I noticed is that sometimes OWB doesn't generate the best SQL in the package especially when there are a high number of source tables in the ETL. It would be nice if ETL developers were allowed to update the generated packages in the database directly.
  • Another thing - moving OWB ETLs from one database to another one could be easier - for example it would be nice to just copy the generated packages from one database to the other one without doing the deployment of these ETLs through OWB.
Kate Nadolinski | 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 Warehouse Builder

No score
No answers yet
No answers on this topic

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 Warehouse Builder

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 Warehouse Builder

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 Warehouse Builder

No score
No answers yet
No answers on this topic

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 Warehouse Builder

Ab>initio, IBM Datastage 8.0
Anonymous | 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 Warehouse Builder

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 Warehouse Builder

  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
Dina Britan | 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 Warehouse Builder

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 Warehouse Builder
8.0

Likelihood to Renew

Matillion
7.1
Oracle Warehouse Builder

Usability

Matillion
7.8
Oracle Warehouse Builder

Support Rating

Matillion
7.6
Oracle Warehouse Builder

Implementation Rating

Matillion
8.2
Oracle Warehouse Builder

Scalability

Matillion
6.7
Oracle Warehouse Builder

Add comparison