Preface
Installation Overview
- Introduction
- Data Archive Installation
- Data Vault Installation
- Component Selection
- Application Accelerator Installation
- Dynamic Data Masking Installation
  - Enabling Dynamic Data Masking
Before You Install
- License Key
- X Window Server
- Data Archive Requirements for the ILM Repository
  - ILM Repository User
- Data Archive Requirements for the ILM Engine
- Data Vault Requirements
Data Archive Installation
- Data Archive Installation Overview
  - Installation Package
- Installing Data Archive Components
- Graphical Mode Installation
- Console Mode Installation
- Silent Mode Installation
  - Silent Mode Installation Properties
  - Installing in Silent Mode
- Informatica Data Archive Profiling Installation
Data Vault Installation
- Data Vault Installation Overview
- Graphical Mode Installation
- Console Mode Installation
- Silent Mode Installation
  - Step 1. Create the Properties File
  - Step 2. Run the Silent Installer
Application Accelerator Installation
- Application Accelerator Installation Overview
- Installing the Application Accelerators in Graphical Mode
- Installing the Application Accelerators in Console Mode
Application Retirement for Healthcare Accelerator Installation
- Application Retirement for Healthcare Accelerator Installation Overview
- Prerequisites
- Installing the Accelerator in Graphical Mode
- Installing the Accelerator in Console Mode
- After You Install
MongoDB Accelerator Installation
- MongoDB Accelerator Installation Overview
- Installing the MongoDB Accelerator in Graphical Mode
- Installing the MongoDB Accelerator in Console Mode
- After You Install
Salesforce Accelerator Installation
- Salesforce Accelerator Installation Overview
- Installing the Accelerator in Graphical Mode
- Installing the Accelerator in Console Mode
- After You Install
After You Install
- Client Machine Requirements
- Starting the ILM Application Server
  - Logging In to Data Archive
- Starting the Data Vault Components
- Configuring Memory Settings on a 64-bit Computer
- Configuring Embedded Tomcat for HTTPS
- Registering Services as Windows Services
  - Registering the Archive Service
  - Registering the Data Vault Service for External Attachments
- Configuring Data Archive
- Setting up SAP Retirement
Data Archive Upgrade
- Data Archive Upgrade Overview
- Before You Upgrade
- Upgrading Data Archive in Graphical Mode
- Upgrading Data Archive in Console Mode
- Upgrading Data Archive in Silent Mode
- After You Upgrade Data Archive
- Reverting to a Previous Version
Data Vault Upgrade
- Data Vault Upgrade Overview
- Before You Upgrade a Data Vault Component
- Upgrading in Graphical Mode
- Upgrading in Console Mode
- Upgrading in Silent Mode
  - Step 1. Create the Properties File
  - Step 2. Run the Silent Installer
- Troubleshooting Data Vault Upgrade
- After You Upgrade
- Reverting an Upgrade
Upgrading Oracle History Data
- Upgrading Oracle History Data Overview
- Upgrading Oracle History Data Prerequisites
- Steps to Upgrade the History Data
- Step 1. Run the History Upgrade Scripts
  - History Upgrade Scripts Parameters
  - Running the History Upgrade Scripts
- Step 2. Run the Create History Table Job with the Original Source
  - Running the Create History Table Job
- Step 3. Update the Application Version for Source and Target Connections
  - Updating the Application Version for Source and Target Connections
- Step 4. Run the Create History Table Job with the Updated Source
  - Running the Create History Table Job
- Step 5. Run the Seamless Data Access Job for the Updated Source
  - Running the Seamless Data Access Job
- Step 6. Run the Create Indexes Job
  - Running the Create Indexes Job
- Step 7. Gather Database Statistics
Upgrading PeopleSoft History Data
- Upgrading PeopleSoft History Data Overview
- Upgrading PeopleSoft History Data Prerequisites
- Steps to Upgrade the History Data
- Step 1. Run the History Upgrade Scripts
  - Running the History Upgrade Scripts
    - Original Application Changes Script Example
    - Updated Application Changes Script Example
- Step 2. Run the Create History Table Job with the Original Source
  - Running the Create History Table Job
- Step 3. Update the Application Version for Source and Target Connections
  - Updating the Application Version for Source and Target Connections
- Step 4. Run the Create History Table Job with the Updated Source
  - Running the Create History Table Job
- Step 5. Run the Seamless Data Access Job for the Updated Source
  - Running the Seamless Data Access Job
- Step 6. Run the Create Indexes Job
  - Running the Create Indexes Job
- Step 7. Gather Database Statistics
ILM Data Validation Option Setup
- ILM Data Validation Option Setup Overview
- Before You Set Up the ILM Data Validation Option
- Install the Data Vault Service ODBC Driver
  - Installing the Data Vault ODBC Driver in Graphical Mode
  - Installing the Data Vault ODBC Driver in Console Mode
- Create a Data Vault Service ODBC Data Source
  - Creating an ODBC Data Source on Windows
    - Using the Windows ODBC Data Source Administrator to Create a Data Source
    - Data Vault ODBC Data Source Parameters
  - Creating an ODBC Data Source on UNIX
