May 2025

🥥

Highlights

The May release introduces updates to the Archives and Databases collections of API operations.

  • The List Archives by Server Instance operation now supports filtering and soriting.
  • The List Databases operation now supports administrative access to all databases.
  • Moodys Insurance Solutions now supports Version 25. Version 25 databases are added to the versions supported for upload.

Learn More

Archives

Search Archives

The List Archives by Server Instance operation returns a list of the archived databases on the specified managed SQL Server instance.

This operation now supports filtering, sorting, and pagination.

PropertyTypeComparisonListLogical
archiveIdString=, !=, >, <, >=, <=INAND. OR
nameString=, !=, >, <, >=, <=, LIKEINAND. OR
sizeInMbNumber=, !=, >, <, >=, <=INAND. OR
createDateDate=, !=, >, <, >=, <=INAND. OR
expiryDateDate=, !=, >, <, >=, <=INAND. OR
createdByString=, !=, >, <, >=, <=, LIKEINAND. OR
storageTypeIdNumber=, !=, >, <, >=, <=INAND. OR

This operation supports sorting response data based by the following property values: archiveId, createDate, createdBy, expiryDate, name , serverName, sizeInMb , and storageTypeId.

Get Archive

The Get Archive operation returns detailed information about the specified archive.

An archive is a copy of a database that is stored in Data Vault.

This operation now returns Data Vault details.

{
  "archiveId": 5555,
  "serverName": "sql-instance-1",
  "name": "string",
  "databaseType": "EDM",
  "sizeInMb": 1833,
  "createDate": "2025-04-10T20:45:28.775Z",
  "expiryDate": "2025-09-10T20:45:28.775Z",
  "createdBy": "[email protected]",
  "downloadUris": ["string"]
}

Databases

List Databases

The List Databases operation (/databridge/v1/sql-instances/{instanceName}/databases) returns information about databases on the specified managed server instance including information about its size, status, and owner.

Access to information about databases (EDMs, RDMs, and custom databases) hosted on Data Bridge is managed by means of tenant security and role-based permissions. Tenant security enables organizations to segregate data and limit access based on business need. If enabled, tenant security limits access to managed databases based on group membership. Secured servers and databases can only be accessed by their owners or by groups explicitly granted access to those resources.

This operation now supports an optional adminaccess query parameter, which enables Data Bridge Admin role to view a complete list of databases regardless of ownership or tenant security access controls.

curl --request GET \
     --url https://api-euw1.rms.com/databridge/v1/sql-instances/89/Databases?adminaccess=true \
     --header 'accept: application/json'

This parameter is optional. If unspecified, a value of false is assumed. A value of true must be specified to view information about all databases on the server. The data returned depends on two factors: 1) tenant security and 2) role of the client application.

Admin Access ParameterTenant SecurityDB AdminConsumerContributor
false / UndefinedOFFAll databasesAll databasesAll databases
trueOFFAll databases403 Forbidden403 Forbidden
false / UndefinedONAccessible databasesAccessible databasesAccessible databases
trueONAll databases403 Forbidden403 Forbidden

Tenant security is an optional Data Bridge feature that must be enabled by a Data Admin. If tenant security is not enabled, client applications can generally view all databases regardless of role. To learn more, see Tenant Security

Data Bridge supports three roles: Data Bridge Admin, Consumer, and Contributor. To learn more, see Access Controls.

  • Client applications assigned the Data Bridge Admin role that pass a value of true in the adminaccess query parameter can view all databases on the specified server. If the parameter is false or undefined, the API returns information only about databases that are accessible to that client application.
  • Client applications assigned the Consumer or Contributor role cannot view all databases. If a Consumer or Contributor client passes a value of true in the adminaccess query parameter, the API returns a 403 Forbidden response.

EDM and RDM Upload and Download

Version 25 databases are added to the versions supported for upload. The upload process supports Moody's EDM databases in RiskLink/RiskBrowser versions 13, 15, 16, 17, 18, 21, 22, 23, 24, and 25. These can be created using SQL Server versions 2014 SP3, 2016 SP3, and 2019. During upload, the EDM schema is updated to RiskLink version 25 and to SQL Server version 2019.

Beginning with this update, RDMs are exported in Moody's Version 25 format only. For situations when you want to share the database with someone who is not on Version 25 or use it in an environment that is not upgraded to Version 25, Moody's provides a script on Support Center that downgrades the RDM to the version they need. Before running an upgrade/downgrade script on a database downloaded from an Intelligent Risk Platform™ application, run the RDM_transfer_from_RM.sql script on the database. The script is provided in DBSetup and with the upgrade/downgrade scripts. Download the script from the Support Center.