We performed a comparison between Informatica PowerCenter, Matillion ETL, and WhereScape RED 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."It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"In the end, you have structured, proper data for use in an integrated BI solution."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"It has a Data Catalog that uses the Model repository."
"Once you have learned Informatica, it is very easy to use."
"The ability to scale through partitions helped us to improve the performance."
"It is pretty user-friendly, even for people who aren't super technical."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"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."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"The product's initial setup phase was easy."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Naturally produces a way to easily debug your DW data solutions."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"The most valuable feature is the metadata generated code."
"The tool supports multiple target update methods."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"Its scalability can be improved. It is not scalable."
"I would like to see an improvement in the digital adoption."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"Integration with Artificial Intelligence would benefit this solution."
"The UI is a little outdated."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"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."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"The tool's lineage is very weak."
"In the next release, we would like to have connections to more databases."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"Improve the object renaming ability (it works, but it could be more automated)."
"No support for change data capture or delta detection - that must be custom coded ."
"Customization could be better."
Earn 20 points