Sunday, February 2, 2014

Import and Export Metadata using EM Console

Version: Oracle Identity Manager 11g R2
Description: The Enterprise Manager (EM) console has tools that allow you to import and export MDS files. The out-of-the-box import and export scripts, namely "weblogicExportMetadata", "weblogicImportMetadata", and " weblogic.properties", located in "$MW_HOME/Oracle_IDM1/server/bin" have been deprecated. An example is given here to show you how to use the EM import and export utilities.


Export Utility

1. Log in to EM console (ADMINHOST:7001/em).



2. Open up System MBean Browser (Expand WebLogic Domain and right click your OIM domain).



3. Expand Application Defined MBeans -> oracle.mds.lcm -> Server: OIM_SERVER_NAME -> Application: OIMMetadata -> MDSAppRuntime and double click the "MDSAppRuntime" bean.



4. Click the Operations tab and select exportMetadata.


5. Specify destination path for "toLocation" parameter and the MDS file name to export for "docs" parameter. Then click Invoke. You can query mds_paths.path_fullname (table.column) from your MDS Schema to get all the names of MDS files.



Import Utility

1. Follow steps 1-3 from Export Utility.

2. Click Operations tab and select importMetadata.


3. Specify the directory path of where the import file is for "fromLocation" parameter and the MDS file name to import for "docs" parameter. Make sure you use the MDS path_fullname. Then click Invoke.


4. Query the mds_paths table to validate whether your metadata file has been updated. The record with PATH_HIGH_CN set to NULL is the active metadata. The previous metadata should be inactive since PATH_HIGH_CN has a value.




3 comments:

  1. How do I export all the files from MDS? I'm not able to give * or /* to export all files from MDS>

    ReplyDelete
  2. Please change the third step and instead of OIMMetadata use OIMAppMetadata.

    Expand Application Defined MBeans -> oracle.mds.lcm -> Server: OIM_SERVER_NAME -> Application: OIMAppMetadata -> MDSAppRuntime and double click the "MDSAppRuntime" bean.

    ReplyDelete