Difference between revisions of "Load example datasets"
Jump to navigation
Jump to search
(Created page with "=Overview= Fusion Registry is a 'virtual statistical data warehouse' meaning that the data it contains can either be loaded and held in storage managed by Fusion Registry, or...") |
|||
| Line 1: | Line 1: | ||
=Overview= | =Overview= | ||
| − | Fusion Registry is a 'virtual statistical data warehouse' meaning that the data it contains can either be loaded and held in storage managed by Fusion Registry, or retrived dynamically from external sources like SQL databases, SDMX REST web services | + | Fusion Registry is a 'virtual statistical data warehouse' meaning that the data it contains can either be loaded and held in storage managed by Fusion Registry, or retrived dynamically from external sources like SQL databases, SDMX REST web services or files. |
| − | In this example, we are going to load some data from the ECB's EXR Exchange Rate dataset into Fusion Registry. We first need to prepare the Dataflow to receive data: | + | In this example, we are going to load some data from the ECB's EXR Exchange Rate dataset into Fusion Registry. |
| + | |||
| + | We first need to prepare the Dataflow to receive data: | ||
| + | * Add a connection to our MySQL database to store the data | ||
* Create an SDMX Data Provider - this is the 'organisation' under which the data will be submitted under the SDMX Data Collection model | * Create an SDMX Data Provider - this is the 'organisation' under which the data will be submitted under the SDMX Data Collection model | ||
* Create an SDMX Provision Agreement - this is the SDMX structure which authorises the Data Provider to submit data to the Dataflow, and also defines where that data is stored | * Create an SDMX Provision Agreement - this is the SDMX structure which authorises the Data Provider to submit data to the Dataflow, and also defines where that data is stored | ||
| + | |||
| + | Once the Dataflow has been prepared, the data will be loaded directly from Metadata Technology's Fusion Registry demononstration service. | ||
| + | |||
| + | =Add a database connection for data storage= | ||
Revision as of 01:02, 23 September 2020
Overview
Fusion Registry is a 'virtual statistical data warehouse' meaning that the data it contains can either be loaded and held in storage managed by Fusion Registry, or retrived dynamically from external sources like SQL databases, SDMX REST web services or files.
In this example, we are going to load some data from the ECB's EXR Exchange Rate dataset into Fusion Registry.
We first need to prepare the Dataflow to receive data:
- Add a connection to our MySQL database to store the data
- Create an SDMX Data Provider - this is the 'organisation' under which the data will be submitted under the SDMX Data Collection model
- Create an SDMX Provision Agreement - this is the SDMX structure which authorises the Data Provider to submit data to the Dataflow, and also defines where that data is stored
Once the Dataflow has been prepared, the data will be loaded directly from Metadata Technology's Fusion Registry demononstration service.
