Qodex.ai

RiskModeler: Import RDM from BAK file

Number of APIs: 5

This is a self sufficient end-to-end Qodex collection to import any local RDM file in BAK format into Risk Modeler.

Pre-Requisites:

  1. Access to up and running Tenant with Risk Modeler
  2. API Key
  3. Local copy of RDM file in *.mdf or *.bak format

Quick Start:

  1. Add the following Environment Variables - (Refer: [Defining environment variables]
    1. API_KEY = {Your API Key}
    2. FILE_NAME = {RDM file name without extension}
    3. FILE_EXT = {File extension of your RDM file}
    4. EDM_NAME = {Existing EDM Name in RiskModeler you want the RDM to be associated with, optional}
    5. RMSAPIHOST = {Your RMS API host} (Refer: Quick Start)
    6. FILENAMEUUID = {Add a unique UUID for your file}
      We have created a sample environment variable template Sample Environment - RiskModeler_July_2022: Import RDM from BAK file for your convenience. (Refer: [selecting an active environment] )
  2. Open Request body of PUT Uploading to S3 and select your file from your local machine

  1. Get S3 Upload Details - GET /riskmodeler/v1/uploads GET https://{{RMS_API_HOST}}/riskmodeler/v1/uploads?fileextension={{FILE_EXT}}&dbtype=RDM&filename={{FILE_NAME_UUID}}.{{FILE_EXT}}

  2. Create Multpart Upload to S3 - AWS Service POST https://{{s3_host}}.amazonaws.com/{{s3_path}}/{{s3_filename}}?uploads

  3. Uploading to S3 - AWS Service PUT https://{{s3_host}}.amazonaws.com/{{s3_path}}/{{s3_filename}}?partNumber=1&uploadId={{s3_uploadId}}

  4. Complete Multpart Upload to S3 - AWS Service POST https://{{s3_host}}.amazonaws.com/{{s3_path}}/{{s3_filename}}?uploadId={{s3_uploadId}}

  5. Submit RDM Job - POST /riskmodeler/v1/uploads/ POST https://{{RMS_API_HOST}}/riskmodeler/v1/uploads/{{rms_uploadId}}/rdm?uploadId={{rms_uploadId}}&rdmName={{FILE_NAME}}&edmDataSourceName={{EDM_NAME}}