Enhancing Data Exchange for International Social Security Organizations
Agilis Statistics & Informatics Ltd, in collaboration with the International Social Security Association (ISSA), presented a case study at the SDMX Global Conference 2019. The study focused on improving data exchange processes among member organizations of ISSA to facilitate social security information sharing. By addressing the challenges of manual work involved in bilateral data exchanges, Agilis proposed a solution to standardize the exchange, minimize software development, and extend data messages to support various use cases. This initiative aims to enhance efficiency and coordination in social security systems on an international scale.
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. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
A non-statistical data exchange scenario Agilis Statistics & Informatics Ltd SDMX experience in the International Social Security Association
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 2
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 3
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 4
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 5
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 6
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 7
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 8
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 9
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 SDMX-RI Desktop Client Mapping between a Data Flow (DF) and a local database 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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 10
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 Web Client SDMX-RI WS Mapping between a Data Flow (DF) and a local database Prepare response Identify responder SDMX-RI Web Client SDMX-RI WS Sign and encrypt Process response SEND SDMX-RI Web Client SDMX-RI WS September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 11
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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 12
Thank you! Stratos Nikoloutsos agilis-sa.eu Stratos.Nikoloutsos@agilis-sa.eu