Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Install
  4. Data Archive Installation
  5. Data Vault Installation
  6. Application Accelerator Installation
  7. Application Retirement for Healthcare Accelerator Installation
  8. MongoDB Accelerator Installation
  9. Salesforce Accelerator Installation
  10. After You Install
  11. Data Archive Upgrade
  12. Data Vault Upgrade
  13. Upgrading Oracle History Data
  14. Upgrading PeopleSoft History Data
  15. ILM Data Validation Option Setup
  16. Data Archive Source and Target Database Requirements
  17. Data Archive Connectivity
  18. Data Archive Uninstallation
  19. SAP Application Retirement
  20. Database Users and Privileges
  21. Data Visualization Designer Installation
  22. Data Archive Installation Requirements Checklist and Architecture Options

Installation and Upgrade Guide

Installation and Upgrade Guide

Upgrading PeopleSoft History Data Prerequisites

Upgrading PeopleSoft History Data Prerequisites

Before you upgrade PeopleSoft history data, verify the Data archive version, the accelerator version, the source connection, and the history database indexes. To increase performance of the database and the upgrade scripts, gather statistics for the history database.
Complete the following tasks:
  1. Verify that you have Data Archive version 5.3 or later. You cannot use these instructions to upgrade the history data if you have an older version of Data Archive.
  2. Verify that you have the most recent version of the accelerator. If you do not have the most recent version of the accelerator, contact Informatica Global Customer Support.
  3. Verify that the PSAESTEPDEFN, PSAESTMTDEFN, and PS_UPG_DATACONV tables in the upgraded environment have records. You can use these tables for troubleshooting if you encounter problems during the PeopleSoft upgrade.
  4. Verify the source connection. Do not change the source connection to reflect the updated version of the application. For example, if you upgrade from PeopleSoft 8.9 to 9.1, the application version for the source connection is PeopleSoft Applications 8.9.
  5. Verify that all indexes exist in the history database and that the indexes are valid. If indexes do not exist or are not valid, run the Create Indexes job.
  6. Gather database statistics for the history database. Gathering database statistics optimizes the database and increases performance of the upgrade scripts.

0 COMMENTS

We’d like to hear from you!