Informatica PowerCenter vs Pyramid Analytics comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Informatica PowerCenter and Pyramid Analytics based on real PeerSpot user reviews.

Find out in this report how the two Data Visualization solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Informatica PowerCenter vs. Pyramid Analytics Report (Updated: November 2022).
657,849 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way.""It has a Data Catalog that uses the Model repository.""To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle.""We have found the PowerCenter and B2B data transformation most valuable.""The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth.""I like the completeness of the way I can build ETL workflows.""It's very easy to use it to develop mappings and workflows.""It has helped us monetize."

More Informatica PowerCenter Pros →

"It seems quite performant in analyzing multi-dimensional information sets and presenting them.""The on-premise version has quite good scalability."

More Pyramid Analytics Pros →

Cons
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard.""PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one.""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.""There is some room for improvement in terms of pricing.""The reputation of Informatica is that it is expensive.""Its scalability can be improved. It is not scalable.""Integrating new tools can be tricky and challenging.""Support could be better."

More Informatica PowerCenter Cons →

"The general amount of negative comments that I am hearing from my team makes me very wary.""I find that this is quite a heavy, time-consuming tool for developers."

More Pyramid Analytics Cons →

Pricing and Cost Advice
  • "I consider this to be an expensive product."
  • "It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
  • "The price of this solution is high."
  • "The solution is in the middle price range compared to other solutions."
  • "Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
  • "Our customers pay a licensing fee yearly."
  • "The price is mostly reasonable."
  • "According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products."
  • More Informatica PowerCenter Pricing and Cost Advice →

    Information Not Available
    report
    Use our free recommendation engine to learn which Data Visualization solutions are best for your needs.
    657,849 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up and… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free… more »
    Top Answer:Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge… more »
    Top Answer:It seems quite performant in analyzing multi-dimensional information sets and presenting them.
    Top Answer:I don't know how the licensing works, but I'd presume it's on a yearly basis.
    Top Answer:A few of our internal team members mentioned that they are struggling to find solid info on Pyramid training courses. We could really benefit from a video studio. Most of our team members are… more »
    Ranking
    2nd
    out of 58 in Data Visualization
    Views
    36,752
    Comparisons
    31,106
    Reviews
    39
    Average Words per Review
    479
    Rating
    7.9
    12th
    out of 58 in Data Visualization
    Views
    1,638
    Comparisons
    1,085
    Reviews
    2
    Average Words per Review
    577
    Rating
    6.5
    Comparisons
    Also Known As
    PowerCenter
    Learn More
    Pyramid Analytics
    Video Not Available
    Overview

    Informatica PowerCenter is a data integration and data visualization tool. The solution works as an enterprise data integration platform that helps organizations access, transform, and integrate data from various systems. The product is designed to support companies in the full cycle of a project, from its initial rollout to critical deployments. Informatica PowerCenter allows developers and analysts to collaborate while accelerating the work process to deploy projects within days instead of months.

    The Advanced edition of the product provides an additional real-time engine which allows companies to have always-on enterprise data integration. This ensures seamless collaboration and increment of data lineage visibility and impacts analysis.

    The Premium edition of the solution offers an early warning system that detects unexpected behaviors or incorrect utilization of resources in the workflows and alerts companies in the case that these occur. This version of the product also offers automatic data validation, which ensures data accuracy and reduces testing time and expenditure of resources for by up to 90%.

    Informatica PowerCenter Features

    The product provides users with various features which allow them to execute data integration initiatives such as analytics, data warehousing, data governance, consolidation, and application migration. The features of the solution include:

    • Collaboration: Informatica PowerCenter offers role-based tools and processes which enable business self-service while benefiting from high-quality IT resources.

    • Automation: Through various automations and easy-to-use software, users can utilize graphical and codeless tools and initiate effective data integration without additional knowledge.

    • Scalability: The tool provides high scalability to users, which ensures seamless performance and minimum downtime. PowerCenter also has adaptive load balancing, pushdown optimization, and dynamic partitioning.

    • Monitoring: Through the extensive monitoring feature, the operations and governance of the solution are easily overseen by users. The tool also provides alerts that can prevent damage to the system.

    • Real-time data: Through real-time data, users can monitor applications and analytics, ensuring their efficient operation.

    • Prototyping: Informatica lets its users collaborate with information technology to prototype, profile, and validate results in a timely manner.

    • Connectivity: Users can access and integrate data from different types of sources through high-performance connectors.

    • Automated data validation testing: The product offers script-free automated and repeatable audit and validation of data.

    • Data transformation: This feature allows users to use comprehensive parsing of JSON, PDF, XML, Microsoft Office, and the Internet of Things (IoT) for non-relation data.

    • Cloud applications connectivity: The product allows for seamless connection to cloud application sources and targets.

    Informatica PowerCenter Benefits

    The benefits of using Informatica PowerCenter include:

    • The tool can work over a wide range of systems and platforms and also allows for lean integration.

    • It enhances the quality and speed of performance and optimizes the cost of the process for your organization.

    • PowerCenter supports multiple databases, including TPump, Parallel Transporter Fastload, and Teradata MLoad.

    • The tool is very easy to monitor and maintain, which simplifies the data integration process for companies.

    • The centralized error logging system allows users to locate errors in a timely manner and correct them.

    • The tool can convert data from an application to another format, as it serves as one of the most powerful data transformation solutions.

    • PowerCenter can also serve as middleware between two applications.

    • The solution offers both parallel processing and load balancing.

    • PowerCenter is a tool with a high level of security, which also minimizes essential administration activities.

    • The solution ensures the quality of information, as it does not allow invalid or unwanted data to be uploaded to the source.

    Reviews from Real Users

    Yahya T., a developer and architect at L'Oreal, says the product is stable, provides good support, and integrating it with other systems is very fast.

    Mohamed E., a senior manager for Data management and data governance at a tech company, says PowerCenter is stable, mature, and offers flexibility in building the pipeline and has a drag-and-drop mode because it's GUI-based; technical support is brilliant.

    The BI Office from Pyramid Analytics is a web-based governed data discovery and analytics platform. It integrates the four principal functions of any comprehensive BI strategy into a single, seamless application. Users can now analyze, present, report and predict on their data in a single application. Pyramid Analytics has native apps to cover the entire mobile spectrum, iOS, Android and Windows. With BI Office users can integrate SAP data with data from other sources giving them the right tools and better data to make data-driven decisions.

    Offer
    Learn more about Informatica PowerCenter
    Learn more about Pyramid Analytics
    Sample Customers
    University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
    US Department of Veterans Affair, Volkswagen, Siemens, Blackboard, Hallmark, Orange, CDW, LA Fitness, Atelier GS, Memorial Healthcare, Acadia Insurance, BancoBic, Advanced Learning, Microsoft, Drake University
    Top Industries
    REVIEWERS
    Computer Software Company28%
    Financial Services Firm15%
    Retailer9%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Computer Software Company18%
    Financial Services Firm14%
    Insurance Company8%
    Comms Service Provider7%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Government13%
    Comms Service Provider11%
    Manufacturing Company10%
    Company Size
    REVIEWERS
    Small Business19%
    Midsize Enterprise10%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise11%
    Large Enterprise75%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise11%
    Large Enterprise69%
    Buyer's Guide
    Informatica PowerCenter vs. Pyramid Analytics
    November 2022
    Find out what your peers are saying about Informatica PowerCenter vs. Pyramid Analytics and other solutions. Updated: November 2022.
    657,849 professionals have used our research since 2012.

    Informatica PowerCenter is ranked 2nd in Data Visualization with 39 reviews while Pyramid Analytics is ranked 12th in Data Visualization with 2 reviews. Informatica PowerCenter is rated 7.8, while Pyramid Analytics is rated 6.6. 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". On the other hand, the top reviewer of Pyramid Analytics writes "Analyzes multi-dimensional information sets but lacks necessary documentation and training material". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, AWS Glue and Informatica PowerExchange, whereas Pyramid Analytics is most compared with Microsoft BI, Tableau, SAP Analytics Cloud, Databricks and Qlik Sense. See our Informatica PowerCenter vs. Pyramid Analytics report.

    See our list of best Data Visualization vendors.

    We monitor all Data Visualization 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.