Thursday, March 28, 2024

Informatica PowerCenter: Product Overview and Insight

Datamation content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

Bottom Line:

Very highly rated by analysts and users, Informatica’s data integration products are among the best in the market. PowerCenter’s claim to fame is its metadata-driven management, which provides advanced capabilities and improves ease of use. Out of the box, PowerCenter is less full-featured than some of the other data integration platforms on the market, but Informatica offers plenty of add-ons and additional software that fill in the gaps. It’s ideal for medium to large enterprises, particularly for those looking for a product that encourages collaboration between IT and business users.

See Informatica PowerCenter user reviews.

Jump to: Informatica PowerCenter Features Table

Company Description:

As an enterprise cloud data management vendor, Informatica focuses on big data, data security, data quality, data integration and master data management software. Founded in 1993, the company has its headquarters in Redwood City, California, and it has more than 3,900 employees. It boasts more than 9,000 customers, including 85 of the companies on the Fortune 100 list. Noteworthy customers include the AARP, Ace Hardware, the U.S. Air Force, BMC Software, BT, CA Technologies, the Chicago Cubs, Comcast, eBay, FannieMae, HP, Humana, Michigan State University, Nissan, PayPal, Qualcomm, Thomon Reuters, Thrifty Car Rental, Toshiba, Valero, Unilever, Verizon, Western Union and others. It processes more than 2.5 trillion cloud transactions every month.

The company was previously traded on the NASDAQ exchange under the symbol INFA. In 2015, it was acquired by Permira, the Canada Pension Plan Investment Board, Microsoft and Salesforce Ventures for approximately $3.5 billion. Since then, it has been privately held. Informatica’s annual revenue is more than $1 billion.

Product Description:

Informatica describes PowerCenter as “metadata-driven data integration platform.” It promises business and IT collaboration, automation, universal connectivity, rapid prototyping, scalability, automated data validation testing, advanced data transformation, operations and governance oversight, zero downtime, cloud connectivity and real-time capabilities. It comes in three different versions: Standard, Advanced (which adds high-performance optimization and a real-time engine) and Premium (which adds comprehensive automatic data validation, unstructured and semi-structure data transformations and an early warning alert system for unexpected behaviors or resource usage). The company claims that most PowerCenter users reduce IT costs by more than 40 percent and increase staff productivity by more than 40 percent.

Informatica received the highest rating and was listed in the Leaders quadrant in the most recent Gartner Magic Quadrant for Data Integration Tools and the Magic Quadrant for integration platform as a service (iPaaS). The report added, “Informatica continues to be the vendor most referenced by Gartner clients. It appears in more than 75% of the contract review calls for data integration tools and features most frequently in competitive situations on our inquiry calls.”

Features:

Deployment:

On premises or on Amazon Web Services (AWS) or Microsoft Azure

Licensing:

Proprietary

System Requirements:

The on-premises version of PowerCenter runs on Windows, Linux or AIX and requires 6 GB RAM and 10 GB disk space. Additional requirements will depend on the configuration of the software.

Connectors

PowerCenter connectors are available through an add-on called PowerExchange Connectors. It includes connectors for databases, data warehouses, Hadoop, messaging systems, enterprise applications, mainframes, midrange systems, social media networks and cloud applications. Additional add-ons are available for more cloud applications and change data capture.

Design and Development Environment:

Graphical, code-less environment

Key Capabilities

  • Business and IT collaboration features
  • Code-less development environment
  • Automation
  • Meta-driven data management
  • Scalability
  • Fast performance
  • Zero downtime
  • Universal connectivity
  • Rapid prototyping, profiling and validation
  • Business glossary
  • Advance data transformation
  • Real-time engine
  • Cloud connectivity

Support and Services:

Certification, training, support and services are available.

Pricing:

AWS pricing starts at $3.50 per hour ($24,528 per year). Azure and on-premises pricing not disclosed.

Informatica PowerCenter Features Table

Features Informatica PowerCenter
Deployment On premises, AWS, or Microsoft Azure
System Requirements
Operating System Windows, Linux, AIX
Processor Depends on configuration
RAM 6 GB
Storage 10 GB
Software Depends on configuration
Connectors Available through an add-on
Design and Development Environment Graphical, code-less
Key Capabilities
ELT Yes
ETL Yes
CDC Available through an add-on
Data Quality No (available through other Informatica products)
Data Governance No (available through other Informatica products)
Others Metadata-driven management, automated data validation testing, real-time engine, machine learning
Support and Services Certification, training, support, services
Gartner Magic Quadrant Rating Leader
Price AWS pricing starts at $3.50 per hour ($24,528 per year). Azure and on-premises pricing not disclosed.

Subscribe to Data Insider

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more.

Similar articles

Get the Free Newsletter!

Subscribe to Data Insider for top news, trends & analysis

Latest Articles