

Informatica PowerCenter and ThoughtSpot compete in the data integration and analytics category. ThoughtSpot appears to have the upper hand due to its intuitive analytics and flexibility, especially for non-technical users.
Features: Informatica PowerCenter offers robust data integration, reliability in handling large data volumes, and comprehensive transformation tools. It provides strong ETL functionalities that make complex data processes straightforward. ThoughtSpot provides intuitive data analytics, AI-driven insights, and natural language processing, offering quick access to business intelligence.
Room for Improvement: Informatica PowerCenter should enhance its cloud capabilities, modernize the interface, and offer more flexible pricing. ThoughtSpot requires improvements in visualization customization, calendar flexibility, and enhanced data handling.
Ease of Deployment and Customer Service: Informatica PowerCenter is primarily deployed on-premises with reliable technical support, though user experiences vary. ThoughtSpot provides deployment flexibility via cloud options; while its technical support is rated positively, some users find it less comprehensive.
Pricing and ROI: Informatica PowerCenter is considered expensive, impacting smaller organizations despite its enterprise-level capabilities. ThoughtSpot offers competitive pricing, balancing it with ease of use, appealing to cost-conscious users seeking analytics solutions.
It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.
The investment we have made is tremendous; it has saved a lot of time and effort, and fewer people are needed.
The return on investment is very good, as I previously mentioned, because the development team has been reduced to half, and it has saved us around one hour per day since we switched to Informatica PowerCenter.
Using ThoughtSpot has resulted in significant time savings and improved business sales by allowing us to identify sellers and buyers across regions, facilitating targeted marketing.
Based on our implementation in one project, we are trying to raise more funding to expand its use.
This tool has really improved our decision-making by 70 to 80% because we are able to rely on insights from different data sources from different departments.
The documentation is thorough, and anyone with minimal knowledge of ETL can easily understand it and work through errors.
I like the technical support provided by Informatica.
I have occasionally needed to communicate with the technical support of Informatica PowerCenter, especially when raising cases for complex mappings and performance optimization to identify bottlenecks in transformations.
The solutions engineers, even after the POC period, just kept supporting us, even though it was not really their responsibility to keep supporting us.
I stopped opening tickets due to insufficient and untimely responses.
ThoughtSpot provides a dedicated customer success person and the ability to submit tickets online, with a response time of no more than a day.
In the cloud, scaling up and down becomes easy when working with cloud providers.
The scalability of Informatica PowerCenter is tremendous because we can install it on any of our employees' systems, and it handles each and every task very swiftly.
We can easily scale the memory and also the workflows.
Tableau, Power BI, or Looker have separate tools for preparation, customization, and storytelling.
The platform does not have technical problems with scaling data or connections.
As our data has grown, I have validated huge datasets and complex models without significant issues.
We are getting 100% uptime every day.
Informatica PowerCenter is stable and can scale well.
The product is very stable with very few issues encountered in production.
I use it primarily for large datasets, and it performs faster than regular data visualization tools such as Power BI, which has limits on dataset size.
The upgrades are smooth with no downtime, which is super important.
The responsiveness of accessing live data is exceptional and faster than most other BI tools.
With Informatica PowerCenter, I am looking for an AI interface that looks at the underlying data model of the databases and the metadata of the tables, allowing the developer to provide instructions on what data sources to connect to and how to apply or create Transformations.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
Informatica Cloud and its support becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing.
Currently, it is not as customizable as the options available on Power BI or Tableau.
Handling governance when there are many models and dashboards is complex.
Enhancing integration capabilities with other tools like DBT would also be beneficial as it would make our lives easier.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.
We haven't paid for it; our client had paid for this tool.
HubSpot is expensive.
ThoughtSpot's pricing is reasonable and in line with other BI tools.
The pricing, setup cost, and licensing for ThoughtSpot are competitive.
The system supports real-time integration, which is essential for many of my tasks.
Informatica monitors can be used to monitor the jobs that we run, and if there is any kind of failure, we can diagnose it right away.
Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload.
Its compatibility with most databases, including the latest from FlexMovely and Redshift, allows users to create joins and worksheets easily.
This alerting feature is very beneficial for our company at the moment, and we use it extensively.
When I upload a data dump, AI analytics suggest possible data visualizations and insights, which I can pin to dashboards or live boards for modification.
| Product | Mindshare (%) |
|---|---|
| ThoughtSpot | 2.3% |
| Informatica PowerCenter | 1.2% |
| Other | 96.5% |


| Company Size | Count |
|---|---|
| Small Business | 14 |
| Midsize Enterprise | 11 |
| Large Enterprise | 76 |
| Company Size | Count |
|---|---|
| Small Business | 5 |
| Midsize Enterprise | 1 |
| Large Enterprise | 18 |
Informatica PowerCenter is known for its robust data integration, scalability, and user-friendly interfaces. It simplifies data processing with real-time capabilities, handling large datasets efficiently. Its adaptability with diverse sources makes it suitable for complex data environments.
Informatica PowerCenter offers extensive transformation options with features like flow designer, mapping, and error handling, enhancing development efficiency. Its GUI interface allows seamless integration across different platforms, making it suitable for managing extensive datasets. Traceability and support cater to evolving data requirements, while adaptability with multiple sources aids in driving strategic data outputs. Some areas for improvement include a more robust cloud strategy, better documentation, and improved API integrations. Enhanced automation and setup processes could further refine the experience.
What are the key features of Informatica PowerCenter?Informatica PowerCenter plays a vital role in data integration and ETL processes for building data warehouses. Industries like banking, insurance, and healthcare utilize it for extracting, transforming, and loading data into target systems, supporting analytics, reporting, and compliance. Companies often transition to cloud environments for enhanced scalability and efficiency.
ThoughtSpot offers analytics through a user-friendly interface, empowering non-technical users to explore data swiftly with AI-driven insights and search-based analytics, making data access and modeling efficient.
ThoughtSpot is designed for intuitive data exploration, enabling users to generate custom analytics and reports without deep technical expertise. Its strength lies in natural language processing, scalability, and seamless data connectivity. Customizable dashboards and interactive visualizations help organizations in effective decision-making. The emphasis on self-service analytics supports real-time data queries and enhanced data modeling. While popular for its quick insights, users note a steep learning curve and complex UI, seeking more customization options, better connectivity, and visualization features. Price and usability challenges, along with desires for improved dashboard stability and integration, are noted for large enterprise deployments.
What are ThoughtSpot's key features?Industries leverage ThoughtSpot for self-service analytics, driving marketing, sales, and business intelligence operations. Companies benefit from its real-time data connectivity with modern data cloud platforms, enhancing internal operations through scalable data analysis. Non-technical users are empowered to perform ad-hoc analysis, data exploration, and visualize KPIs, optimizing strategic workflows across sectors.
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.