Refresh the RPD Lineage Metadata

If the Oracle Healthcare Foundation SSA RPD files has been extended, follow the instructions below to refresh the RPD lineage metadata:

1. Open the extended RPD file in the Oracle Business Intelligence Administration Tool.
2. Go to Tools and select Utilities.
3. Select Repository Documentation and click Execute.

   Figure 4-1 Utilities Window

   
4. Navigate to a directory where you want to save the repository metadata.
5. In the Save as type: selection box, choose Tab Separated Values (*.txt).
6. Enter a name for the file and click Save.

   Figure 4-2 Saving the RPD Data Lineage

   
7. After the export completes, change the file's extension from .txt to .tsv.
8. Open SQL Developer.
9. Connect to the OHF Exterprise Schema where the OHF_RPD_LINEAGE table is installed.
10. Expand the Tables Section.
11. Right click on the OHF_RPD_LINEAGE table and select Import Data.
12. In the file browser, navigate to the location where you exported the RPD metadata file.
13. Choose the *.tsv file type and select the exported RPD metadata file.
14. Click Open.
15. When prompted to Import Data Record Terminator, click OK.
16. When prompted to Import Data Field Format, click OK.
17. In the Data Preview screen of the Data Import Wizard, set the Left Enclosure to none.

    Figure 4-3 Data Preview

    
18. In the Import Data Field Format screen, click OK.
19. Click Next.
20. In the Import Method screen, click Next.
21. In the Selected Columns panel, make sure all columns are listed and click Next.
22. In the Column Definition screen, map all the source data columns to the target table columns. The source and target columns have similar names and can be matched either by name or by order.

    Figure 4-4 Column Definition

    
23. After you map all the columns, click Next.
24. Clisk Finish.
25. A data import progress screen is displayed.
26. After the import is complete, a success message is displayed. Click OK.
27. Query the OHF_RPD_LINEAGE table to retrieve the record count and compare it with the row count in the RPD Metadata file:

    Select count(*) from OHF_RPD_LINEAGE;