Load example datasets - Revision history

Vmurrell: /* Load the TRD External Trade data */

2023-08-08T13:58:29Z

‎Load the TRD External Trade data

2023-08-08T13:56:35Z

‎Load the TRD External Trade data

2023-08-08T13:55:54Z

‎Load the EXR Exchange Rates data

2023-08-08T13:54:53Z

‎Link the Provision Agreement to the database connection

2023-08-08T13:51:02Z

‎Create an SDMX Provision Agreement

2023-08-08T13:50:49Z

‎Create an SDMX Data Provider

2023-08-08T13:49:53Z

‎Create an SDMX Data Provider

2023-08-08T13:44:33Z

‎Create an SDMX Provision Agreement

2023-08-08T13:43:31Z

‎Overview

2023-08-08T13:33:52Z

‎Overview

@@ Line 78: / Line 78: @@
 The loaded data now needs to be published to the TRD Dataflow.
-* Still on the Dataset Details page, locate the <code>Provision Agreement</code> field and choose the 'ECB:EXR_SDMX_MYDP(1.0)' Provision Agreement from the select box
+* Still on the Dataset Details page, locate the <code>Provision Agreement</code> field and choose the 'ECB:TRD_SDMX_MYDP(1.0) - My Data Provider for External Trade' Provision Agreement from the select box
 * Under <code>Action</code>, choose the <code>Re-Verify Data</code> button - this rechecks the data for compliance with any SDMX Reporting Constraints that may be defined for the Provision Agreement
 * Choose the <code>Publish Data</code> button
 * In the Publish Data popup, choose <code>Append</code> as the Action, and click the <code>Upload</code> button
 * You should receive a notification that the data has been successfully published

@@ Line 77: / Line 77: @@
 The load process may take around 60 seconds while the data is retrieved from the demonstration web service and validated. Once loaded, the Dataset Details page shows the result of the validation, for instance whether the data is semantically compliant (the values comply with the rules specified in the Data Structure). You may see some Time Period Format errors which can be safely ignored.
-The loaded data now needs to be published to the EXR Dataflow.
+The loaded data now needs to be published to the TRD Dataflow.
 * Still on the Dataset Details page, locate the <code>Provision Agreement</code> field and choose the 'ECB:EXR_SDMX_MYDP(1.0)' Provision Agreement from the select box
 * Under <code>Action</code>, choose the <code>Re-Verify Data</code> button - this rechecks the data for compliance with any SDMX Reporting Constraints that may be defined for the Provision Agreement

@@ Line 64: / Line 64: @@
 * Locate the <code>Linked Data Source</code> field at the bottom of the page - choose 'MYSQL_LOCAL' in the select box, and click the <code>Apply</code> button
-=Load the EXR Exchange Rates data=
+=Load the TRD External Trade  data=
 [[File:LoadDataFromUrl.PNG|thumbnail]]
 * Login to the admin account (if not already logged in)
@@ Line 72: / Line 72: @@
 ** Data Format: Auto Detect
 ** Data Structure: Auto Detect
-** Data URL: https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/.BGN+BRL+EGP...?format=sdmx-compact-2.1
+** Data URL: https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/ECB/TRD/1.0/?format=sdmx-compact-2.1
 ** Choose the <code>Load Data</code> button

@@ Line 58: / Line 58: @@
 =Link the Provision Agreement to the database connection=
-[[File:ProvisionAgreementsDataSource.PNG|thumbnail]]
+[[File:PA Select Data Source.png|thumbnail]]
 * Login to the admin account (if not already logged in)
 * From the left-hand menu choose <code>Data</code> > <code>Provision Agreements</code>

@@ Line 47: / Line 47: @@
 =Create an SDMX Provision Agreement=
-[[File:DataflowWizardStep3.PNG|thumbnail]]
+[[File:Choose Data Provider.png|thumbnail]]
 * Login to the admin account (if not already logged in)
 * From the left-hand menu choose <code>Data</code> > <code>Dataflows</code>

@@ Line 35: / Line 35: @@
 =Create an SDMX Data Provider=
 * Login to the admin account (if not already logged in)
 * From the left-hand menu choose <code>Organisations</code> > <code>Data Providers</code>

@@ Line 51: / Line 51: @@
 * Login to the admin account (if not already logged in)
 * From the left-hand menu choose <code>Data</code> > <code>Dataflows</code>
-* Select the 'EXR' EXB Exchange Rates Dataflow from the list
+* Select the 'TRD' EXB External Trade Dataflow from the list
 * Choose the [[File:Cogs.PNG|30px]] 'cogs' button and select <code>Edit Selected Dataflow</code>
 * On the Dataflow Wizard, use the <code>Next</code> button to move to Step 3 - Data Providers

← Older revision		Revision as of 13:43, 8 August 2023
Line 4:		Line 4:

	In this example, we are going to load some data from the ECB's TRD - External Trade dataset into SQL database storage managed by Fusion Registry.		In this example, we are going to load some data from the ECB's TRD - External Trade dataset into SQL database storage managed by Fusion Registry.
		+
		+	This example assumes that you have already loaded the Dataflow for the ECB's External dataflow TRD (1.) as discussed [https://wiki.sdmxcloud.org/Load_example_SDMX_structures in this article].

	We first need to prepare the Dataflow to receive data:		We first need to prepare the Dataflow to receive data:

@@ Line 3: / Line 3: @@
 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 SQL database storage managed by Fusion Registry.
+In this example, we are going to load some data from the ECB's TRD - External Trade dataset into SQL database storage managed by Fusion Registry.
 We first need to prepare the Dataflow to receive data:
@@ Line 11: / Line 11: @@
 * Link the Provision Agreement to the MySQL database connection
-Once the Dataflow has been prepared, the data will be loaded directly from Metadata Technology's Fusion Registry demononstration service.
+Once the Dataflow has been prepared, the data will be loaded directly from Metadata Technology's Fusion Registry demonstration service.
 =Add a database connection for data storage=