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 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 most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."
"The product's initial setup phase was easy."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."
"The loading of data is the most valuable feature of Matillion ETL."
"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."
"It is pretty user-friendly, even for people who aren't super technical."
"The product has an ELT approach."
"It has the ability to easily load slowly changing dimensions."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"Oracle provides great documentation."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most valuable feature is Data movement."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"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."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"Performance can be improved for efficiency, and it can be made faster."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"I am looking forward to seeing the expansion of the source range for their data loader 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."
"We used a third party to do the implementation of ODI."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"If you have something like Cisco on top of it, you will have endless problems."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 68 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, SSIS and SnapLogic, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Azure Data Factory and Palantir Foundry. 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.