We performed a comparison between ETL Solutions Transformation Manager and Informatica PowerCenter based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is a reliable solution."
"Back in the day, we could only get reports and analyze what happened after the fact, but today now we can generate real-time insights. Transformation Manager feeds your data science projects. We generate models and then give them to the clients, so they can come up with real-time predictions and recommendations in addition to reporting."
"It is among the best, even if not widely known."
"It has good standard features for ETL development."
"I found the map links, work links, and workflows valuable. They are important features."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"Deployment was simple and straightforward."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"It reduces a lot of legacy coding."
"It is an excellent ETL tool."
"I like the completeness of the way I can build ETL workflows."
"There is room for improvement in the solution's visualization tool."
"Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing."
"They should build a functional architecture based on queuing."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"The pricing could be improved."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"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."
"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."
More ETL Solutions Transformation Manager Pricing and Cost Advice →
ETL Solutions Transformation Manager is ranked 32nd in Data Integration with 3 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. ETL Solutions Transformation Manager is rated 9.0, while Informatica PowerCenter is rated 8.0. The top reviewer of ETL Solutions Transformation Manager writes "It lets us create models so we can generate real-time predictions and insights for a our clients". On the other hand, the top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". ETL Solutions Transformation Manager is most compared with webMethods Integration Server, Axway AMPLIFY Application Integration, TIBCO Spotfire, Altair Monarch and Denodo, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue. See our ETL Solutions Transformation Manager vs. Informatica PowerCenter report.
See our list of best Data Integration vendors.
We monitor all 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.