Enhancing Data Exchange for International Social Security Organizations

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
Independent
Secure
Channel
C
r
e
a
t
e
 
r
e
q
u
e
s
t
Sign and encrypt
Decrypt 
request
Identify requestor
Authorise
Decrypt 
response
Process
 response
Read 
request
Prepare 
response
Sign and encrypt
Identify responder
SEND
SEND
Text/XML editor
Gpg4win
SDMX-RI
Desktop Client
SDMX Converter
SDMX-RI
Desktop Client
Gpg4win
Gpg4win
Internal Process
Gpg4win
eTESTA
Nextcloud
Gpg4win
Gpg4win
SDMX-RI
Desktop Client
Requestor (DDM data consumer)
Responder (DDM data provider)
Mapping between a
Data Flow (DF) and
a local database
Mapping between a
Data Flow (DF) and
a local database
SDMX SMART
September 2019
SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd
9
SDMX SMART
Independent Data Transmission with
integrated security features
Independent
Secure
Channel
C
r
e
a
t
e
 
r
e
q
u
e
s
t
Sign and encrypt
Decrypt 
request
Identify requestor
Authorise
Decrypt 
response
Process
 response
Read 
request
Prepare 
response
Sign and encrypt
Identify responder
SEND
SEND
SDMX-RI
Desktop Client
SDMX-RI
Desktop Client
SDMX-RI
Desktop Client
SDMX Converter
SDMX-RI
Desktop Client
Gpg4win
Internal Process
Gpg4win
eTESTA
Nextcloud
Gpg4win
SDMX-RI
Desktop Client
SDMX-RI
Desktop Client
Requestor (DDM data consumer)
Responder (DDM data provider)
Mapping between a
Data Flow (DF) and
a local database
Mapping between a
Data Flow (DF) and
a local database
SDMX SMART
September 2019
SDMX Global Conference 2019 – Agilis Statistics & Informatics Ltd
10
SDMX SMART
Automated Data Exchange
Internet
C
r
e
a
t
e
 
r
e
q
u
e
s
t
Sign and encrypt
Decrypt 
request
Identify requestor
Authorise
Decrypt 
response
Process
 response
Read 
request
Prepare 
response
Sign and encrypt
Identify responder
SEND
SEND
SDMX-RI Web
Client
SDMX-RI Web
Client
SDMX-RI WS
SDMX-RI Web
Client
SDMX-RI Web
Client
SDMX-RI WS
SDMX-RI WS
SDMX-RI WS
HTTPS
SDMX-RI WS
SDMX-RI Web
Client
SDMX-RI WS
Requestor (DDM data consumer)
Responder (DDM data provider)
Mapping between a
Data Flow (DF) and
a local database
Mapping between a
Data Flow (DF) and
a local database
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
Slide Note
Embed
Share

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.

  • Data exchange
  • Social security
  • Agilis
  • ISSA
  • SDMX

Uploaded on Sep 18, 2024 | 1 Views


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


  1. A non-statistical data exchange scenario Agilis Statistics & Informatics Ltd 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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 2

  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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 3

  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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 4

  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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 5

  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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 6

  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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 7

  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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 8

  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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 9

  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 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

  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 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

  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 September 2019 SDMX Global Conference 2019 Agilis Statistics & Informatics Ltd 12

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

More Related Content

giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#