Matillion vs. Oracle Warehouse Builder

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Matillion
Score 8.1 out of 10
N/A
Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions. The vendor states enterprises includingN/A
Oracle Warehouse Builder
Score 8.7 out of 10
N/A
Oracle Warehouse Builder (OWB) is a data-warehousing centered data integration solution, from Oracle. It offers basic ETL functionality for building a simple data warehouse, as well as advanced ETL functionality supporting enterprise data integration projects, along with connectivity for Oracle and SAP applications.N/A
Pricing
MatillionOracle Warehouse Builder
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
MatillionOracle Warehouse Builder
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 Warehouse Builder
Top Pros
Top Cons
Features
MatillionOracle Warehouse Builder
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Matillion
8.6
116 Ratings
4% above category average
Oracle Warehouse Builder
9.5
5 Ratings
14% above category average
Connect to traditional data sources8.8115 Ratings10.05 Ratings
Connecto to Big Data and NoSQL8.576 Ratings9.02 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Matillion
8.4
116 Ratings
0% above category average
Oracle Warehouse Builder
10.0
5 Ratings
18% above category average
Simple transformations9.3116 Ratings10.05 Ratings
Complex transformations7.5115 Ratings10.04 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Matillion
8.2
110 Ratings
0% above category average
Oracle Warehouse Builder
8.2
5 Ratings
0% above category average
Data model creation9.133 Ratings10.04 Ratings
Metadata management9.140 Ratings6.04 Ratings
Business rules and workflow8.0102 Ratings9.04 Ratings
Collaboration7.4103 Ratings8.94 Ratings
Testing and debugging7.4103 Ratings7.04 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Matillion
8.2
23 Ratings
0% below category average
Oracle Warehouse Builder
8.0
3 Ratings
3% below category average
Integration with data quality tools8.222 Ratings8.03 Ratings
Integration with MDM tools8.220 Ratings8.02 Ratings
Best Alternatives
MatillionOracle Warehouse Builder
Small Businesses
Skyvia
Skyvia
Score 9.6 out of 10
Skyvia
Skyvia
Score 9.6 out of 10
Medium-sized Companies
InfoSphere
InfoSphere
Score 8.2 out of 10
InfoSphere
InfoSphere
Score 8.2 out of 10
Enterprises
InfoSphere
InfoSphere
Score 8.2 out of 10
InfoSphere
InfoSphere
Score 8.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
MatillionOracle Warehouse Builder
Likelihood to Recommend
9.0
(117 ratings)
8.0
(5 ratings)
Likelihood to Renew
7.9
(6 ratings)
-
(0 ratings)
Usability
8.7
(116 ratings)
-
(0 ratings)
Support Rating
7.4
(7 ratings)
-
(0 ratings)
Implementation Rating
8.2
(1 ratings)
-
(0 ratings)
Product Scalability
8.6
(109 ratings)
-
(0 ratings)
Vendor post-sale
9.1
(1 ratings)
-
(0 ratings)
Vendor pre-sale
9.1
(1 ratings)
-
(0 ratings)
User Testimonials
MatillionOracle Warehouse Builder
Likelihood to Recommend
Matillion
It is well suited for direct data transfer from source to destination. Emailing success/failures of jobs is a bit complicated. Also, upgrades are quite frequent which do take time and testing and setting up backup instances. We always have to remember to keep the backup instance off and remember to delete it after the upgraded version has been tested.
Read full review
Oracle
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.
Read full review
Pros
Matillion
  • We leveraged Matillion’s no-code principals to make data manipulation easy for our internal customers. People who don't know how to use SQL no longer need to. Everything in Matillion is self-explained with no or little coding.
  • We connected Matillion to our data warehouse to allow people to read raw data, transform it, then write results back to their sandbox databases. The drag and drop component design allowed customers to create complex data models at the speed of thought without any risk to production data.
  • With sharing capabilities between projects enabled, everyone was able to help each other when questions arose which instilled a strong sense of collaboration and community.
Read full review
Oracle
  • Easy transformation.
  • Easy implementation from Oracle to Oracle systems.
  • Ease of usage and easy to learn.
  • Starting component of metadata management.
Read full review
Cons
Matillion
  • I think a non-CLI approach to installing and uninstalling python libraries would be nice. I mean, it isn't difficult to install a python library via Linux or CLI, but I imagine most companies don't feel comfortable allowing Matillion users to go on a virtual server and installing it themselves. Requirement.txt file for installing libraries would be simple, and maybe that could also be used to uninstall libraries as well......or maybe the library gets automatically downloaded if it is imported into a python script but the library doesn't exist.
  • Python Component is lacking very much in terms of UI. It would be unrealistic for me to suggest Matillion build its own EDI, but it would be nice if a python component could connect to a local IDE. Right now, if you want to write any decent length python code, you are going to be stuck copying and pasting your code from your local IDE.
  • It is also very difficult to debug in Matillion because you can't set breakpoints. Local IDE integration can resolve that.
  • I would like to have more templates to copy from for certain simplistic scenarios. For instance, a template for a job that fails which sends an AWS SNS with the Job name, component it failed on, and the error message. It wasn't as simple as I thought it would be to figure out and having to use a shared job for such circumstances can be painful because you have to export a bunch of variables.
  • There should be a drop down list for Global Matillion variables as it is difficult to remember at times.
Read full review
Oracle
  • 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.
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
No answers on this topic
Usability
Matillion
It is very easy to do what is needed for replication, but working with the ETL product is a bit daunting. Since it is not our primary tool from Matillion, we have yet to receive any training on it so it is not intuitively obvious what we need to do to accomplish many of our plans.
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
I tried to use several opensource tools before Matillion. They were not bad, but I spent a ton of time maintaining the system, and debugging why things wouldn't work. It also seemed like everything needed a hack to get it working properly. With Matillion, it just works outside of the box, and they have a lot of good documentation explaining how to set it up and use it.
Read full review
Oracle
Ab>initio, IBM Datastage 8.0
Read full review
Scalability
Matillion
There are multiple options to connect with Matillion in terms of sources and targets and the connections have been robust. There are also options for out of the box API that can be called through Matillion, but the list can be longer to cater for the more popular data providers. Matillion does also offer an option to build your own API profiles, but the information to do that can certainly be improved upon and on our talks with the vendor, it is in the works.
Read full review
Oracle
No answers on this topic
Return on Investment
Matillion
  • Saving us time reduces our need for headcount
  • Allows us to collaborate on data-eng pipelines in a transparent way with non-technical stakeholders, ensuring accuracy and continuity
  • Allows us a single platform to log and manage all of our pipelines to pin-point where something failed and why
  • Always has a solution to very common data engineering tasks, i.e., real-time data, connectors, pre-built workflows, etc.
Read full review
Oracle
  • It improved understanding of ETL functions. Data is consistent. The speed is pretty good.
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.