Informatica PowerCenter vs Tableau comparison

Cancel
You must select at least 2 products to compare!
Tableau Logo
12,563 views|10,902 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Informatica PowerCenter and Tableau 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. Tableau Report (Updated: March 2024).
765,234 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
"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.""The setup is very simple.""Once you have learned Informatica, it is very easy to use.""It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective.""Informatica PowerCenter is a very good ETL tool.""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 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.""It has good standard features for ETL development."

More Informatica PowerCenter Pros →

"It is easy to use, and it can handle a large amount of data.""It is very good for data visualization. It has very powerful visualizations and is easy to use.""While using this solution I have found the valuable features to be ease of use and the visualization. It is a complete solution.""Analysis is now more visual than in the past.""From the data science point of view, we use it for model building purposes. For example, if we are using it for a bank and we want to understand how much loan the bank can provide, we can use visualization to show the educational qualification, salary, gender, and city of a customer, and by using this information, we can arrive at the loan amount that this person is eligible for. I can also use it to view all prospective customers, so essentially, this is going to help me in model building as well as in understanding and segmenting customers and doing forecasting and predictive analytics. We use model widgets, and we can create thousands of visualizations, such as motion charts and bubble charts. We can also create animated versions of the graphs and view the data from multiple dimensions. These are the features that we typically use and like.""Visualization attributes: Marks – Color, Size, Label, etc.. Easily Accessible and Intuitive.""Any feature I am looking for usually is part of the next upgrade within a few months. They have a very good dynamic evolution.""Tableau's initial setup was straightforward."

More Tableau Pros →

Cons
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux.""There can be scalability issues. Huge amounts of data ingestion will impact performance.""Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers.""The reputation of Informatica is that it is expensive.""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.""The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease.""There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce.""Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."

More Informatica PowerCenter Cons →

"We need big servers to perform the operations that we are doing. They should probably relook at its architecture.""There are not enough language options. It needs to be offered in more than just English.""The performance could be better.""When I've done presentations in the past, I've had issues with uploading the cartography.""I have noticed that Tableau is not very compatible with ClickHouse. There's no direct connection to ClickHouse; you have to set up an ODBC connection.""Tableau's data modeling, mining, and AI library features need improvement.""In the cloud sometimes the performance is a little bit slow.""Lacks machine learning algorithms that you can implement using R, SPSS Modeler, and Python."

More Tableau Cons →

