Skip navigation

Data Archive

15 posts

Data Archive 6.5 HF1 is generally available.


Data Archive 6.5 HF1 builds on Data Archive 6.5 and provides the following features:


  • Re-introduction of support for Power Exchange Sources
    • Customers can now connect and archive from Mainframe sources.
  • Archive from MongoDB
    • Data Archive 6.5 HF1 provides the ability to archive data from MongoDB.
  • Oracle OID Support


Release Notes:


Release Guide:


PAM for Data Archive 6.5 HotFix 1


You can download the Hotfixes from here.

Data Archive 6.5 is generally available. The major enhancements in DA 6.5 are as follows:


Security Enhancements

  1. Secure Connection between Source and Data Archive
    1. Data Archive can now extract data from a Oracle or SQL Server Source through a TLS enabled connection. Data is transmitted through a Secure connection.
  2. Support for ASO Enabled Oracle database as source and repository
  3. Support for Always Encrypted SQL Server as source and repository


Storage Enhancements

  1. Data Archive can connect to Azure Blob storage for storing archived data.
  2. Data Archive Users can now connect to AWS S3 Storage through a keyless connection using S3 SDK.


PAM Updates

  1. Windows Server 2016
  2. Oracle 12cR2
  3. SQL Server 2017


Supportability Updates

  1. Azul JDK 1.8 bundled with Data Archive and installed along with the product.
  2. EDM.bat needs to be used for accessing EDM.


Release Notes:-


Release Guide:-


PAM for Informatica Data Archive 6.5

Data Archive 6.4.4 is now Generally Available. The new features in this release are:



Customer Requested Enhancements


1. Integrated Validation for Live Archive


Oracle source customers can now use the Integrated Validation capability for Live Archive projects on an Oracle source. With this capability, customers can reduce the time to validate archived data to Data Vault by more than 50%, and achieve compliance to their internal auditing & regulatory requirements with Integrated Validation report results.


2. Encryption Enhancements


a. With Data Archive 6.4.4, customers can now encrypt data in Data Vault after retirement/archive of source applications.


i. Encryption can be run as a different job after the retirement/archive job, controlled by a new system defined role.

ii. Data not encrypted during earlier archival/retirement runs, using older versions of Data Archive, can now be encrypted.

iii. Reports show the encryption status of each Data Vault folder.


b. Encryption keys used for encrypting data in Data Vault can now be rotated to adhere to an organization’s internal IT/Security policies.


3. Enhanced Import Export Enhancements


a. With the new enhancements, customers now have granular control over import/export of metadata in Enterprise Data manager (EDM).

b. With a new system-defined role, customers can now control which users perform the import of metadata & the environments in which metadata import is allowed.


4. Password Policies in Informatica Data Vault


a. Security in Informatica Data Vault has been enhanced such that password policies can be configured & enforced on Data Vault users.

b. The various policies that are supported are:


i. Password complexity

ii. Password length

iii. Password duration

iv. Blacklisted passwords


Supportability Enhancements


1. Keyword search reindex enhancements:  Selective search reindex on a specific archive folder is now supported, so that customers can quickly drop & recreate search indexes only for the specific folder that needs an update.

2. A new File Archive Transaction Restore has been introduced to restore flat files from the Archive to the source system from an external application.

3. Informix Enhancements: Introduced delete commit intervals to support archive/ retirement of very large volumes of data.

4. Customers can now increase the number of legal holds per table up to 16384, from the default of 256 in previous versions.


PAM updates


1. Microsoft SQL Server 2016 support for the ILM repository

2. Microsoft Edge browser support


Informatica Data Archive 6.4.4 Release Notes


Informatica Data Archive 6.4.4 Release Guide


PAM for Informatica Data Archive 6.4.4

New Capabilities in Data Archive 6.4.3 HotFix 1


Salesforce Archive

Salesforce charges Customers by the amount of data stored in Salesforce. The amount of historical data stored within Salesforce increases year over year thereby increasing the cost of Salesforce subscription.

