PowerCenter Advanced Edition

Manage Change and Deliver Trusted Data

Informatica PowerCenter Advanced Edition provides the visibility, control, and scalability to manage change in complex data integration environments – regardless of underlying deployment platform, application or technologies.

Informatica PowerCenter Advanced Edition, powered by Vibe™, is for IT organizations that are standardizing data integration at an enterprise level, across numerous projects and departments. It provides all the capabilities of Informatica PowerCenter Standard Edition and includes management, control, and collaboration capabilities that are ideally suited for enterprise-wide use and initiatives such as regulatory compliance, data governance, and Integration Competency Centers.

• Achieve broader data governance and ensure regulatory compliance by providing the business with timely, relevant, and trustworthy data
• Execute mission-critical data integration initiatives that span the entire enterprise
• Accelerate time to delivery and reduce costs by improving cross-functional team collaboration and productivity
• Insulate yourself from uncertainties surrounding emerging data-centric compute platforms and challenges of data fragmentation by reusing PowerCenter mappings in a map once, deploy anywhere paradigm.

• Gartner Magic Quadrant for Data Integration Tools

Informatica PowerCenter Advanced Edition Key Features

Metadata Manager

• Collects metadata across a data integration environment and provides a graphical view of the data flows and the tools to manage change within that environment
• Shows developers an impact analysis of what data objects will be impacted by a proposed change before it is implemented

Business Glossary

• Provides a business context to technical artifacts related to data integration, making it possible to catalog, govern, and use data consistently and efficiently
• Provides collaboration features to speed up and improve the quality of communication between business and IT—reducing project delivery times and improving data integrity

Dynamic Partitioning

• Enables concurrent data processing to enhance the performance and scalability of data integration environments
• Supports multiple partition schemes, including parallelization through such multiple mechanisms as key range, hash algorithm-based, round robin, or file partitions

Workflow on Grid

• Distributes workload across multiple servers and optimizes resource usage through adaptive load balancing to meet increased project demands
• Allows for unlimited scalability through incremental investments in processing capacity

Team-Based Development

• Fosters collaboration across different IT functions—such as development, quality assurance, and production administration—or across geographically disparate teams, whether onshore or offshore
• Empowers data integration developers with version control and configuration management capabilities

Universal Data Access

• Enables a single approach to accessing data in a wide variety of systems and formats
• Provides access to a wide variety of data systems and formats (when complemented by Informatica PowerExchange), including structured, unstructured, and semistructured data; relational data; mainframe data; file data; standards-based data; and message queue data

Data Integration Services – Map Once. Deploy Anywhere.

• Accesses, transforms, and delivers data across the enterprise – on-premise, in the cloud, or on Hadoop - without generating code or requiring hand-coded data integration procedures
• Scales to support large volumes of data over multiple concurrent sessions

Metadata-Driven Services

• Vibe VDM allows users to define, modify, and reuse data integration procedures across any platform or application by storing and managing data models, transformations, workflows, and other artifacts centrally
• Integrates data by combining metadata-driven data integration logic with a high-performance transformation engine

Integration Workflows

• Manages and tracks the complex flow of data across transactional systems, databases, and other data sources through visual tools
• Provides a built-in, time- or event-based scheduler for automated, "lights-out" operation and for IT teams to schedule and execute data integration that doesn't intrude on business operations

Re-entrant Integration Workflows

• Enables IT teams to run a single instance of a data integration workflow multiple times to maximize limited computing capacity
• Dynamically scales Web services deployments on a single grid node or multiple grid nodes to support thousands of concurrent service requests

Robust Development Tools

• A Web-based, global administration console designed for distributed environments that centralizes all administrative, security, operational, and service-monitoring tasks
• Reusable mapping templates for designing business/transformation logic in a modeling tool, such as Visio, and automatically generating data integration mappings
• A codeless, object-based, visual development environment that supplies built-in parallel processing transformations, a robust expression language, and extensible interfaces
• A comprehensive library of transformation objects for creating and extending context-independent, reusable integration objects that can be deployed on any platform, on-premise or in the cloud
• An extensive expression library for expanding the existing set of predefined expressions and creating user-defined functions
• A robust visual debugger that speeds iterative development and minimizes error recovery logic for design and run-time environments

Reference Table Manager

• Provides an easy-to-use interface for business analysts and other subject matter experts to create, edit, and delete reference tables
• Creates an audit trail documenting the changes to the reference tables

Mapping Architect for Visio

• Automatically generates data integration mappings from best-practice templates and reverse-engineers existing mappings into reusable templates
• Accelerates and automates design using a data-flow design tool based on Microsoft Visio and mapping templates based on Informatica's implementation methodology, Informatica Velocity
  

Mapping Architect for Excel

• Automatically generates data integration mappings from source and target metadata imported directly from the Informatica PowerCenter repository
• Enables business and IT users to build specifications and generate mappings in one easy step using Microsoft Excel and a rich client interface

Support for Mixed Versions of Application Services

• Supports mixed versions of the repository service, integration service, and Web services hub in a single InformaticaPowerCenter domain
• Simplifies upgrade of application services to newer versions incrementally and administration of multiple application services from a single console

LDAP Integration

• Supports secure authentication of users and groups through an enterprise directory system
• Provides a choice between either Informatica PowerCenter or LDAP for authentication

Enterprise-Grade Security

• Provides granular privileges and flexible permissions management to ensure security, particularly across large, globally distributed teams
• Limits user access to only the minimal functionality and data they need, reducing the risk of potential security breaches

Operating System Profiles

• Ensures secure access to file system resources through Informatica PowerCenter workflows executed by different departments and users
• Tracks and monitors usage by specific groups within a shared environment, such as an Integration Competency Center (ICC), to facilitate departmental charge backs

Extended Variables and Parameterization

• Provides flexible access to design and run-time metadata within the data mapping, session, and workflow logic