Authors: RashmiRekha00u176ruk... Skip navigation

Data Archive

7 Posts authored by: Rashmi Rekha Gogoi

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

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.