With Data Archive 6.4.3 HF1, historical data in Salesforce can be archived to Data archive. Users will still have access to the archived data in multiple ways:

    • Browse data option in Data Archive
    • Data Visualization within Data Archive
    • Google-like keyword search within Data Archive
    • Use any reporting tool of choice by connecting to archived data using ODBC/JDBC Connection
  • Business users can access archived data within Salesforce UI by enabling seamless access through Informatica Cloud Real Time
  • Apply retention policies & legal hold on Salesforce data archived to Data Archive
  • Encrypt Salesforce data stored in Data Archive


Reduces Salesforce subscription cost.

Data stored in Data archive is secure, compressed & legally compliant


Bulk Data loader

Some Customers have a need to migrate large volumes of data from their Source systems to Data Archive. The Bulk data loader provides a mechanism for moving large amounts of data from flat files to Data vault with high throughput. With this feature, about 160GB of data can be archived in one hour.


Customer Requested Enhancements

Saved Criteria:

While browsing for archived/retired data, Data Archive provides a capability wherein users can create a complex Query by selecting different criteria from the UI. These criteria must be created whenever a user wants to browse data and this is time consuming. With DA 643 HF1, user can save their criteria and run them later. They can also share the criteria with other users so that they do not have to recreate the same criteria again.


Pre-Production to Production Migration:

Customers do the actual retirement of data in a pre-production environment, do the verification of data and the move the same to their production environment. The movement of metadata & the retired from one environment to another is manual, cumbersome and error prone. DA 643 HF1 provides an automated process for doing this activity saving a lot of time & effort thereby reducing the Go Live time.



Support for 1 way SSL authentication in Data Vault

Added support for TLS 1.2



70% of issues reported by Customers in 2017 have been fixed in the release. Some of the key ones are:

  1. Ability to provide a sort order as part of the search criteria so that search results in Search within entity are fetched in the specific defined sort order.
  2. Support for displaying data which is stored in Extended ASCII format from ODBC/JDBC driver (eg. Korean language)
  3. Ability to export CLOB data in pdf format in Healthcare portal
  4. Support for downloading external attachments from a remote machine that is accessible from the Server only
  5. Dynamic host/port support for downloading attachments when the attachment server is hosted in a Proxy Environment


PAM updates

Support for Windows 10 client


Healthcare Metadata Viewer

New Graphical Interface for viewing reports & their dependent views of healthcare portal

Ability to create & modify views from this new GUI


Informatica Data Archive 6.4.3 HotFix 1 Release Notes


Informatica Data Archive 6.4.3 HotFix 1 Release Guide


PAM for Informatica Data Archive 6.4.3 HotFix 1

This release contains customer requested enhancements and bug fixes. Following are the highlights of the release:


Customer Requested Enhancements:

  • Display Financial Document
  • New General Ledger (G/L) Account Balance
  • Vendor Line Item List


Internal Improvements:

  • Fixing open issues

For more information, please refer to the following:

PAM for Informatica Data Archive 6.4.3

Informatica Data Archive 6.4.3 Release Guide

This release contains new capabilities, enhancements and bug fixes. Following are the highlights of the release:


Customer requested  Enhancements

  • Single Sign On using SAML 2.0

Data Archive can now integrate with any SAML 2.0 compliant Identity providers like OKTA to provide single sign on within our Customers Intranet. Customers can now be compliant with their IT Policies and also provide easy access to Data Archive.

  • Keyword Search for unstructured data

Business users can now do a google like search for keywords within unstructured data i.e. unstructured data associated with structured data in the form of attachments, Blobs, Clobs, XML etc. Access to retired data is now seamless and easy to access.


Customer Feedback and Usability

  • Added a new validation row count report in loader job
  • Fixed Integration validation related issues
  • Ssadbcopy fixes
  • Fixed EDM as well Jinfonet where the database name started with a number
  • Additional check for 4093 columns
  • Compress segment job fixes for smart partitioning
  • Improved error handling in different IDV layers (query processing and data load)
  • Fixed customer reported problems in  query optimization
  • Fixed sort issue for Date fields in Search Results page


Secure Archive

  • Encryption enhancements

Crypto keys can now be assigned for a specific project or Application. This provides flexibility to our Customers to enable encryption for a specific application and also provide different keys for different application data. Data Archive can also consume crypto keys from external key generation software’s/hardware’s

  • Changed IDV communication layer, related to SSL socket.
  • Fixed many vulnerabilities related issues found internally as well reported by customers


