APPX Software Library

Chapter 5: Encrypt the DMO database

Inventory and export the eligible files

Start with the eligible DMO files unencrypted. Complete the PROSPECT decryption exercise first if following this manual in sequence.

  1. Inventory every application related to database DMO. Include each application's eligible permanent APPXIO files in the conversion plan.
  2. Back up the database, matching structures, and System Administration. Record current FMS settings and any individual encryption keys.
  3. In DMO Data File Management, open File Selection and choose Select All.
  4. Use SELECT to exclude PARAM and STREAM. Check the organization and file type shown on each row before excluding it.
  5. Return to Data File Management. The standard DMO application should have 9 of 11 files selected.
  6. Choose Export Files (CSV), leave Include Headings unchecked, and click Proceed.
  7. Check every result row. Preserve all nine CSVs and their counts before assigning encryption settings.
The nine eligible DMO files in File Specifications.  PARAM and STREAM are outside this selection.
Figure 8. The nine eligible DMO files in File Specifications. PARAM and STREAM are outside this selection.

The sample counts are shown below for comparison with the screenshots. Use your own before and after counts if the sample has been changed.

FileRecords in this test
ACTIVITY33
ACTTYPE13
CONTACT16
COUNTRY7
INDUSTRY28
OPPORTUN7
PROSPECT7
SALESREP10
STAGE4
Total125

Repeat the export for additional applications in DMO before changing any setting that will affect them. Do not infer database-wide coverage from a screen whose Application field still names only DMO.