Data enters your business from many sources and in many formats. Informatica Advanced Data Transformation ensures that all your data is in a common form that supports analysis, decision-making, and operational efficiency across all your systems.

Advanced Data Transformation is a comprehensive, enterprise-class universal transformation solution for any data type, regardless of format, complexity, or size. Its embeddable run-time engine brings high performance advanced data transformation capabilities not only to PowerCenter but to any infrastructure, solving your enterprise-wide data transformation challenges. Through a single, easy to use interface, easily build transformations for complex XML, industry formats (SWIFT, HL7, EDI X12, etc.), unstructured documents, and even legacy data formats like COBOL copybooks.

  • The intuitive codeless development environment drastically cuts development time and costs by eliminating laborious, error-prone hand coding
  • Native support for all XSD schema features dramatically accelerates and simplifies the process of transforming complex hierarchical XML data
  • Automated access to data trapped in legacy data formats or unstructured documents, like Excel spreadsheets, significantly speeds the ability to make use of that data
  • A comprehensive set of pre-built industry libraries facilitates compliance with evolving regulatory requirements

Customer Evidence verified by TechValidate.

Customer Content verified by TechValidate.

Customer Proof verified by TechValidate.

Universal Data Transformation

  • Sophisticated document preprocessors extract data locked in PDF files, Microsoft Word, and Excel documents
  • Native support for any XML-based format and JSON read/write capabilities
  • Supports flat files including positional, non-positional, variant files, and undocumented binaries
  • Easily access data in legacy formats, such as COBOL, for analytics

Robust Set of Industry Libraries

  • One of the most comprehensive sets of prebuilt, prepackaged data transformation libraries supports industry-specific data formats for banking, insurance, healthcare, manufacturing, and telecommunications as well as cross-industry standards
  • Includes on-going support and maintenance for SWIFT, NACHA, HIPAA, HL7, ACORD, EDI X12, EDIFACT, FIX, FpML, SEPA plus 20 more libraries
  • In-line validation of the business and structural rules for industry standards

Codeless Development Environment

Codeless Development Environment

  • Single development environment for any type of data transformation
  • Uses a simple point-and-click, mark-and-map process
  • In-line visual debugging identifies elements being mapped and transformation results for rapid troubleshooting

In-line validation checks and debugging

Deployment Flexibility

  • Executes transformations with an embeddable, high-performance engine that enables maximum throughput and scalability for both real-time and batch applications
  • Provides data transformation capabilities in any middleware: enterprise service bus, enterprise application integration infrastructure; or uses transformations in data integration mappings
  • Can be implemented within the Informatica Platform or externally with other middleware, such as MessageBroker or TIBCO, Cloud infrastructures or Hadoop

Customer Content verified by TechValidate.

Customer Testimonial verified by TechValidate.

Data Format Library Options

Support Industry Formats with Libraries of Prebuilt Data Transformations

The Informatica B2B Data Format Library Options are sets of prebuilt, prepackaged data transformations that support industry-specific data formats. These libraries are available as options with either Informatica B2B Data Exchange or Informatica Data Transformation.

  • Quickly comply with the most current industry, regulatory, and business partner standards
  • Support the business and structural validation rules for industry standards
  • Reduce integration development time and costs while eliminating the errors common in hand-coded transformations

Informatica B2B Data Format Libraries


    • EDIX12 version 3, release 1 to version 5, release 5
    • EDIFACT 90-1 to D.09A
    • EDI-X12 3010 to 6020


    • HIPAA version 4, release 1, addenda 1 (4010A1)
    • HIPAA version 5, release 1, addenda 1 (5010A1)
    • HIPAA crosswalk 4010A1 to 5010A1 (and vice versa)
  • HL7
    • HL7 version 2.1
    • HL7 version 2.2
    • HL7 versions 2.3 and 2.3.1
    • HL7 version 2.4
    • HL7 version 2.5 and 2.5.1
    • HL7 version 2.6
    • HL7 version 3
    • NCPDP version 5.1 (with batch version 1.1)

Financial Services

    • Multiple ACORD transaction standards
    • ACORD AL3
  • BAI
    • BAI Cash Management Balance Reporting Specifications version 2 (BAI2)
    • BAI Lockbox
  • DTCC
    • DTCC updates made annually in March and September
  • FIX
    • FIX versions 4, 4.1, 4.2, 4.3, 4.4
    • FIX versions 5.0, 5.0 SP1, 5.0 SP2
  • FpML
    • FpML 4.8, including FpML confirmation and reporting for financial derivatives instruments
    • NACHA 2010
    • NACHA 2011
  • SEPA
    • SEPA Credit Transfer Scheme version 5.0
    • SEPA Core Direct Debit Scheme version 5.0
    • SEPA Business to Business Direct Debit Scheme version 3.0
    • SWIFT MT 2010 and 2011
    • SWIFT MX
    • SWIFT MT to MX translations
    • SWIFT Messaging Data Services label for 2011


  • ASN.1
    • ASN.1 version XER

Market Data Feeds

  • Bloomberg
    • Bloomberg PerSecurity
    • Bloomberg Back Office
    • Bloomberg Back Office Extended
  • Thomson Reuters
    • Thomson Reuters Datascope Select
  • Telekurs
    • Telekurs Valordata feed (VDF)

Additional Data Format Support

  • UNIFI (ISO 20022)
  • RosettaNet
  • OAGi
  • IFX

Compare these Data Transformation packages to select the one that’s right for you.

Data Transformation Advanced XML Unstructured Data
Unstructured Document Transformation (Office docs, PDF, Binaries, etc).    
High Performance Transformation of Complex Hierarchical XML/XSD    
Industry Libraries (SWIFT, HL7, HIPAA, EDIX12, etc.)        
Embeddable Run-time
Gartner Magic Quadrant for
Data Integration Tools
Find out why we've been
positioned as a leader
Read the full report