Data Vault

  • Migration utility

The new migration utility provides the ability to move data from one external storage to other. Customers have a need to move data from one store to another store e.g., NFS to EMC Elastic Cloud or Amazon S3.

  • Added Support for new AWS S4 protocol
  • Metadata engine Firebird is updated to new version which helps overall IDV stability by using independent database process per connection.

It resolved issues with TCP/IP connections on big endian platforms. It also fixed issues related to story metadata database on NFS storages, on big endian platforms.

  • Support of new data encryption mechanism in all IDV layers as well as added encryption support for IDV audit files


Performance Improvements

  • Significant performance (>50%) improvement with less memory consumption has been made in export to csv process from browse data.
  • Improved the performance issue for loading of entities on Manage retention page
  • Loader performance is improved for larger input file size.
  • Removed Menu Icon table to improve the performance of health care.


Engineering Initiatives

  • Data Archive Profiling  tool

Previously called as “MIS Installer” this utility is  used to profile data in Customers Source application using  PowerCenter. With DA 6.4.3, “MIS installer” has been decoupled from the Data Archive installer and is provided as a separate install. With this change, Customer get the advantage of using any of the supported versions of PowerCenter that they are using within their environment.

  • To help field on healthcare implementation, sample reports/instructions are added in optional folder.
    1. To demonstrate XML transformation using XSLT
    2. To demonstrate how to download BLOB data from report using AM_ATTACHEMENTS table


Supportability Enhancements

  • Teradata Updates

Data Archive expands support for newer versions of Teradata – 14.x & 15.x. Teradata support has now been enhanced to provide support for various data types including JSON,XML & TPT for Archive and retirement use cases.


  • PAM updates

OS Updates

  • SUSE Linux 12
  • AIX 6.1 TL8
  • Red Hat RHEL 7.x Support

Database Updates

  • DB2 10.5 support
  • Teradata 14 & 15

Cloud Deployments

  • Azure certification

Java Update

  • Java 1.8

Tomcat Update

  • 7.0.70


Healthcare Accelerators:

Based on the feedback coming from field for Healthcare accelerator at various customers, a new version of healthcare accelerator is being released with the following  enhancements

  • Scrollbar support for large data
  • All the linked reports are opening up within the dialog instead of opening up in new browser window every time
  • Removed table dependency for showing VITAL graph in a report
  • Alignment, Leading and trailing spaces trimming in All reports
  • Patient Name is a text field now in Print Claims page
  • Removed Menu Icon Table dependency



Informatica Data Archive 6.4.3 Release Notes


PAM for Informatica Data Archive 6.4.3

Beginning 24 September 2016, existing users of Informatica Data Archive will not be able to use Enterprise Data Manager (EDM). This issue occurs in all versions of Data Archive up to and including version 6.4 HotFix 2.


Also, any uploaded custom JDBC drivers will be unusable.


Affected software:

  • Informatica Data Archive 6.2 HotFix 2
  • Informatica Data Archive 6.3
  • Informatica Data Archive 6.4
  • Informatica Data Archive 6.4 HotFix 1
  • Informatica Data Archive 6.4 HotFix 2.


To resolve this issue in the listed versions, Emergency Bug Fixes (EBF) are available. EBFs are cumulative and contain all of the previous EBFs released for that ILM version. For custom JDBC drivers, apply the EBF and then upload the drivers again. Optionally, if you do not want to apply a cumulative EBF, manually apply a patch.

For more information on the EBF, uploading the drivers, or the manual patch, see KB 501642.

This release contains major new capabilities, enhancements and bug fixes. Following are the highlights of the release:


Product Enhancements

  1. Update of reporting Engine

Visualization reporting engine has been upgraded to latest version.


  • Enhanced Supportability
  • Support for Modern Browsers


  1. Materialized View Enhancements
    • Ability to create materialized views definition in EDM
    • Added the support to select a specific Materialized View or Entity in create Materialized View job.


Supportability Enhancements

  1. Import/Export Enhancements in EDM
    • EDM export/import process has been enhanced to ensure that Customers can move metadata with Logical keys between different environments
    1. PAM Updates
      • Source & AM Home – MS SQL Server 2014 support
      • Amazon AWS  support
      1. Installer changes
        • Added multiple check points in IDV installer to aid in the upgrade process to make customer upgrades easier.


