We performed a comparison between erwin Data Catalog by Quest and Matillion ETL based on real PeerSpot user reviews.
Find out what your peers are saying about Informatica, Alation, Collibra and others in Metadata Management."When you combine it with data lineage, every time you need to make a change, it allows you to do impact analysis on any changes and then connect to the end-users or data stewards so that they can be aware that a change is coming. That's one of the main benefits we use it for."
"The data catalog feature is pretty good."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"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)."
"It's been able to do everything we require."
"It has good integrations with Amazon Redshift and other AWS services."
"The product has a good user interface."
"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."
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"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."
"In the next release, we would like to have connections to more databases."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"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."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
erwin Data Catalog by Quest is ranked 12th in Metadata Management with 2 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. erwin Data Catalog by Quest is rated 7.6, while Matillion ETL is rated 8.6. The top reviewer of erwin Data Catalog by Quest writes "Helps with metadata management, saves time, and allows us to do impact analysis on any changes". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". erwin Data Catalog by Quest is most compared with Informatica Enterprise Data Catalog, Talend Open Studio, Oracle Data Integrator (ODI), WhereScape RED and Alation Data Catalog, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, SSIS and Informatica PowerCenter.
We monitor all Metadata Management 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.