Difference between revisions of "Load example SDMX structures"
(→Overview) |
|||
Line 6: | Line 6: | ||
If you have access to structures in a suitable SDMX format like SDMX-ML (XML) or SDMX-JSON, you can start working immediately with those. Login using the admin account created at [[Install_Fusion_Metadata_Registry#2._Server_Settings|install]] and click the [[File:LoadStructuresOrReferenecMetadata.PNG]] button to load from file. | If you have access to structures in a suitable SDMX format like SDMX-ML (XML) or SDMX-JSON, you can start working immediately with those. Login using the admin account created at [[Install_Fusion_Metadata_Registry#2._Server_Settings|install]] and click the [[File:LoadStructuresOrReferenecMetadata.PNG]] button to load from file. | ||
− | The rest of this guide explains how to download some example structures from Metadata | + | The rest of this guide explains how to download some example structures from Fusion Metadata Registry (FMR) Demo site <code>https://demo.metadatatechnology.com/FusionRegistry</code> using the Environment Sync function. |
Note | Note |
Revision as of 03:22, 14 August 2023
Contents
Overview
SDMX structural metadata (structures for short) describe the data and need to be created before you can start working with the data itself. Structures in SDMX are equivalent to the empty tables and relationships in a SQL database before any data is inserted.
If you have access to structures in a suitable SDMX format like SDMX-ML (XML) or SDMX-JSON, you can start working immediately with those. Login using the admin account created at install and click the button to load from file.
The rest of this guide explains how to download some example structures from Fusion Metadata Registry (FMR) Demo site https://demo.metadatatechnology.com/FusionRegistry
using the Environment Sync function.
Note Please refer to this article which explains how Environment Sync works across different vesions of FMR.
Adding a Sync Environment
A Sync Environment is a remote Fusion Registry with which structures can be exchanged. In this case we're going to retrieve from structures from it.
- Login using the admin account
- From the left-hand menu choose >
Environments
- Choose the
Add Environments
button and enter:- ID: Demo
- URL: https://demo.metadatatechnology.com/FusionRegistry
- Select the newly created 'Demo' environment in the list and choose the
Sync Environment
button - When prompted for a username and password, click
Sync Anonymously
Your Fusion Registry should connect to the demonstration service and retrieve a list of all available structures.
Next, download the SDMX Agency Scheme.
Download the Agency Scheme
In SDMX, each structure is owned by a specific Agency so we first need to download the Agency Scheme.
- Click on Agency Schemes and check
SDMX:AGENCIES (1.0) - SDMX Agency Scheme
- Choose the
Pull Structure
button - When prompted for Sync Options, choose
Selected structures only
, and thePull
button - Acknowledge the report which should say that 1 structure has been created
Download all structures for the ECB Exchange Rates dataflow (EXR)
For demonstration purposes we are going to download all of the structures needed for the ECB's Exchange Rates dataflow, including Codelists, Concepts and the Data Structure Definition.
- Click on Dataflows and check
ECB:EXR (1.0) - ECB Exchange Rates
- Choose the
Pull Structure
button - When prompted for Sync Options, choose
Selected structures and descendents
, and thePull
button - The report should tell us that a number of changes have been made to the Registry including 11 Codelists, plus a Concept Scheme, Data Structure Definition and a Dataflow
Check
To see what has been loaded, you can navigate back to the Main menu
and select Bulk Actions
.
The left-hand panel will show the number of structures that have been created for each type, the right hand panel will show the details for a selected structure type.