We performed a comparison between Denodo and Matillion ETL 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."In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"It allows a lot of traceability and you can decide what data you want to collect"
"The ability to transfer data is very valuable."
"The best thing about Denodo is that creating and deploying a web service can be done in about 10 minutes, compared to a whole day when it comes to other solutions (such as when deploying with Java and AWS)."
"One thing that we have noticed is that when you have a BI tool, you end up building a lot of the logic in the BI tool, but as a company, every company wants to be tool agnostic because today, you could be in the Qlik Sense, and tomorrow, you may decide to go with Tableau or something else that is there. If you have put a lot of logic within the tool, transitioning or moving away from one BI tool to another tool becomes a very intensive process. By keeping the logic in Denodo, you can move to any tool."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"The ability to connect to a lot of different sources."
"In general, it's good for us to make tests so we can scout the data."
"It has good integrations with Amazon Redshift and other AWS services."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"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)."
"The loading of data is the most valuable feature of Matillion ETL."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The product's initial setup phase was easy."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"The integration could use improvement, it's a lot of non-speed line processes that we have discovered, in the country. The configurations could use a lot more improvement."
"Denodo's training documentation could be improved by providing more material. From an administrative standpoint, I've found that only Denodo websites provide the usual tutorials. It may be because it's a bit of a restricted tool, but it results in trouble with learning. Normally, I can find help and solutions from other sources, but I haven't been able to find any for Denodo. Other that, it's fine and it performs well. I only have six months of experience, so I can't accurately suggest improvements."
"Lacks integrations with AWS, GCP and the like."
"Performance management could be improved."
"We can't scale it to meet digital requirements."
"Tasks such as conversion of a date format or conversion of a number format that can be done in a very easy way in different languages, like SQL or Oracle, are not so easy to do in Denodo. For example, if you want to convert a date from one format to another, in Oracle it's pretty easy; in Denodo, however, it requires so many lines of code. Simple things that can be done very quickly in other database languages require more lines of code in Denodo."
"It would be good if the solution provided a much-needed cellular platform."
"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."
"In the next release, we would like to have connections to more databases."
"The product must enhance its near-real-time data capture feature."
"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."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"Performance can be improved for efficiency, and it can be made faster."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
Denodo is ranked 8th in Cloud Data Integration with 29 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. Denodo is rated 7.8, while Matillion ETL is rated 8.6. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Informatica PowerCenter, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, Informatica PowerCenter and SSIS. See our Denodo vs. Matillion ETL 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.