PowerCenter Standard Edition

Deliver Timely, Relevant, Trustworthy Data with
High-Performance Data Integration

Informatica PowerCenter Standard Edition is highly scalable, high-performance enterprise data integration software. It accesses and integrates data from virtually any business system, in any format, and delivers that data throughout the enterprise. With Informatica PowerCenter Standard Edition, your IT organization can implement a single approach to accessing, transforming, and delivering data without hand coding. Informatica PowerCenter Standard Edition scales to support large volumes of data over multiple concurrent sessions. Meeting demands for security and performance, this edition is used across a wide spectrum of data integration initiatives, including data warehousing and data migration.

• Meet analytical and operational needs of the business for timely, relevant, and trustworthy data
• Cost-effectively scale data integration initiatives to meet increased data demands
• Accelerate time to delivery and reduce costs by improving global, cross-team productivity and cross-functional collaboration

• Gartner Magic Quadrant for Data Integration Tools

Informatica PowerCenter Standard Edition Key Features

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; data in packaged applications; NoSQL big data stores such as Hadoop HDFS; social data such as Facebook, LinkedIn, and Twitter; and message queue data

Data Integration Services

• Accesses, transforms, and delivers data across the enterprise without generating code or having to hand-code data integration procedures
• Scales to support large volumes of data over multiple concurrent sessions

Metadata-Driven Services

• Defines, modifies, and enables reuse of data integration procedures by storing and managing data models, transformations, workflows, and other artifacts
• 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

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
• 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 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 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

LDAP Integration

• Supports secure authentication of users and groups through an enterprise directory system
• Provides a choice between either 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 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