Informatica PowerCenter and AWS Glue are competitors in the data integration and ETL category. AWS Glue seems to have the upper hand due to its seamless integration within the AWS ecosystem and cost-effective serverless architecture.
Features: Informatica PowerCenter supports large data volumes, security, and scalability, offering extensive transformation functions, error handling, and debugging. It integrates efficiently across various data sources. AWS Glue integrates seamlessly within AWS and provides real-time processing, leveraging serverless architecture with cost-effective management, making it ideal for AWS users.
Room for Improvement: Informatica PowerCenter's pricing and complex interface pose challenges for beginners. Improvements in cloud integration and scalability are needed. AWS Glue requires enhancements in user-friendliness and more robust monitoring, debugging, and support for non-AWS data integration.
Ease of Deployment and Customer Service: Informatica PowerCenter is praised for its responsive technical support and appeals to enterprises needing on-premises solutions. AWS Glue benefits from AWS's infrastructure with cloud-native deployment but may be less intuitive for non-technical users. Its customer service handles issues adequately but faces challenges with complex problems.
Pricing and ROI: Informatica PowerCenter is a costly premium solution suitable for large enterprises with complex needs, offering high ROI despite heavy investment. AWS Glue’s pay-as-you-go model is cost-effective for cloud-native environments, providing flexibility while pricing may increase with higher usage. AWS Glue is appealing to organizations seeking scalable cloud-based solutions.
I advocate using Glue in such cases.
AWS's documentation is reliable, and careful reference often resolves missed upgrade details.
I like the technical support provided by Informatica.
It can easily handle data from one terabyte to 100 terabytes or more, scaling nicely with larger datasets.
For jobs requiring multiple RAM usage, we increase the number of workers accordingly.
AWS Glue is highly stable, and I would rate its stability as nine.
Informatica PowerCenter is stable and can scale well.
A more user-friendly and simpler process would help speed up the deployment process.
With AWS, I gather data from multiple sources, clean it up, normalize it, de-duplicate it, and make it presentable.
Migrating jobs from version 3.0 to 4.0 can present compatibility issues.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
The smallest cost for a project is around €700, while the largest can reach up to €7,000 based on the scale of the usage.
AWS charges based on runtime, which can be quite pricey.
Costing depends on resource usage, and cost optimization may involve redesigning jobs for flexibility.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
AWS Glue's most valuable features include its transformation capabilities, which provide data quality and shape for processing in ML or AI models.
For ETL, I feel the performance is excellent. If I create jobs in a standard way, the performance is great, and maintenance is also seamless.
I think if I'm working with big data, common languages like Python work quite nicely, which is advantageous.
The system supports real-time integration, which is essential for many of my tasks.
AWS Glue is a serverless cloud data integration tool that facilitates the discovery, preparation, movement, and integration of data from multiple sources for machine learning (ML), analytics, and application development. The solution includes additional productivity and data ops tooling for running jobs, implementing business workflows, and authoring.
AWS Glue allows users to connect to more than 70 diverse data sources and manage data in a centralized data catalog. The solution facilitates visual creation, running, and monitoring of extract, transform, and load (ETL) pipelines to load data into users' data lakes. This Amazon product seamlessly integrates with other native applications of the brand and allows users to search and query cataloged data using Amazon EMR, Amazon Athena, and Amazon Redshift Spectrum.
The solution also utilizes application programming interface (API) operations to transform users' data, create runtime logs, store job logic, and create notifications for monitoring job runs. The console of AWS Glue connects all of these services into a managed application, facilitating the monitoring and operational processes. The solution also performs provisioning and management of the resources required to run users' workloads in order to minimize manual work time for organizations.
AWS Glue Features
AWS Glue groups its features into four categories - discover, prepare, integrate, and transform. Within those groups are the following features:
AWS Glue Benefits
AWS Glue offers a wide range of benefits for its users. These benefits include:
Reviews from Real Users
Mustapha A., a cloud data engineer at Jems Groupe, likes AWS Glue because it is a product that is great for serverless data transformations.
Liana I., CEO at Quark Technologies SRL, describes AWS Glue as a highly scalable, reliable, and beneficial pay-as-you-go pricing model.
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 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.