Multi-Relational Import

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

Overview

Multi-relational import (MRI) is a process for importing exposure data into an EDM from a set of flat files uploaded to Amazon Simple Storage Service (Amazon S3).

The MRI process 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.

📘

Data Migration Options

RMS supports several different 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 an AWS SDK.

The MRI process consists of six steps:

12331233

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

  1. Create an S3 storage bucket on the AWS cloud.
    Use the Create storage bucket service to create an S3 storage bucket on the AWS cloud.
  2. Upload a flat file of account data to the S3 storage bucket.
    The account flat file contains account exposure data in a structured format. Use the Get credentials and file URI by S3 bucket service get temporary credentials to an S3 bucket and the AWS SDK to upload a flat file of account data to an S3 storage bucket.
  3. Upload a flat file of location data to the S3 storage bucket.
    The location flat file contains location exposure data in a structured format. Use the Get credentials and file URI by S3 bucket service get temporary credentials to an S3 bucket and the AWS SDK to upload a flat file of account data to an S3 storage bucket.
  4. Upload a flat file of reinsurance data to the S3 storage bucket.
    The reinsurance flat file contains reinsurance exposure data in a structured format. Use the Get credentials and file URI by S3 bucket service get temporary credentials to an S3 bucket and the AWS SDK to upload a flat file of account data to an S3 storage bucket.
  5. Upload mapping flat file.
    Use the Get credentials and file URI by S3 bucket service get temporary credentials to an S3 bucket and the AWS SDK to upload a file mappings to an S3 storage bucket.
  6. Import exposure data .
    Use the Import data service to import exposure data from the the flat files uploaded to the S3 storage bucket. The import job retrieves exposure data uploaded to the S3 storage bucket and imports that data 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.

Did this page help you?