Remediation Data Migration

Note: If you are migrating from SAS MDM 4.2, it is not necessary to complete the following steps.
The mechanism for maintaining records for remediation has changed from a filebased method to a database method. If you want to maintain your existing remediation items after SAS MDM installation, any existing remediation data must be migrated into the database. SAS MDM provides a Java program to perform this migration. To use it, your classpath environment variable must include all of the JAR files in the directory identified by the MDM_REMEDIATION_LIBS macro.
The program uses a configuration file to connect to the SAS Data Remediation database. The file, sas.dm.mdm.migrateremediation.xml, appears in the same directory as the required JAR files.
java -Dmigrateremediation.config=your_path\sas.dm.mdm.migrateremediation.xml
 com.sas.dm.mdm.dataremediation.MigrateRemediationFiles
You see the following changes after the program completes successfully:
  • Sas_rem_items for file-based remediation tasks contain an app_key if the record had values for both the source system ID and the source system record ID.
  • Sas_rem_items contain updated keys for file-based remediation tasks. These appear as record:///id from mdm_remediation_data.
  • Mdm_remediation_data contains an entry for each of the records that has been migrated.
After verifying that the content has migrated successfully, you can remove the files for the remediation records.
Last updated: April 19, 2017