Informatica PowerCenter and Databricks compete in the data integration and analytics category. Databricks appears to have an advantage with its flexible, cloud-based solution, especially suited for big data analytics, AI, and machine learning.
Features: Informatica PowerCenter stands out for its ability to handle large data volumes, integration of multiple data sources, and robust transformation capabilities. Databricks offers a comprehensive cloud-based environment that supports multiple programming languages, seamless integration for data processing, and an environment conducive to collaboration.
Room for Improvement: Informatica PowerCenter is often noted for its high cost and complexity, with limitations in handling unstructured data, integration with big data tools like Hadoop, and occasionally problematic GUI elements. Databricks could enhance its visualization features, improve pricing transparency, and expand library support for machine learning and integration with other business intelligence tools.
Ease of Deployment and Customer Service: Informatica PowerCenter primarily supports on-premises deployment, which can be complex and requires skilled personnel. Its customer service experiences mixed reviews. Databricks, deployed mainly in the cloud, receives positive remarks for scalability and integration capabilities across cloud platforms, though users suggest the need for faster problem resolution and more comprehensive documentation.
Pricing and ROI: Informatica PowerCenter is perceived as expensive, with less flexible pricing suited for large enterprises. In contrast, Databricks operates on a pay-as-you-go model, often seen as cost-effective relative to its features, though costs can add up depending on usage. Users frequently mention Databricks' pricing as aligned with its extensive feature set, offering good value for data analytics and machine learning tasks.
When it comes to big data processing, I prefer Databricks over other solutions.
For a lot of different tasks, including machine learning, it is a nice solution.
Whenever we reach out, they respond promptly.
I like the technical support provided by Informatica.
The patches have sometimes caused issues leading to our jobs being paused for about six hours.
They release patches that sometimes break our code.
Cluster failure is one of the biggest weaknesses I notice in our Databricks.
Informatica PowerCenter is stable and can scale well.
We prefer using a small to mid-sized cluster for many jobs to keep costs low, but this sometimes doesn't support our operations properly.
If I could right-click to copy absolute paths or to read files directly into a data frame, it would standardize and simplify the process.
We use MLflow for managing MLOps, however, further improvement would be beneficial, especially for large language models and related tools.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
Databricks' capability to process data in parallel enhances data processing speed.
Developers can share their notebooks. Git and Azure DevOps integration on the Databricks side is also very helpful.
The system supports real-time integration, which is essential for many of my tasks.
Databricks is utilized for advanced analytics, big data processing, machine learning models, ETL operations, data engineering, streaming analytics, and integrating multiple data sources.
Organizations leverage Databricks for predictive analysis, data pipelines, data science, and unifying data architectures. It is also used for consulting projects, financial reporting, and creating APIs. Industries like insurance, retail, manufacturing, and pharmaceuticals use Databricks for data management and analytics due to its user-friendly interface, built-in machine learning libraries, support for multiple programming languages, scalability, and fast processing.
What are the key features of Databricks?
What are the benefits or ROI to look for in Databricks reviews?
Databricks is implemented in insurance for risk analysis and claims processing; in retail for customer analytics and inventory management; in manufacturing for predictive maintenance and supply chain optimization; and in pharmaceuticals for drug discovery and patient data analysis. Users value its scalability, machine learning support, collaboration tools, and Delta Lake performance but seek improvements in visualization, pricing, and integration with BI tools.
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:
Informatica PowerCenter Benefits
The benefits of using Informatica PowerCenter include:
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.
We monitor all Cloud Data Warehouse 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.