Mapping Analyst for Excel
During data integration, a lot of valuable development time is spent gathering business requirements, translating them into technical specifications, and then manually converting these technical specifications to PowerCenter data integration mappings.
Mapping Analyst for Excel simplifies this process and the entire data integration life cycle.
A key feature of PowerCenter Standard Edition, Mapping Analyst for Excel unlocks the logic captured in Excel spreadsheets, regardless of format, and enables this logic to be used in PowerCenter.
Analysts use a set of standard Excel templates to define their source-to-target mapping specifications for IT developers. Developers can then jumpstart their development by automatically generating PowerCenter mappings from the specifications.
With Mapping Analyst for Excel, business analysts, data analysts, and PowerCenter developers work better together to reduce project delivery times.
Features
Customizable Excel-Based Interface
- Use Microsoft Excel to build mapping specifications and automate their generation
- Easily define a standard format for specifying source-to-target mappings
- Leverage metadata from the PowerCenter repository to build source and target specifications in your Excel mapping specification
Automated Mapping and Specification Generation
- Jumpstart mapping development with support for the translation of all major transformation logic captured in specifications: joins, filters, expressions, lookups, and aggregations
- Automatically carry over business logic and comments captured in specifications to PowerCenter mappings, streamlining communications and reducing errors
- Keep mapping specifications up to date by automatically synchronizing modifications made in PowerCenter with mapping specifications in Excel
Benefits
- Accelerate development by automatically generating mappings from technical specifications
- Reduce the risk of misinterpretation associated with manually-generated mappings
- Leverage existing assets by reusing existing specifications captured in spreadsheets
- Decrease time to value by not having to convert specifications into a new format—no retraining or specification rewrites required
- Avoid project delays and costly budget overruns with enhanced business and IT alignment and collaboration—each stakeholder’s knowledge is leveraged to develop clearly defined business requirements and technical specifications that are incorporated into a standardized document