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 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."
"Matillion ETL is one hundred percent stable."
"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."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"It has improved the costs of managing my customer’s data."
"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's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The scalability is great. It's one of the reasons we chose the solution."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"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 feature that we use is the Knowledge Modules."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"The cost of the solution is high and could be reduced."
"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."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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."
"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."
"The initial setup is complex, especially if you also have to install a console."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"The resource management aspect of the solution could be improved."
"We used a third party to do the implementation of ODI."
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, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle Database. 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.