Generating Metadata for Legacy Reports

If you are upgrading Oracle MICROS Enterprise Back Office from 8.5.1.5 to 9.0 or later and you want to generate the subject area mapping report for Interactive Reports and Ad Hoc reports, you must use the Interactive and Ad Hoc Reports metadata extraction tool before uninstalling Reporting and Analytics. If you are using an early Enterprise Back Office version, you must upgrade to 8.5.1 and apply patch 5 before you can perform these steps.

  1. Download and extract the archive to a folder on the Reporting and Analytics application server.
  2. Copy ntlmauth.dll from /x64/ for 64-bit operating systems and /x86/ for 32-bit operating systems to %JAVA_HOME%\bin\
  3. Copy the following files to the folder containing the tool:
    • myPortal\microsConfig.properties

    • myPortal\bin\c.properties

    • myPortal\bin\myportal

  4. Create a folder to store output metadata .CSV files and migration log files. For example, root:\Output
  5. In a command prompt, navigate to the folder to which you extracted the tool.
  6. Enter the following command and arguments to run the tool:

    java —jar MetadataExtract.jar argument1 argument2 argument3 argument4 argument5

    1. argument1: Enter the path to the folder containing the organization ID folders. By default, this path is root:\myMicros\pentaho-solutions\myMicros\
    2. argument2: Enter the path to the output folder you created in Step 4.
    3. argument3: Enter true to export a .CSV file and insert the metadata into the Enterprise Back Office database, or enter false to create the .CSV file without inserting the metadata into the database.
    4. argument4: Enter the Reporting and Analytics major and minor version from which you are upgrading: 8.5 or 8.4.
    5. argument5: Enter the path to the folder to which you copied the files in Step 3.

    For example: java —jar MetadataExtract.jar C:\myMicros\pentaho-solutions\myMicros C:\Output true 8.5 C:\MigrationTool

  7. Navigate to the output directory and verify the metadata files and the logs.