We performed a comparison between Matillion ETL and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"It is pretty user-friendly, even for people who aren't super technical."
"It has good integrations with Amazon Redshift and other AWS services."
"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 can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"It has helped us to get onto the cloud quickly."
"The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources."
"Matillion ETL is one hundred percent stable."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"It's completely user-friendly."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The initial setup is easy."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"In the next release, we would like to have connections to more databases."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"The product must enhance its near-real-time data capture feature."
"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."
"It needs integration with more data sources."
"Performance can be improved for efficiency, and it can be made faster."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"Technical Support could be better."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"It needs easier security."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Matillion ETL is rated 8.6, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, Informatica PowerCenter and Fivetran, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Mule Anypoint Platform. See our Matillion ETL vs. Oracle Data Integrator (ODI) report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.