Introduction

The Data Structure Wizard (or so-called DSW) is a tool that has been developed by Eurostat to create and maintain SDMX artefacts, the most notable example being the Data Structure Definitions (so-called DSDs), the key artefact in SDMX that describes the structure and organisation of a data set.

For the more technically-minded, the DSW is a Java standalone desktop application that supports version 2.0 & 2.1 of the SDMX standard. It can be used both offline (with a local repository) and on-line (connected to an SDMX Registry), depending on each user's preference and access rights.

Another facility of the application is that it offers the possibility to create dynamically a data message template for a specified DSD. These templates can be populated and then sample data files created for transformation to an HTML format and saved locally.

The DSW also provides a mechanism for importing/exporting SDMX-ML 2.0 & 2.1 DSDs and a mechanism for importing/exporting DSDs from/to GESMES/TS structure files. Furthermore, SDMX-ML 2.0 & 2.1 DSDs can be validated against SDMX standard schemes.

In the on-line mode, the tool communicates with any standard-compliant SDMX Registry (e.g. Eurostat SDMX Registry) offering in the same time all the functionalities provided in the offline mode, too. The application offers the possibility to connect to a SDMX Registry and update the local repository, if the right permissions are granted (query privilege). Moreover, after editing the DSD artefacts locally, the edited (or a new) artefact can be submitted to the SDMX Registry (“maintain” privilege).

Downloads

The software is available for download via CIRCABC.

Contact 

For queries on the DSW please send an email to ESTAT-SUPPORT-SDMX@ec.europa.eu

What functionalities does the DSW cover?

The DSW is a tool to create and maintain the following artefacts, according the version of the SDMX standard being used:

The following list details further functionality of the DSW:

• Dynamic creation of a template for a specified DSD in SDMX v2.0 and SDMX v2.1 messages

• Import and export of artefacts from/to SDMX-ML v2.0 and SDMX v2.1 messages

• Import and export of DSDs from/to GESMES/TS structure files

• Import Codelists from CSV files

• Download of structural metadata for use with GENEDI tool

• Validate a SDMX-ML file against the Structure XML schema

• Interaction with any standard-compliant SDMX Registry

• Define multiple SDMX Registry configurations and configure a network proxy server

• Connection to SDMX Registry with "query" privilege and update of the local repository of artefacts

• Update of the SDMX Registry, using the "maintain" privilege, with an artefact that was edited or created locally

• Print of summary reports for Codelists, Concepts from ConceptSchemes, DSDs, Dataflows

• Print reports for the DSDs components and for the Codes from Codelists

• Advanced search (search Dataflow for a specified DSD, search DSD for a specified Dataflow, search all DSDs using a code list and search all the DSDs using a given concept)

• Create XML schemas for Data Structure Definition artefacts, for different message formats

• Create MIGs for Data Structure Definition artefacts

• Create SDMX queries starting from a specific statistical domain

• Generate SDMX-ML DataSets (message templates) using a specific DSD