5.14 Running the Migration Utility for ISO20022

Use this migration utility to import and export the ISO20022 message configurations from one environment to another, for example, from the development server to UAT, and subsequently to production. For information on configuring the ISO20022 message parameters, see Configurations for ISO20022 Message Parameters.

To use the utility, first export the configuration from the source environment and then import the file to the destination environment. To export the configuration, follow these steps:

  1. Navigate to the $FIC_HOME/Transaction_Processing/TF_Config_Migration_Util- ity/config directory.
  2. Open the Dynamic.properties file and update the placeholders as shown:

    Table 5-9 Configurations required in the Dynamic.properties file when running the export file

    Placeholder Update with...
    ##jdbcurl## Your JDBC URL.
    ##username## The Atomic Schema user name using which you want to execute the files.
    ##password## The Atomic Schema password for the user name.
    ##infodom## Your Infodom name.
    ##N_XSD_CONF_ID##

    Your ISO20022 ID. This is available in the n_xsd_conf_id column in the fcc_tf_xml_xsd_conf table.

    If you are providing multiple IDs, add the IDs separated by commas. For example, 1,2,3,4.
  3. Navigate to the TF_Config_Migration_Utility/bin directory and run the required com- mand.

./export.sh SEPA

To import the configuration, follow these steps:

  1. Navigate to the TF_Config_Migration_Utility/config directory.
  2. Open the Dynamic.properties file and update the placeholders as shown:

    Table 5-10 Configurations required in the Dynamic.properties file when running the import file

    Placeholder Update with...
    ##jdbcurl## Your JDBC URL.
    ##user- name## The Atomic Schema user name using which you want to execute the files.
    ##pass- word## The Atomic Schema password for the user name.
    ##infodom## Your Infodom name.
    ##N_XSD_- CONF_ID##

    Your ISO20022 ID. This is available in the n_xsd_conf_id column in the fcc_t- f_xml_xsd_conf table.

    If you are providing multiple IDs, add the IDs separated by commas. For example, 1,2,3,4.
  3. Navigate to the TF_Config_Migration_Utility/bin directory and run the required com- mand.

./ import.sh SEPA.