Pricing and Cost Advice
  • "We have found the pricing very cost-effective. The licensing is CPU and data source-based."
  • "Cost could be improved."
  • "Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With health insurance, you don't know whether you will get sick or need to go to hospital or not but you have to have insurance. It's the same thing with support. If you have that expertise in resolving issues, if you have enough experience in your IT department, I would say you don't need the support. But in practice, they recommend you go with the support. If you want support you have to pay for it."
  • "Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis."
  • "Its maintenance is expensive."
  • "It's much more expensive, almost three times more expensive than most other solutions."
  • "We are satisfied with the pricing."
  • "I consider this to be an expensive product."
  • More Informatica PowerCenter Pricing and Cost Advice →

  • "For big business, Tableau could be expensive as having a lot of Tableau server users (entering with a browser to reports) could be a bit expensive."
  • "Best advice on pricing is to anticipate the desire for more licenses once the results of this product are acknowledged in other parts of your company."
  • "Paying for users you never setup or buying expensive desktop licenses for users who can solve their users with web editing on the server are the two biggest expenses."
  • "Buy 50 at a time. Project your use base every three months, and project your requirements forward."
  • "Tableau can be costly (but this can be indefinable, such as user experience vs. cheaper etc.)"
  • "I wish there was more of a subscription model with the pricing when it comes to Tableau, so you can get all the latest version upgrades/features if you pay monthly/annually."
  • "The cost is high."
  • "Deployment of dashboards to viewers and unit supervisors can be prohibitively expensive."
  • More Tableau Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Visualization solutions are best for your needs.
    765,234 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    After a recent presentation, several attendees asked me about the applications of Visual Insights and Tableau. Many companies are investing in both tools and are trying to figure out the right tool for specific applications Tableau has found its sweet-spot as an agile discovery tool that analysts use to create and share insights. It is also the tool of choice for rapid prototyping of dashboards. Tableau is very flexible with its data import. Tableau's data blending capability is very intuitive. This capability is useful when you have data spread across several different sources that has not gone through ETL processes. This is a problem analysts deal with routinely. They are unable to wait for the data warehouse team to develop ETL processes to provide the physical models they need to build an analysis. The Tableau interface is Excel-like and has a low barrier to entry for analysts that are used to working in Excel. Building a dashboard by mashing up visualizations in a Tableau worksheet is extremely simple. Users are able to build good presentation-quality dashboards in a very short amount time. Tableau's annotations capabilities and its time and geographical intelligence are key differentiators. Tableau has overcome limitations in data sharing with the introduction of a Data Server in Tableau 7.0. The Data server allows Data sources and extracts to be shared securely and opens up interesting new possibilities. If your application can take advantage of the above… Read more →
    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 depends on the Data architecture and the complexity of your requirement Some great tools in the market are Qlik Sense, Power BI, OBIEE, Tableau, etc. I have recently started using Cognos… more »
    Top Answer:Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have been working on and off Tableau for about a year, but getting to work on it… more »
    Top Answer:Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use. This relatively short amount of time can make all the difference for companies… more »
    Ranking
    4th
    out of 70 in Data Visualization
    Views
    729
    Comparisons
    689
    Reviews
    30
    Average Words per Review
    472
    Rating
    7.6
    1st
    out of 70 in Data Visualization
    Views
    12,563
    Comparisons
    10,902
    Reviews
    19
    Average Words per Review
    620
    Rating
    8.6
    Comparisons
    Also Known As
    PowerCenter
    Tableau Desktop, Tableau Server, Tableau Online
    Learn More
    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.

    Tableau is a tool for data visualization and business intelligence that allows businesses to report insights through easy-to-use, customizable visualizations and dashboards. Tableau makes it exceedingly simple for its customers to organize, manage, visualize, and comprehend data. It enables users to dig deep into the data so that they can see patterns and gain meaningful insights. 

    Make data-driven decisions with confidence thanks to Tableau’s assistance in providing faster answers to queries, solving harder problems more easily, and offering new insights more frequently. Tableau integrates directly to hundreds of data sources, both in the cloud and on premises, making it simpler to begin research. People of various skill levels can quickly find actionable information using Tableau’s natural language queries, interactive dashboards, and drag-and-drop capabilities. By quickly creating strong calculations, adding trend lines to examine statistical summaries, or clustering data to identify relationships, users can ask more in-depth inquiries.

    Tableau has many valuable key features:

    • Tableau dashboards provide a complete view of your data through visualizations, visual objects, text, and more.
    • Tableau provides convenient, real-time options to collaborate with other users and instantly share data in the form of visualizations, sheets, and dashboards. 
    • Tableau ensures connectivity to both live data sources and data extraction from external data sources as in-memory data. This gives users the flexibility to use data from more than one source without any restrictions. 
    • Tableau gives many data source option, ranging from spreadsheets, big data, on-premise files, relational databases, non-relational databases, data warehouses, and big data, to on-cloud data. 
    • Tableau has a lot of pre-installed information on maps, such as cities, postal codes, and administrative boundaries. 
    • Tableau has a foolproof security system based on authentication and permission systems for data connections and user access. Tableau also gives you the freedom to integrate with other security protocols.

    Tableau stands out among its competitors for a number of reasons. Some of these include its fast data access, easy creation of visualizations, and its stability. PeerSpot users take note of the advantages of these features in their reviews:

    Romil S., Deputy General Manager of IT at Nayara Energy, notes, "Its visualizations are good, and its features make the development process a little less time-consuming. It has an in-memory extract feature that allows us to extract data and keep it on the server, and then our users can use it quickly.

    Ariful M., Consulting Practice Partner of Data, Analytics & AI at FH, writes, “Tableau is very flexible and easy to learn. It has drag-and-drop function analytics, and its design is very good.

    Sample Customers
    University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
    Accenture, Adobe, Amazon.com, Bank of America, Charles Schwab Corp, Citigroup, Coca-Cola Company, Cornell University, Dell, Deloitte, Duke University, eBay, Exxon Mobil, Fannie Mae, Ferrari, French Red Cross, Goldman Sachs, Google, Government of Canada, HP, Intel, Johns Hopkins Hospital, Macy's, Merck, The New York Times, PayPal, Pfizer, US Army, US Air Force, Skype, and Walmart.
    Top Industries
    REVIEWERS
    Computer Software Company22%
    Financial Services Firm20%
    Retailer7%
    Insurance Company7%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Computer Software Company12%
    Manufacturing Company8%
    Insurance Company7%
    REVIEWERS
    Computer Software Company12%
    Financial Services Firm12%
    University7%
    Healthcare Company7%
    VISITORS READING REVIEWS
    Educational Organization34%
    Financial Services Firm11%
    Computer Software Company8%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Small Business32%
    Midsize Enterprise18%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise39%
    Large Enterprise47%
    Buyer's Guide
    Informatica PowerCenter vs. Tableau
    March 2024
    Find out what your peers are saying about Informatica PowerCenter vs. Tableau and other solutions. Updated: March 2024.
    765,234 professionals have used our research since 2012.

    Informatica PowerCenter is ranked 4th in Data Visualization with 78 reviews while Tableau is ranked 1st in Data Visualization with 290 reviews. Informatica PowerCenter is rated 8.0, while Tableau is rated 8.4. 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 Tableau writes "Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and StreamSets, whereas Tableau is most compared with Microsoft Power BI, Amazon QuickSight, Domo, SAS Visual Analytics and SAP Analytics Cloud. See our Informatica PowerCenter vs. Tableau 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.