Informatica PowerCenter

Cost-Effective Integration

Informatica PowerCenter is market-leading software that provides highly scalable, highly available and high-performance data integration, thereby maximising business benefits from enterprise data assets. Informatica PowerCenter serves as the foundation for all data integration projects and enterprise integration initiatives, including:

• Data Migration
• Data Governance
• Data Warehousing
• Data Synchronisation & Replication
• Master Data Management (MDM)
• Service-oriented Architecture (SOA)
• B2B Data Exchange

PowerCenter is available in various editions to suit the particular infrastructure, data volume & latency needs of your integration project.

Agile Solutions can help you with everything you need to build and optimise your own Informatica PowerCenter platform, from designing a complete solution through to installation, deployment, upgrades, health checks and performance tuning.

Product features

 
Universal Data Access

Informatica PowerCenter, complemented by Informatica PowerExchange, provides access to virtually all enterprise datatypes, including:

• Structured, unstructured, and semi-structured data
• Relational, mainframe, file, and standards-based data
• Message queue data

PowerCenter accesses and delivers data as and when the business requires, offering a choice of real-time, batch or change data capture (CDC).

Integration Tools & Services

• Object based visual development tools – intuitive, easy-to-use tools facilitating rapid development cycles without need for hand-coding
• Pre-built library containing a wide range of transformation objects & expressions
• Visual Debugger
• Workflow Management
• High performance data integration server

Administration & Security

• Single web-based administration interface
• Role based security
• Granular object level privilege administration
• SSL LDAP authentication
• Audit trail logs
• Operational metadata reporting

Collaboration & Productivity

Enhance business-IT collaboration and productivity across global IT teams:

• Re-usable objects across projects and platforms – remove the need for recoding
• Pre-defined wizards & templates e.g. Type 2 dimension loads
• Team-based development – repository based, object level versioning; rapid deployment of development assets
• Microsoft Visio based data flow design tool
• Metadata Management

Compliance

Protect sensitive, private data in Production Environments:

• Data Masking – in-flight masking to produce realistic, fully functional data for test environments or 3^rd Parties

Scalability & Performance

Provide a fully scalable, high performance solution by utilising such functionality as:

• Enterprise Grid – optimise performance by exploiting grid computing
• High Availability - minimize service interruption in the event of a hardware and software outage
• Partitioning – take advantage of parallel processing in multi-processor or grid-based environments
• Push-down optimisation – utilise existing database assets by “pushing down” transformation processing