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."The interface is very clean and clear."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"I like the completeness of the way I can build ETL workflows."
"Good product if you are trying implement data quality, data integration, and data management projects."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"We can scale the product."
"What I like the most is that we have to deal with less while writing the queries."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"The loading of data is the most valuable feature of Matillion ETL."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"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."
"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 most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"I found the initial setup very easy."
"Data transformations and rollups are easy to accomplish."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"I like the data vault implementations."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Support is absolutely excellent, efficient, and timely."
"Requires an established data center because there is no option for software as a service."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"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."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The cost of the solution is high and could be reduced."
"It needs integration with more data sources."
"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"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."
"The tool's lineage is very weak."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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."
"Customization could be better."
"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."
"Technical support isn't the best."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
Earn 20 points