Customer requested Enhancements

  • Standalone job for creating logical and physical file for AS400
  • Addressed about 15 plus usability enhancements
  • About 40 CRs fixed


Data Vault:

  • Certification of archive bridge for HortonWorks 2.3
  • Certification of Data Vault on private Amazon Cloud & Amazon S3 storage certification


Smart Partitioning:

New Job:  Merge Segments

  • Allows customers to consolidate history segments to simplify data management and improve the performance of access to history data.



  • New OEBS retirement accelerator package for OEBS 12.2
  • SAP retirement accelerator support for BW



Informatica Data Archive 6.4 HotFix 2 Release Notes


PAM for Informatica Data Archive (DA) 6.4 HotFix 2


You can download the Hotfixes from here.

Informatica Data Archive ( DA) version 6.4 HF1 has been released to shipping and is available immediately.

Following are the highlights of the release


Product Enhancements

  1. 1.      Report Permissions
  • Assign permissions to reports such that only users with appropriate permissions can view and perform actions on reports
  1. 2.      Compliance:
  • Legal hold can now be applied on a specific or a set of schemas within a Folder
  • A purge job can be run based on a past date


Customer requested Enhancements


  • Addressed 30+ customer reported issues/enhancements

-Some of the Customer’s, who requests that were addresses:

  • Lloyds TSB Bank PLC
  • Royal Bank of Scotland Group plc
  • T. Rowe Price Group Inc.
  • Brown Brothers Harriman
  • Whirlpool

Supportability Enhancements

  1. 1.      Log Collector
  • Easy Access to consolidated logs from various logs, based on Job Id and time ranges
  1. 2.      PAM Updates
  • Client - Windows 8.1,
  • Browser - IE 11
  • Source - Netezza 7.x

Performance & Scalability Improvements

  1. 1. Data Vault:
  • Self-tuning of Data vault parameters based on available resources (up to 50% query performance improvement)
  • Performance improvement in table joins on compressed data (~5% performance improvement depending on query type)
  • Faster Data Vault startup with catalog query optimizations
  • JDBC type 4 driver now available for Cloud (ICS and Real Time)
  1. 2. Smart Partitioning:
  • Process periodic segment creation one at a time
  • Enforce Job step dependency in Segmentation flows,
  • Display database session performance details


  • A new PeopleSoft retirement accelerator  with prebuilt reports
  • New Version of healthcare accelerator with enhancements & bug fixes
  • A new retirement portal for SAP with direct access to Portal
  • Support for SAP R/3 retirement on SAP versions 4.0B, 4.5B, 4.6C
  • A new SAP Smart Retirement standalone job to retire the data based on different categories like System tables, Log tables, Tables with no data.
  • New SAP FasDataType mappings added
  • New retirement reports for JD Edwards Enterprise One
  • New retirement reports for Oracle eBusiness Suite


PAM : -

Release Notes : -

Data Archive 6.3   includes the following new capabilities :


  • Healthcare Retirement Accelerators and AR Burn down: 30+Prebuild Patient centric and account reports and ability to update account receivable from retired application in IDV.
  • Retirement Accelerators for JDE and OEBS : With Most common, standard prebuild reports for access & audits from retied JDE or OEBS.
  • New modules support  added to PeopleSoft HRMS 9.2 , FSCM 9.2 and FSCM 9.0 for Integrated Archive & Data Vault Archive.
  • Support for materialized view in Data Vault. Materialized view is a new database that contains the results of a query.
  • Purge expiry report based on future/past date enhancement.

Informatica Data Archive 6.3 Release Notes

PAM for ILM Data Archive 6.3

This release has hundreds of  fixes that improve the overall quality of Data Archive, as well as several important Enhancements including:

  • SQL Server multi-schema support
  • Enhanced User Experience for Searching IDV
  • Optimization on indexes and join processes in IDV
  • Generation of an audit log based on result set of query
  • Extension of SQL commands: Data Vault administration and support to DROP and TRUNCATE
  • Extension of SQL commands: Using parameters in LIKE constrain
  • Parameter based UTF-8 enforcement for data stored in data vault; Extended ASCII support
  • Enhanced SSL security with upgrade to 1.0.1h


