5.1.3.2 IRC Data Migration

On-prem to SaaS Migration

Data Export from On-prem

Users have to connect to the database and export the data in the prescribed CSV format. Name of the Data File must follow the format as given below:

• A prefix as INPUT_YYYYMMDD where the date format is related to the As of Date (i.e., 02-October-2023 becomes 20231002).
• A suffix as _FILENAME.CSV.
• An example of Data File Name could be: INPUT_20231002_IRC_<DATAFILENAME>.csv.

  The order of the columns in the input file must be as follows:

  • INTEREST_RATE_NAME
  • EFFECTIVE_DATE (Date format: MM-DD-YYYY)
  • INTEREST_RATE_TERM
  • INTEREST_RATE_TERM_MULT
  • INTEREST_RATE
  • RATE_DATA_SOURCE_CODE

Data Import to SaaS

For more information on importing the data, see Interest Rates Loader.

SaaS to SaaS Migration

Data Export from SaaS

Users have to export data using the Data Maintenance Interface and select the VW_FSI_IRC_RATE_HIST view. For more information about how to export data using the Data Maintenance Interface, see Data Maintenance Interface.

Data Import to SaaS

For importing the data, see Interest Rates Loader.