It used to be that only the largest enterprises and projects could access high-quality data integration and profiling tools. PowerCenter Express changes that. It democratizes data integration with instant access, ease-of-use, and functionality geared for smaller, departmental projects that can easily fold into larger, more sophisticated enterprise architectures.
Comprehensive ETL Functionality
PowerCenter Express provides all the extract, transform, and load (ETL) functionality you need to bring in data sources, create mappings and test them mid-stream, and execute complex, multi-step transformations (including aggregations, string manipulations, ranking, and more). And you can do it all easily.
Fast, Easy Installation
With PowerCenter Express, you'll be up and running in less than 10 minutes, thanks to its simple click-through installation and configuration. The software has a small memory footprint, comes with an embedded database for domain and repository, and can be installed even on low-configuration laptops.
In-Line Data Profiling
With PowerCenter Express, you can perform unlimited column and rule-based data profiling, all in-line. That means you can assess your data's quality as you design, without leaving the interface. Data profiling auto-identifies your column format and quantity, tells you the percentage of each format represented (including "null" values), and lets you drill in to better understand the context.
Embedded Cheat Sheets
Contextual "cheat sheets" accessible directly through the PowerCenter Express interface provide step-by-step guidance on performing common and less common data integration tasks. In addition to those currently available, you'll find new cheat sheets regularly posted to My Support.
An Integration Ecosystem to Explore and Exploit
PowerCenter Express is fully integrated with Informatica Marketplace, giving you instant access to hundreds of applications that extend the power of PowerCenter Express—at little or no cost. Think of it as iTunes for integration—just as easy, but even more powerful.
The Connectivity You Need
PowerCenter Express provides connectivity to relational databases, flat files, ODBC, JDBC, XML, social media sources, Web services—even unstructured data like Word and PDF files.
Metadata-Driven
PowerCenter Express includes metadata for transformations, mappings, and workflows, and lets you re-use components from one data integration job in another.
High-Performance Integration Engine
Even when executing the most complex, multi-step transformations, PowerCenter Express is up to 10 times faster than other free data integration tools.