- Create a PowerCenter Connection Object
- After You Set Up the ILM Data Validation Option
Data Archive Source and Target Database Requirements
- Source Database Requirements
- Target Database Requirements
Data Archive Connectivity
- Data Archive Connectivity Overview
- Native Connectivity
- DataDirect Connect JDBC Connectivity
- PowerExchange Connectivity
- Third-Party JDBC Connectivity
Data Archive Uninstallation
- Data Archive Uninstallation Overview
- Restore Archived Data
- Dropping Database Users and Links
- Dropping the ILM Repository
- Deleting the ILM Application Server Directory
- Uninstalling the Data Vault
- Uninstalling Source Adapters
- Deleting Remaining ILM Files
SAP Application Retirement
- SAP Application Retirement Overview
- SAP Application Retirement Architecture Options
- Setting Up SAP Application Retirement
- Step 1. Install the SAP Java Connector
- Step 2. Apply the SAP Transports
- Step 3. Assign Roles
- Step 4. Configure Conf.Properties
- Step 5: Set up the FTP or NFS Connection
  - Creating the FTP Connection
  - Creating the NFS Mount
Database Users and Privileges
- Database Users and Privileges Overview
- Administration User
- Production Application User
- Staging User
- History Read-Only User
- History Application User
- Combined User and Archive User for Seamless Access
- System User (Smart Partitioning)
- IBM DB2 Privileges
  - Bind Packages Privileges
  - Login User Privileges
- SAP Application Retirement Privileges
  - ZINFA_RETIREMENT_PREPARATION Role
Data Visualization Designer Installation
- Data Visualization Designer System Requirements
- Installing Data Visualization Designer
Data Archive Installation Requirements Checklist and Architecture Options
- Pre-Installation Requirements Overview
- Archive to a Database Checklists
- Archive or Retire to Data Vault Checklists
- Smart Partitioning Source Data Checklists
- Data Archive Options Installation Checklist
  - SAP Retirement Installation Checklist
- Data Archive Architecture Recommendations

Installation and Upgrade Guide

6.5 HotFix 1
- 6.5.1
- 6.5

Back Next

Data Vault Requirements

When you install Data Vault, you install the following components:

Data Vault Service: Includes the Data Vault Agent and the Data Vault ODBC driver. You can install the Data Vault Service on the same machine as the ILM Engine.
Data Vault Data Archive Plug-in: You must install the Data Vault Data Archive plug-in on the same machine as the ILM Engine.
Data Vault Administration Tool and SQL Tool: You must install the Data Vault Administration Tool and SQL Tool on a machine with a Windows operating system.

Verify that the machine allocated to host the Data Vault Service meets the system and software requirements.

Server configuration: Verify that the machine has the following configuration:
A 64-bit server.
At minimum, four core processors.
A minimum of 8 GB of RAM.
If you install Data Vault Service on the same machine that hosts the ILM Engine, then the machine must have a minimum of 12 GB of RAM.
A minimum of 20 GB of local storage.
A shared folder, visible to all servers running Data Vault agents, with a size that is equal to 50% of the size of the data that you plan to archive to Data Vault (up to a maximum shared folder size of 500 GB).
The final storage space is equal to 10%-15% of the table data that you plan to archive.
Final storage space can be local or external. External storage options include Hadoop HDFS, NetApp, EMC Centera, EMC Atmos, EMC Data Domain, Hitachi HCP, Storage Area Network (SAN), Network Attached Storage (NAS), Content Addressed Storage (CAS), and DAS.
For guidelines about server sizes for live archive, see Server Guidelines for Archive to Data Vault.
For guidelines about server sizes for application retirement, see Server Guidelines for Retire to Data Vault
Operating system: If you plan to archive or retire data to NAS, use one of the following operating systems:
64-bit AIX 7.1
64-bit AIX 6.1 TL3
64-bit HP-UX 11.31 (11i v3) with a Itanium chip set
64-bit Red Hat Linux 5, 6.1, 6.2 and later with a x64 chip set
64-bit SUSE Linux ES10 or ES11 with a x64 chip set
64-bit Solaris 10 with SPARC chip set
64-bit Windows 2008, 2008 R2, or 2012 with a x64 chip set
If you plan to archive or retire data to a target other than NAS, see the product matrix availability for the supported operating systems at https://kb.informatica.com.
System-specific notes: The following limitations and recommendations apply to the Solaris 10 Update 6 with the SPARC chip set system:
Data Vault does not support multiple service-manager environments.
Because the Data Vault import and query architecture is CPU-intensive, do not run the system on architectures with Chip Multi-Threaded (CMT) processors such as the UltraSPARC T1 and T2.; The following limitations apply to the AIX 7.1 system:
Informatica supports the IBM JFS and JFS2 file systems.
Informatica supports the Big-Endian mode of the processor.; The following limitations apply to the Windows 2008 or 2012 with the AMD Opteron chip set system:
Informatica supports the NTFS file system.
Data Vault does not support multiple service-manager environments on Windows 2008 Server.
If you install Data Vault on Windows, you must install Microsoft Visual C++ Redistributable Package (x64) Service Pack 1.
To download Microsoft Visual C++ Redistributable Package (x64) Service Pack 1, go to http://www.microsoft.com/downloads/en/details.aspx?familyid=ba9257ca-337f-4b40-8c14-157cfdffee4e&displaylang=en
Java: Install the 64-bit version of Java Development Kit (JDK) SE 8.
To download JDK, go to http://www.oracle.com/technetwork/java/javase/downloads/index.html.