Migrating from 7.1x and 7.6.x to 7.7

After installing the 7.7 server, follow these steps for migrating the PeopleSoft Adapter environment from 7.1.x or 7.6.x releases.

  1. Create the following three directories under the 7.7 server's approot directory.
    • snapcat
    • snapcat/bak
    • snapinst
  2. Copy the contents of the old snapinst and snapcat folders to the new directories.
  3. Update the Application Path to include snapcat.
  4. Configure the relevant SQL Database Adapter.
  5. Configure the PeopleSoft Adapter.
  6. Proceed to Adding the First Connection to PeopleSoft on the DBA screen, and enter the DBA password that you used in the earlier release.

The PeopleSoft adapter is now ready for use.

Note: If you are migrating from a server release earlier than 7.7.04 to release 7.7.04 (or later), the PSLOGIN procedure will be added to each synonym, as an MFD_PROFILE entry that is registered to the PeopleSoft adapter. This process will take place every time the adapter is used using the WebFOCUS Reporting Server browser interface. Existing synonyms will be backed up in the SNAPBAK application directory, and a log file will be created in the same directory that contains migration statistics. The log file name takes the format psmiglog_hh.mm.ss and will be created every time that the adapter is used. It is recommended that older log files are deleted periodically.

In WebFOCUS Release 82 (WebFOCUS Reporting Server Release 7.7.07) and higher, the automatic migration also adds a global variable to each PeopleSoft synonym. This variable is coded on the CONNECTION= parameter in the ACCESS (synonymname.acx) file. This is used to facilitate the moving of the PeopleSoft adapter files from one server to another, for example, Test to Production, where the connections (instances of the PeopleSoft environment) may have different names. For more information, see Moving the PeopleSoft Adapter From One ibi WebFOCUS Reporting Server to Another.