1 / 13

A non-statistical data exchange scenario

Agilis Statistics & Informatics Ltd. presents their experience in providing SDMX consulting, training, and software development services for the International Social Security Association (ISSA). Learn how they implemented a standardized and efficient solution for data exchange between member organizations, minimizing manual work and supporting different data exchanges from the same data source.

leep
Download Presentation

A non-statistical data exchange scenario

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A non-statistical data exchange scenario Agilis Statistics & InformaticsLtd SDMX experience in the International Social Security Association

  2. About Agilis • Agilis SA Statistics and Informatics (Greece) – since 1998 • Agilis Statistics and Informatics Ltd (Cyprus) – since 2015 • SDMX Consulting, Training and Software Development Services since 2005 • International Clientele • Active participation and contribution in the evolution of: • SDMX 2.1 • VTL/SDMX • SDMX 3.0 SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  3. About ISSA (www.issa.int) • The leading international organization for social security institutions, departments and agencies • Headquarters in Geneva (ILO) • Founded in 1927, ISSA counts today 340 members in over 160 countries • Provides information, research, expert advice and platforms for members to build and promote dynamic social security systems and policy worldwide • Main working topics – Improving efficiency on implementing social security schemes: • Pensions, Family benefits, Health, Maternity benefits, etc. • A key working area is the international social security coordination: • Enabling social protection of migrant and cross-border workers SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  4. Case Study • ISSA supports data exchange between its member organizations • Data exchanges concern social security information • The member organizations setup bilateral data exchanges • Each bilateral setup may require different technical solutions and content agreements • A lot of manual work is usually involved in such exchanges SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  5. Requirements • ISSA needed to provide a solution for data exchange to its client organizations • In a standardized way • Minimizing software development • Providing different options to existing or new infrastructures • Considering existing standardization attempts • Extending the data messages to support more use cases • Support different data exchanges from the same data source SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  6. Solution • SDMX provides the standardization for: • Query and data messages • Exchange patterns • Metadata • A Data Structure Definition acts as the superset of the exchanged data • Dataflows can subset/constrain the content for the specific exchange • Structural metadata are maintained by ISSA • Member Countries use metadata to exchange data bilaterally SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  7. SDMX Software to support the use cases • Metadata management • Euro SDMX Registry • Automated Web Service Data Exchange • SDMX-RI Web Services • Query and Data generation • Mapping Assistant • SDMX-RI Desktop Client (aka Test Client) • SDMX Converter for • File conversion between SDMX ISSA standard model and legacy/organizational data formats • SMART SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  8. Other considerations • Digital signatures, encryption and secure transmission ensure • Confidentiality • Message integrity • Non repudiation • WS Security in SOAP • Digital signatures and secure environment (eTESTA, Nextcloud) for file exchange • Manual encryption/decryption when required SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  9. Independent Data Transmission and Signing & Encrypting tools Requestor (DDM data consumer) Responder (DDM data provider) Independent Secure Channel Create request Decrypt request Mapping between a Data Flow (DF) and a local database Text/XML editor Gpg4win SDMX-RI Desktop Client Identify requestor Gpg4win Sign and encrypt SEND Gpg4win Authorise eTESTA Nextcloud Internal Process Read request Decrypt response SDMX-RI Desktop Client Gpg4win Mapping between a Data Flow (DF) and a local database Prepare response Identify responder SDMX-RI Desktop Client Gpg4win SDMX SMART Sign and encrypt Process response SEND Gpg4win SDMX Converter SDMX SMART SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  10. Independent Data Transmission with integrated security features Requestor (DDM data consumer) Responder (DDM data provider) Independent Secure Channel Create request Decrypt request SDMX-RI Desktop Client Gpg4win Mapping between a Data Flow (DF) and a local database Identify requestor Gpg4win Sign and encrypt SEND SDMX-RI Desktop Client Authorise Internal Process eTESTA Nextcloud Read request Decrypt response SDMX-RI Desktop Client Mapping between a Data Flow (DF) and a local database SDMX-RI Desktop Client Prepare response Identify responder SDMX-RI Desktop Client SDMX-RI Desktop Client SDMX SMART Sign and encrypt Process response SEND Gpg4win SDMX Converter SDMX SMART SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  11. Automated Data Exchange Requestor (DDM data consumer) Responder (DDM data provider) Internet Create request Decrypt request SDMX-RI Web Client SDMX-RI WS Mapping between a Data Flow (DF) and a local database Identify requestor SDMX-RI WS Sign and encrypt SEND SDMX-RI Web Client Authorise SDMX-RI WS HTTPS Read request Decrypt response SDMX-RI WS Mapping between a Data Flow (DF) and a local database SDMX-RI Web Client Prepare response Identify responder SDMX-RI WS SDMX-RI Web Client Sign and encrypt Process response SEND SDMX-RI WS SDMX-RI Web Client SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  12. Further Contribution • WS Security extension to Eurostat’s SDMX-RI • Currently as a proof-of-concept • To be developed as a new feature/extension for all SDMX-RI users • Provide new use cases for ILO SMART SDMX software • Access secure Web Services SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd

  13. Thank you! Stratos Nikoloutsos agilis-sa.eu Stratos.Nikoloutsos@agilis-sa.eu

More Related