Export Results to Data Bridge
Overview
RMS Data Bridge is a service that facilitates the migration from on-premise RiskLink/Risk Browser solutions to cloud-based RDMs and EDMs on Risk Intelligence.
Analysis results data includes all metrics generated using DLM, HD, and ALM models during catastrophe modeling. By default this data is stored in a cloud-based RDM. Once results data is exported to Data Bridge, customers may run T-SQL-based data management solutions on results data stored EDMs on managed SQL Server instances.
Step 1: Export RDM
The Export data module to file resource enables you to export analysis results to an RDM database on a Data Bridge SQL Server instance.
The required serverName
path parameter specifies the name of a managed SQL Server instance on Data Bridge.
-curl --location -g --request POST {host}/riskmodeler/v2/exports?servername={servername}' \
--header 'Authorization: {api_key}'
All other attributes are specified in the request body.
{
"analysisIds": [1424],
"rdmName": "sampleDb",
"type": "ResultsExportInputV2",
"exportType": "RDM"
}
The type
attribute is required.
- The
required
type attribute identifies the type of the workflow job. Must beRdmExportInputV2
to export results data to Data Bridge. - The
exportType
attribute specifies the database type. One of RDM or EDM. - The
analysisIds
attribute specifies an array of analysis IDs. - The
rdmName
attribute specifies the name of the RDM.
If successful, the resource adds an export RDM job to the workflow engine queue and returns a 202 Accepted
status code with the workflow ID in the Location
HTTP header of the response.
Step 2: Retrieve export job status
The Get workflow or operation resource retrieves information about a specific job.
The workflow ID is specified in the endpoint path. Use the workflowId
, you retrieved from the Location
HTTP header in Step 1.
When the job is complete, the status is set to FINISHED
.
Updated about 1 year ago