utility to import,export and delete from MDS database 11gR2 weblogic.properties

 commands that we can use to export and import files from MDS data from OIM 11gR2

in order to avoid confusion about either you need to use export or import . think as MDS database. if you want to get files from this database you have to use export and if you want to put files into this database you have to use import files to database.

if you have ldapMetadata folder than export utility will import files inside of ldapMetadata otherwise it will be ignored

please make sure to create folder and subfolder while importing from MDS schema

$mkdir -p /tmp/stage/db/ldapMetadata

MDS utility is located under $OIM_HOME/server/bin

weblogic.properties files parameters use one parameter each. make changes in weblogic.properties file and run.

utilities ( weblogicImportMetadata.sh,weblogicExportMetadata.sh,weblogicDeleteMetadata.sh).


$ ./weblogicExportMetadata.sh
# Directory location to which XML file should be exported to
metadata_to_loc=/tmp/stage
# For example /file/User.xml to export user entity definition. You can specify multiple xml files as comma separated values.

$./weblogicImportMetadata.sh
in this folder or in its sub folders. Import utility tries to RECURSIVELY import ALL the files under the
# from location folder. This property is only used by weblogicImportMetadata.sh
# WARNING: weblogicImportMetadata utilities will import ALL xml inside the matedata_from_loc and will disregard metadata_files
metadata_from_loc=/tmp/stage/


$./weblogicDeleteMetadata.sh
#  This property is ONLY used by weblogicExportMetadata.sh and weblogicDeleteMetadata.sh scripts.

 below example is to delete EventHandlers.xml file
metadata_files=/db/ldapMetadata/EventHandlers.xml

if you want to import all the files under db than above parameter value will be
 metadata_files=/db/*


if you want to have files inside the ldapMetadata make sure to create folder inside db to get this file exported.

SQL command to check MDS repository
SQL>connect dev_mds/password

SQL> select PATH_FULLNAME from mds_paths where upper(PATH_FULLNAME) like '%LDAP%'