Try our new research platform with insights from 80,000+ expert users

Matillion ETL vs Oracle Integration Cloud Service comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Matillion ETL
Average Rating
8.4
Reviews Sentiment
7.4
Number of Reviews
26
Ranking in other categories
Cloud Data Integration (5th)
Oracle Integration Cloud Se...
Average Rating
7.8
Reviews Sentiment
7.4
Number of Reviews
36
Ranking in other categories
Integration Platform as a Service (iPaaS) (4th)
 

Mindshare comparison

Matillion ETL and Oracle Integration Cloud Service aren’t in the same category and serve different purposes. Matillion ETL is designed for Cloud Data Integration and holds a mindshare of 4.1%, down 5.4% compared to last year.
Oracle Integration Cloud Service, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 9.2% mindshare, down 11.3% since last year.
Cloud Data Integration
Integration Platform as a Service (iPaaS)
 

Featured Reviews

AntonHaupt - PeerSpot reviewer
Efficient data integration and transformation with seamless cloud-native integration
In our small business unit, we currently have around four users, with two of them utilizing Matillion within our organization. Considering our growing needs, we're contemplating transitioning to an enterprise SaaS solution where we would share the same instance. Currently, each user is billed individually, but consolidating to a shared instance seems more efficient. Scalability is excellent when using the SaaS solution, easily reaching a rating of ten out of ten. Each data pipeline request is encapsulated within a Docker container and spun off, allowing for instant scalability. Overall, I would rate it a nine out of ten in terms of performance and scalability.
Divya Prakash - PeerSpot reviewer
An integration tool that is highly compatible and easy to maintain
Dealing with the large file sizes has occasionally been a challenge, though we have found workarounds. But dealing with large file sizes could be easy in integrations. I have also come across schema files where headers, footers, and bodies are there, but it's not a valid schema. None of the MSCAs are defined properly. In such cases, we have to think of multiple workarounds, such as splitting or merging. But this is a standard requirement for organizations, so custom solutions should be provided. There are cases when the systems don't expect additional MSCAs, or they expect headers, footers, or tags with different values. But this is not a proper XML. So if we are dealing with XML conversions, mapping, and integrations, we have to do some custom work. These are solutions that Oracle can provide.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."
"The loading of data is the most valuable feature of Matillion ETL."
"We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL)."
"It has improved the costs of managing my customer’s data."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"It's been able to do everything we require."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"The product's initial setup phase was easy."
"The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value."
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"Provides various ways to secure services as well as providing extensive support."
"The solution is scalable."
"The product's initial setup phase is simple."
"There are many functionalities. Fundamentally, it provides all the ready-to-use services for consumption between SaaS and other applications."
"We mainly use the solution's ICS component."
"The most valuable features of Oracle Integration Cloud Service are the seeded integrations with many communication platforms, such as Slack and emails. It works best for the historical communication methods. Those are still prevalent with all the other clients. When we are doing the integrations, it makes it a little bit easier for us to communicate the same output over Slack, rather than sending out an email and downloading the report. The number of seeded functionalities within the Oracle Integration Cloud Service platform is better."
 

Cons

"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."
"The product's scalability needs improvement. Perhaps adding more connectors would be beneficial."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"The cost of the solution is high and could be reduced."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"The tool's lineage is very weak."
"While most of the adapters are available through Oracle Integration Cloud Services, they do not have a lot of features. I would like to see some enrichment in this area and for the solution to go deeper into the applications and upgrade the adapters."
"Our client was quite concerned about the cost, which is something that could be reduced."
"The solution should improve its support."
"Make it more similar to the on-premises features. For example, if you can edit the code directly rather than just dragging and dropping, or if you can edit the examples by going into the background, and one-click migration, I'd like to see included in the next release."
"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"I have faced situations where the solution has gone down for five to seven minutes, which is an issue if it happens in the live production environment."
"Lacks features for more complex integrations."
"We would love to have more and more ready-to-use interfaces from Oracle."
 

Pricing and Cost Advice

"The pricing depends on what edition the customer opts for. For example, the standard edition is priced at $2.00 per credit. And you are only charged when you use it. You're not charged when it's idle."
"Matillion ETL is expensive."
"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."
"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."
"I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."
"Matillion ETL has a pay-as-you-go pricing model of a few dollars per hour of runtime."
"It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."
"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
"The price of Oracle Integration Cloud Service is good. It is reasonable and is priced well for the market segment. The model they use is on a per-package unit and we have a two-year subscription."
"The solution is less expensive than other products."
"Its pricing is relatively lower than other vendors."
"Oracle uses a universal credit model for OCI. Clients commit to an annual budget and can choose which products to use and build during their contract period. Billing is based on consumption - you're only billed for the products you use."
"In the case of Oracle Integration Cloud, costs can be "predictable" as far as the platform and infrastructure are concerned."
"The price is fair."
"It specifies how much data you use and how much storage you require, among other things."
"Pricing is not on the economic side since it is a tool for enterprise-sized companies."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
825,399 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
14%
Manufacturing Company
9%
Government
6%
Educational Organization
44%
Computer Software Company
8%
Financial Services Firm
7%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Matillion ETL?
The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
What is your experience regarding pricing and costs for Matillion ETL?
The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...
What needs improvement with Matillion ETL?
Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that c...
What do you like most about Oracle Integration Cloud Service?
Oracle Integration Cloud Service offers a lot of adaptors.
What is your experience regarding pricing and costs for Oracle Integration Cloud Service?
It is not really a high price for the value it gives. However, when you start doing the customization, it’s a bit expensive because I need to start provisioning other services before deployment. So...
 

Also Known As

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
Oracle ICS
 

Learn More

 

Overview

 

Sample Customers

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
Calix, Avaya, Land Lakes, Leader, PWC, Vale
Find out what your peers are saying about Matillion ETL vs. Oracle Integration Cloud Service and other solutions. Updated: July 2023.
825,399 professionals have used our research since 2012.