Multi-Relational Import

Migrate exposure data to a cloud-based EDM on Inteilligent Risk Platform

Overview

Multi-relational import (MRI) is a data migration process that enables Intelligent Risk Platform™ tenants to import account and location data into an EDM.

MRI utilizes flat files of account, location, reinsurance exposure data. A flat file is a delimited text file that stores structured data in a plain text format. MRI leverages a separate mapping file to define the relationships between the account, location, and reinsurance exposures.

While you can use Risk Modeler API services to securely connect to storage buckets on the Amazon S3, you must use an AWS to upload flat files of data to those storage buckets. Once you have uploaded source files, you can use Risk Modeler API operations to import the exposure data in those flat files into an EDM.

🍇

Data Migration

RMS supports several methods for importing exposure data into tenant EDMs. To learn more, see Import Exposure Data.

MRI workflow

The MRI import process combines RMS Risk Modeler APIs and custom processes that leverage Amazon Web Services (AWS).

The MRI process consists of seven steps:

  1. Create a storage bucket.
    A storage bucket is a public resource for storing objects on Amazon S3. MRI leverage Amazon Web Services to upload and temporarily store exposure data in to a storage bucket prior to importing that data into an EDM.
  2. Upload account data to the storage bucket.
    Create an account source file and upload that file to the storage bucket using a combination of Risk Modeler API operations and Amazon Web Services.
  3. Upload location data to the storage bucket.
    Create a location source file and upload that file to the storage bucket using a combination of Risk Modeler API operations and Amazon Web Services.
  4. Upload reinsurance data to the storage bucket.
    Create a reinsurance source file and upload that file to the storage bucket using a combination of Risk Modeler API operations and Amazon Web Services.
  5. Upload the import mapping file.
    Create an import mapping file and upload that file to the storage bucket using a combination of Risk Modeler API operations and Amazon Web Services.
  6. Import exposure data into the EDM.
    Once you have uploaded the source files and mapping file to the storage bucket, import that data into the EDM using the Risk Modeler API.
  7. Validate MRI import.
    Run an exposure summary report to confirm that the exposures were successfully imported into the EDM.

Next steps

The first step is to create an storage bucket to hold the account, location, reinsurance, and file mappings for the MRI import job.