We performed a comparison between BMC Data Management for IMS and DB2 on zOS and Matillion ETL based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."BMC Data Management improved our data recovery process by simplifying it."
"I have worked with DB2's great features in the last five years. The IDAA feature transformed the vision of warehousing, business analytics, and big data at my bank. Besides the mainframe, I saw that this solution was evolutionary. It gives real-time information."
"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 user-friendly graphical interface."
"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."
"It has good integrations with Amazon Redshift and other AWS services."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"It's been able to do everything we require."
"DB2 is a hard tool to grasp. It's hard for users to learn how to use it. It's not easy to see how it works."
"One area for improvement with this product could be in providing clearer guidance and tools for disaster recovery planning and execution."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"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."
"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."
"The tool's lineage is very weak."
"Performance can be improved for efficiency, and it can be made faster."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
BMC Data Management for IMS and DB2 on zOS is ranked 21st in Database Development and Management with 2 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. BMC Data Management for IMS and DB2 on zOS is rated 8.6, while Matillion ETL is rated 8.6. The top reviewer of BMC Data Management for IMS and DB2 on zOS writes "Improves disaster recovery processes and offers an efficient CPU cycle optimization ". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". BMC Data Management for IMS and DB2 on zOS is most compared with AWS Database Migration Service, Qlik Replicate, Dataloader.io and IBM App Connect, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, Informatica PowerCenter and SSIS.
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.