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
Number of Reviews
26
Ranking in other categories
Cloud Data Integration (5th)
Oracle Integration Cloud Se...
Average Rating
7.8
Number of Reviews
36
Ranking in other categories
Integration Platform as a Service (iPaaS) (3rd)
 

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.4%, down 6.0% compared to last year.
Oracle Integration Cloud Service, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 9.6% mindshare, down 11.2% since last year.
Cloud Data Integration
Integration Platform as a Service (iPaaS)
 

Featured Reviews

AntonHaupt - PeerSpot reviewer
Jan 23, 2024
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
Jun 15, 2023
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

"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"It has good integrations with Amazon Redshift and other AWS services."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"The product is quite stable and can handle complex data integration tasks well."
"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."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The solution's most valuable feature is the CDC (Change Data Capture) component."
"Oracle Integration Cloud Service is a really good product and the ROI is very good with it. It lowers development time. A development cycle that may have taken a year without Oracle Integration Cloud Service can drop down to three or four months with it."
"It is a scalable solution."
"People are able to scale up, learn it quickly, and start delivering."
"The solution is scalable."
"There are many functionalities. Fundamentally, it provides all the ready-to-use services for consumption between SaaS and other applications."
"The initial setup of Oracle Integration Cloud Service was easy."
"In general, there were a lot of great utilities for working with files."
"The out-of-box integration between Oracle and SAP is really beneficial"
 

Cons

"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems."
"It needs integration with more data sources."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"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."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"There are a few features that we noticed are not in the cloud. There are some improvements needed. One example is the graphical user interface that needs to improve, it could be easier to use."
"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."
"It has lengthy documentation, making the process of building applications more time-consuming."
"The solution's customer service could be better."
"Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release."
"They should provide tutorials for beginners to learn about the processes."
"The bulk processing needs improvement."
"The solution is expensive."
 

Pricing and Cost Advice

"Matillion ETL is expensive."
"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."
"Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."
"I think it is cost conscious. It used to be very cheap and they have more recently bumped up the pricing, so it is competitive now."
"The solution is very cheap. You're paying $2.50 an hour and if you set your service up, which you can do, you're not getting charged. Currently, our ETL process is just an overnight process that runs for about an hour. I can start and stop my server just for an hour if I want to and spent $2.50 a day for an ETL solution. There are no additional costs."
"The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running."
"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
"The AWS pricing and licensing are a cost-effective solution for data integration needs."
"The solution is less expensive than other products."
"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 price of Oracle Integration Cloud Service is reasonable to start with, but when you scale it becomes expensive."
"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."
"Its pricing is relatively lower than other vendors."
"Pricing is not on the economic side since it is a tool for enterprise-sized companies."
"The price is fair."
"It specifies how much data you use and how much storage you require, among other things."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Computer Software Company
15%
Manufacturing Company
9%
Government
6%
Educational Organization
41%
Computer Software Company
9%
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.
814,649 professionals have used our research since 2012.