Informatica Data Archive 6.2 HotFix 2 Release Notes

PAM for ILM Data Archive 6.2 HotFix 2

You  can download the Hotfix from here.

This release has hundreds of fixes on the areas like auto entity creation and data access. Also there is several key performance enhancements on Smart Partitioning and Informatica Data Vault are added in the release.

Informatica Data Archive - 6.2 HotFix 1 - Release Notes - (English)

The new version of Informatica ILM Data Archive 6.2  comes with:-


  • Keyword search against Data Vault
  • Dynamic masking against Data Vault
  • eDiscovery integration with Exterro
  • Data Vault query performance enhancements
    • Table repartitioning
    • Bloom filter index
    • Bitmap index
    • JOIN optimization
  • Data Vault compression improvement from 1:20 to 1:40
  • Expanded Data Vault SQL support
    • Support for UNION
    • Expression based projection
    • Group by clause
    • Parameterized queries
  • Security enhancements for:
    • Data Vault: encryption of temporary files
    • Data archive and Data Visualization option
  • Application retirement accelerator for SAP
  • Pre-built data visualization reports for SAP
  • Smart partitioning performance optimizations
  • Data Visualization enhancements
    • Enforcement of access roles and audit logs
    • Multi-language support for reports
  • Archive Bridge:
    • Support for Cloudera 3.X and 4.X HDFS
  • New supported platforms
    • Microsoft SQL Server 2012 (source, target, repository)
    • IBM DB2 9.8, 10.1 (source, target, repository)
    • Windows 2008 R2, 2012
    • Redhat Linux 6.2
    • Seamless access on DB2
    • Java 7 (1.7x)
    • Google Chrome 30.x
    • Data Vault ODBC/JDBC driver on zLinux
  • New Application Accelerators
    • PeopleSoft 9.2, Siebel 8.2, JD Edwards 9.0.2
    • JD Edwards Enterprise One 8.12 AR, WOM, FA
    • JD Edwards Enterprise One 9.0 SOM, INV, PO, WOM
  • Data Warehouse Advisor Version with the following enhancements:
    • The Date Range reports and Histogram reports have been optimized for improved performance. All Date Range reports now only include queries that are associated with date ranges in the report output.
    • Several bug fixes and additional platform support.


PAM for ILM 6.2

Informatica Data Archive - 6.2. - Release Notes - (English)

Following are the key features and enhancements:




  • Security  vulnerability fixes
  • Live Archiving
  • Integrated smart partitioning


Application Retirement

  • File Archive load & migration performance enhancements
  • Integrated data visualization
  • Search based on reference table attributes and masked fields
  • Utilize application accelerator for application retirement  by copying entities across application versions
  • UI to configure data type mappings for archiving to file
  • View entities associated with access roles


Integrated Archive Application Accelerators


  • OEBS 12.1 CZ, CN, EDR APPLSYS/WorkFlow
  • PeopleSoft  9.1 RO
  • JDE Enterprise One 8.12 (GL, AP, PO, AR, INV, SOM)
  • JDE Enterprise One 9.0 (GL, AP, PO, AR, FA)


Smart Partitioning Application Accelerators (Not New)

  • OEBS 11.5.10 GL, AP, AR, PO, INV, BOM, WIP, WSH ONT, PA, CZ , CN
  • PSFT 9.0 PY (Payroll)



  • IDE 9.5.x for profiling
  • New ArchiveBridge storage platforms
  • EMC Atmos (Centera API)
  • EMC Data Domain
  • SAP Retirement support for ERP 4.6C
  • EV 10 to store SAP ADK files
  • DWA 5.4
  • DB2 10 as a source



Informatica Data Archive 6.1.1 Release Notes

ILM 6.1.1 PAM

Release Highlights:


  • Nearline deletion functionality for SAP BW 7.0
  • Authorization concept for administrative functions
  • License size report
  • Improve query processing of large result sets
  • Support of simultaneous ADK and Nearline archiving
  • Support of SAP BW 7.3 deletion functionality
  • Mandatory system id authentication
  • Simplifying restore process
  • Improved memory and queue management
  • Distributed environment support
  • Specific version functionalities details and bug fixes (See release notes)


Informatica Nearline for SAP BW 3.1 MR2 Release Notes