Prerequisites

  • All the required XML files like TFM XML, ETL Repository XML, Definition XML, Properties XML, Mapping XML must be present in the standard paths. (relative to the ftpshare folder)
  • Table AAI_ETL_SOURCE must be present in the Config Schema, with all appropriate information.
  • Ensure the DMTUpgradeUtility_806.sh file is present in $FIC_HOME/utility/DMT/Migration/bin folder.
  • Ensure aai-dmt-migration.jar must be present in $FIC_HOME/utility/DMT/Migration/lib. (This jar and other dependent OFSAA jars are available in the aforementioned path. The DMTUpgradeUtility_806.sh file contains the list of such jars.)
  • Ensure the Clusters.XML file is present in the $FIC_HOME/conf directory.
  • Ensure the ETLLoader.properties file is present in the $FIC_HOME/ficdb/conf directory.

To run the utility directly from the console:

  1. Navigate to $FIC_HOME/utility/DMT/Migration/bin folder
  2. Execute ./DMTUpgradeUtility_806.shwith the following arguments.

    Table 16-12 Argument Descriptions and their Values

    Argument Name Description Value
    MIGRATION TYPE Specify the mode of operation
    • UPGRADE (recommended mode)
    • ONLY_DEFINITION (recommended mode)
    • UPGRADE_AS_VERSION
    • ONLY_DEFINITION_AS_VERSION

    For more information, see Modes of Operation section.

    METADATA TYPE Specify the metadata type that you want to migrate.
    • ALL- to migrate all metadata types
    • Enter the specific metadata type that you want to migrate. The available metadata types are DMT_SRC, DMT_PLC, DMT_DM (to migrate F2T, T2T, and T2F), CLUSTERINFO (to migrate Cluster information), ETLPROPINFO (to migrate ETLLoader.properties)

    Note:

    DMT_SRC Metadata Type is supported only for Migration Type set as UPGRADE and ONLY_DEFINITION. Data Sources based on Table and WebLog are only supported for migration.
    INFODOM NAME

    Specify the information domain name.

    This argument is applicable only for MIGRATION TYPE as ONLY_DEFINITION and ONLY_DEFINITION_AS_VERSION.

    • ALL- to migrate metadata from all information domains.
    • Enter the specific information domain name if you want to migrate metadata of a particular information domain only.
    DEFINITION NAME

    Specify the definition name that you want to migrate.

    This argument is applicable only for MIGRATION TYPE as ONLY_DEFINITION and ONLY_DEFINITION_AS_VERSION.

    • ALL- to migrate all definitions
    • Enter the specific definition name that you want to migrate.
    • For DMT_SRC metadata type, specify as <Source Name 1>~<Infodom 1>,<Source Name 2>~<Infodom 2>,<Source Name3>~<Infodom 3>. That is, list of source and corresponding Infodom combination separated by comma.
    • For DMT_DM metadata type, specify as <Application Name>~<Source Name>~<Definition Name>.
    • For DMT_PLC metadata type, specify the definition name.