PowerCenter Real Time Edition

Increase Agility and Reduce Risk with
High-Performance, Real-Time Data Integration

Informatica PowerCenter Real Time Edition is highly scalable, high-performance enterprise data integration software. It accesses and integrates data from virtually any system, in any format, and delivers that data throughout the enterprise, at any speed. Informatica PowerCenter Real Time Edition provides all the capabilities of Informatica PowerCenter Standard Edition and includes additional capabilities for integrating and provisioning operational data in real time. Packaged for simplicity and flexibility, this edition supports operational data integration projects that require the exchange of data among operational applications. It enables the development and delivery of sophisticated data services via a service-oriented architecture (SOA).

• Cost-effectively scale IT operations with a real-time data integration environment
• Reduce risk by ensuring the reliability of real-time data even in failure conditions
• Increase business agility and performance with right-time data integration, reuse, and continuous capture of data changes

• Gartner Magic Quadrant for Data Integration Tools

PowerCenter Real Time Edition Key Features

Change Data Capture for Relational Data Sources

• Captures changes in data sources as they happen for processing and routing to multiple target applications
• Ensures referential data integrity of real-time change data streams

Zero-Latency Processing

• Enables continuous data processing with a zero-latency engine
• Supports batch, trickle-feed, and real-time data integration latencies in a single optimized environment

Reliable, Scalable Data Processing and Delivery

• Horizontally scales message processing and delivery to handle massive real-time data volumes
• Prevents data loss and data duplication even in system failure scenarios, and ensures referential data integrity for real-time change data streams

Dynamic Partitioning

• Divides data processing into subsets, which run in parallel and are spread among available CPUs in a multiprocessor system
• Provides visual controls for a wide range of partition schemes

Built-In Web Services Support

• Leverages Web services protocols, including XML, WSDL, and SOAP, to access data, metadata, and data integration workflows within an SOA
• Provides a Web services hub for centralized monitoring and reporting along-with built-in support for WS-Security, a built-in WSDL editor, and a Web services testing tool

Dynamically Scalable Data Services

• Enables existing batch and real-time data transformation logic to be exposed and reused as data services
• Automatically scales Web services to support a large number of concurrent workloads, typical of a shared services Integration Competency Center (ICC) environment

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

• 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

Global Metadata 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

Integration with Messaging Systems

• Supports reading from and writing to such messaging systems as JMS (i.e., Informatica, Oracle, Sun, TIBCO, IBM, JBoss), webMethods X-Broker, IBM WebSphere MQ, and Microsoft MQ.

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 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 hubs in a single Informatica PowerCenter 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