Efficient Solution for Data Exchange: SDMX-RI Overview
"Learn about SDMX-RI, a software for efficient data provision and exchange, designed to simplify reporting and dissemination processes. Discover the benefits, implementation, and when to use SDMX-RI for statistical databases." (248 characters)
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Photo by Markus Spiske, unsplash SDMX REFERENCE INFRASTRUCTURE Overview 7th Regional Workshop on Data and Metadata Exchange for Reporting on SDGs Egypt, Cairo 3 5 June 2024 Abdulla Gozalov United Nations Statistics Division
SDMX Reference Infrastructure (SDMX-RI) Software developed and maintained by Eurostat Implemented in Java and .Net First released in 2012 A suite of components that interact with each other Statistics Division 2
What is SDMX-RI? Software for SDMX data provision (dissemination and reporting) Set of pick-and-choose reusable building blocks, allowing the data provider to expose SDMX data to the external world Designed to translate internal data storages into SDMX compliant data files using mappings Uses SDMX standards specifications (v.2.0 and v2.1), including the one for Web Services Developed to simplify the exchange of data Provides standard software and components, allowing individual statistical organizations to interact and exchange their data using the same software and methodology Modular and extendable approach (modify, use part or the entire infrastructure) to suit different purposes WS is developed in both Java and .NET Statistics Division 3 Source: Eurostat
When and why do you need SDMX-RI? Your office maintains a dissemination database(s) with statistical data and You need to establish an Application Programming Interface (API) for your data You need to establish automated data exchange with international agencies You need to set up a data warehouse You have limited resources and need to maximize the efficiency In these circumstances, SDMX-RI is an efficient solution The most important prerequisite is one or more statistical database(s). SDMX-RI supports MS SQL Server, Oracle, and MySQL. If you use one of the above systems, you can use SDMX-RI. Statistics Division 4
SDMX-RI - identified advantages Covers dissemination and reporting requirements Facilitate the SDMX compliance phase Limited/no change of the existing environment, production or dissemination systems Limited/no need for adaptation Open source Reusable modules/installations through well-defined APIs Exhaustive and clear documentation Fully supported by Eurostat and used within and outside ESS IT Trainings available Statistics Division 5 Source: Eurostat
SDMX-RI: Main Components NSIWS. Web Service that provides the SDMX API. Mapping Assistant. A Web-based tool that is used to upload structures, define mappings between dissemination databases and the structures, and manage metadata and data published at the API. Web Client. An application that can connect to the API, browse published dataflows, and provide simple tabular visualizations of the data. Can be used to construct queries to the API. Test Client. A desktop application that can connect either to an API or directly to a Mapping Store database. Test Auth Config. A desktop application that sets up authentication and authorization in earlier versions of SDMX-RI. Statistics Division 6 Source: Eurostat
SDMX-RI: Diagram Web Client NSI Web Service Mapping Assistant Dissemination Databases Mapping Store Database Authentication Database Statistics Division 7
THANK YOU! Statistics Division 8
