Register EDMs with Risk Modeler

Register Data Bridge EDMs with Intelligent Risk Platform using Risk Modeler API services

Overview

RMS Data Bridge facilitates the migration from RMS Risk Browser/RiskLink to the cloud-based Risk Modeler workflows by enabling customers to import existing EDMs and RDMs.

📘

This process uses a combination of Risk Modeler and Data Bridge API services.

Step 1: Import database to Data Bridge

Data Bridge APIs define services that enable authenticated users to import databases (including EDMs and RDMs) to Data Bridge. Once these databases are on Data Bridge, they may use Risk Modeler API services to register those databases.

The Data Bridge APIs provide two methods for managing the importing of databases from on-premise SQL Server instances to managed SQL Server instances on Data Bridge:

  • The Database API defines a service that enables you to upload and import data from relatively small database artifacts. Use this service for one-off uploads of smaller database artifacts (less than 5GB in size).
  • The Import/Upload API defines services that enable you to upload and import large files (greater than 5GB in size) in multiple parts. Use this service for API integrations. To learn more, see Import Databases.

You will need to know the ID number (the serverId) of the managed SQL Server instance to register the databases on that instance with Risk Modeler.

Step 2: Retrieve backup file location

The Get data modules service enables you to retrieve information about the databases on a managed SQL Server instance on Data Bridge. A managed SQL Server instance is an instance of a Microsoft SQL Server that is hosted and managed by Data Bridge.

The required serverId path parameter specifies the ID number of a managed SQL Server instance. The service also accepts optional the dbType query parameter (EDM or RDM) and optional query parameters that you can use to filter and sort the databases returned : q, sort, limited, offset.

-curl --location -g --request GET 'https://{host}/riskmodeler/v1/data-bridge/{serverId}/databases?dbType=EDM' \
--header 'Authorization: {api_key}'

A successful response returns a 200 OK status code and an array of Data Bridge databases. For each database, the service returns the id, serverId, status, version, and datasource.

{
  "totalResults": 2,
  "dataBridgeDatabases": [
    {
      "id": 2,
      "serverId": 2,
      "status": "INACTIVE",
      "version": "18.0",
      "datasource": "EDM_NAWF_CLIENT2_X_geo"
    },
        {
      "id": 3,
      "serverId": 2,
      "status": "INACTIVE",
      "version": "18.0",
      "datasource": "Perf_UKFL_1M_EDM"
    }
  ]
}

Step 3: Register EDM database

The Register EDM service enables you to register a managed Data Bridge EDM with Risk Modeler.

The required datasourcename query parameter specifies the EDM.

curl --location --request POST 'https://{host}/riskmodeler/v1/data-bridge/register?datasourcename=new-edm' \
--header 'Authorization: {api_key}'

The service returns 202 Accepted HTTP status code and initiates a REGISTER_DATA_BRIDGE_EDM workflow job on the workflow engine.


Did this page help you?