Fusion Registry 10 Enterprise Edition

Live Demonstration

Web User Interface

Fusion Registry

The web user interface provides a comprehensive set of interactive tools for:

  • browsing, authoring and maintaining SDMX structural metadata
  • validating data
  • transforming data to different structures and coding schemes
  • converting data into different SDMX and non-SDMX formats
  • loading and storing data into Fusion Registry's managed data stores
  • registering distributed data sources - Fusion Registry can dynamically extract and integrate data from any number of sources
  • reference metadata management
  • transaction management and rollback
  • Fusion Edge Server environment management and data publication
  • audit
  • system administration

Fusion Data Browser

Fusion Data Browser is a separate data explorer, analysis and visualisation web tool designed for internal or external data consumers:

  • data discovery - search Fusion Registry's catalogue of data using the configurable hierarchical dataset explorer and free-text (Google style) search
  • select series from the search results
  • build charts and tables
  • export selected series in a range of formats including SDMX-ML, SDMX-CSV, SDMX-JSON and Excel
  • save charts
  • save queries
  • favourite datasets
  • create and save baskets of series
  • embed and link to charts

REST Application Programming Interface (API)

The REST API supports all of the standard SDMX services, plus a range of additional services specific to Fusion Registry. The web services guide describes the main services involved with managing metadata and data content. In total, there's over 100 web services providing programmatic control over every aspect of the system, details of which are available on request.

The Fusion Registry demonstration API web service entry point (ws-entry-point) is:
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest

Structural Metadata Queries

The basic syntax of a structure query is:
http(s)://ws-entry-point/resource/agencyID/version/itemID?queryStringParameters

  • resource is the structure type like 'codelist' or 'datastructure'. Use 'structure' to retrieve all structures.
  • agencyID is the ID of the maintenance agency that owns the structure(s) being queried for, 'ESTAT' for instance refers to Eurostat. Use 'all' to query for structures belonging to any agency.
  • version is the version of the structures, for instance '1.0' or '2.3'. Use 'latest' if you just want the latest versions.
  • queryStringParameters are additional URL parameters specfic to each web service. The web services guide has a detailed explanation.

Examples

1. Retrieve all structures in SDMX-ML 2.1 and save the result compressed in a file called 'structures.zip' GET
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/structure/all/all/latest/?format=sdmx-2.1&detail=full&references=none&saveAs=structures.zip

2. Retrieve the ECB's ECB_EXR1 Exchange Rate Data Structure Definition in SDMX-ML 2.1, together with all referenced structures (descendants) GET
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/datastructure/ECB/ECB_EXR1/1.0/?format=sdmx-2.1&detail=full&references=descendants

3. Retrieve all of the latest IMF Codelists in SDMX-JSON GET
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/codelist/IMF/all/latest/?format=sdmx-json&detail=full&references=none

Data Queries

The basic syntax of a data query is:

http(s)://ws-entry-point/resource/flowRef/key?queryStringParameters
  • resource is 'data' in this case. Use 'metadata' to retrieve Reference Metadata.
  • flowRef is the Agency, ID and Version of the Dataflow to query. For instance 'ECB,EXR,1.0' refers to version 1.0 of the ECB's EXR Dataflow.
  • key is the key pattern of the series to be returned, or 'all' for all series. The key pattern is a dot-separated list of the series' dimensions. So for a Dataflow with three dimensions FREQ, REF_AREA, and CURR, the key pattern 'A..' would return Annual series for all REF_AREA and CURR.
  • queryStringParameters are additional URL parameters specfic to each web service. The web services guide has a detailed explanation.

Examples

1. Retrieve ECB annual Exchange Rate data for the Swiss Franc in SDMX-ML 2.1 (compact) format. GET
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CHF...?format=sdmx-compact-2.1

2. Retrieve ECB annual Exchange Rate data in SDMX-JSON format for both the Swiss Franc and the US Dollar. GET
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CHF+USD...?format=sdmx-json

3. Retrieve ECB annual Exchange Rate data in Excel format for both the Swiss Franc and the US Dollar. GET
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CHF+USD...?format=excel

4. Retrieve just the keys in SDMX-ML 2.0 generic format for all series relating to Guatemala (GTM) under the World Bank EDUCATION Dataflow. GET
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,WDI_EDUCATION,1.0/..GTM?format=sdmx-generic-2.0&detail=serieskeysonly