SDMX Tools Interactive demonstrations ESTP Workshop on SDMX

SDMX Tools Interactive demonstrations ESTP Workshop on SDMX in National Accounts Luxembourg, 16 -18 March 2016 Eurostat

SDMX Tools - Demos • SDMX Converter • Graphical user interface • Batch mode, proof of concept • SDMX Reference Infrastructure (SDMX-RI) • • SDMX-RI Mapping Assistant Web Client (push, disseminate) Test Client (push) Web Service (pull) • ISTAT SDMX Loader & SDMX-RI • Eurostat Structural Validation Service (STRUVAL) Eurostat

Always needed: Data Structure Definitions (DSDs) DSD ID DSD Title MAIN SEC Main aggregates Sector accounts and government finance SU Supply / use and input / output statistics Regional statistics Pension schemes REG PENS Tables in transmission programs from 2014 ESA / OECD: 1, 3, 5, 20, 22 ESA / OECD: 2, 6, 7, 8, 9, 11, 26, 27, 28 ECB: MUFA, GFS EDP: 1, 2, 3, 4 OECD: 119, 7 HH, 7 II, PSD G 20: Recommendation 15 ESA: 15, 16, 17, 18, 19 ESA: 10, 12, 13 ESA: 29 Eurostat

Used today: NA Main Aggregates DSD ID DSD Title MAIN SEC Main aggregates Sector accounts and government finance SU Supply / use and input / output statistics Regional statistics Pension schemes REG PENS Tables in transmission programs from 2014 ESA / OECD: 1, 3, 5, 20, 22 ESA / OECD: 2, 6, 7, 8, 9, 11, 26, 27, 28 ECB: MUFA, GFS EDP: 1, 2, 3, 4 OECD: 119, 7 HH, 7 II, PSD G 20: Recommendation 15 ESA : 15, 16, 17, 18, 19 ESA : 10, 12, 13 ESA: 29 Eurostat

SDMX Tools - Demos • SDMX Converter • Graphical user interface • Batch mode, proof of concept • SDMX Reference Infrastructure (SDMX-RI) • • SDMX-RI Mapping Assistant Web Client (push, disseminate) Test Client (push) Web Service (pull) • ISTAT SDMX Loader & SDMX-RI • Eurostat Structural Validation Service (STRUVAL) Eurostat

SDMX Reference Infrastructure https: //webgate. ec. europa. eu/fpfis/mwikis/sdmx/index. php/SDMX_Reference_Infrastr ucture_SDMX-RI Data Provider Data Collector SDMX Registry Mapping Assistant DSD Web Svc Non-SDMX local database Test Client SDMX-RI Eurostat Web Client SDMX data set

What we have done before this demo • Installed Microsoft SQL Server Express 2014 • Created an empty database MASTORE_NA • Created a demo database NA with some sample data • For part 1: Installed SDMX-RI tools (xcopy versions) • • • Mapping Assistant. net 5. 0. 5 (ultimate version) Test. Client. net 4. 1. 4 (ultimate version) NSI Web Service. net 4. 0. 6 (ultimate version) NSI Web Client. net 3. 1. 1 (ultimate version) Configured Web Service and Web Client in IIS Downloaded SDMX-NA package (DSDs, Dataflows, Excel templates) • For part 2: Installed ISTAT Loader application

SDMX Reference Infrastructure https: //webgate. ec. europa. eu/fpfis/mwikis/sdmx/index. php/SDMX_Reference_Infrastr ucture_SDMX-RI Data Provider Data Collector SDMX Registry Mapping Assistant DSD Web Svc Non-SDMX local database Test Client SDMX-RI Eurostat Web Client SDMX data set

SDMX Reference Infrastructure https: //webgate. ec. europa. eu/fpfis/mwikis/sdmx/index. php/SDMX_Reference_Infrastr ucture_SDMX-RI Data Provider Data Collector SDMX Registry Mapping Assistant DSD Web Svc Non-SDMX local database Test Client SDMX-RI Eurostat Web Client SDMX data set

SDMX Tools - Demos • SDMX Converter • Graphical user interface • Batch mode, proof of concept • SDMX Reference Infrastructure (SDMX-RI) • • SDMX-RI Mapping Assistant Web Client (push, disseminate) Test Client (push) Web Service (pull) • ISTAT SDMX Loader & SDMX-RI • Eurostat Structural Validation Service (STRUVAL) Eurostat

National Source (e. g. CSV) ISTAT Loader & SDMX-RI http: //sdmx 2. istat. it/sodidownload/Download. aspx Data Provider ISTAT Loader Data Collector SDMX Registry Mapping Assistant DSD Web Svc SDMX compliant local database Test Client SDMX-RI Eurostat Web Client SDMX data set

User manager Publish dataflows Import Data files Definition of the mapping Creation of Data Tables Import dataflows from MS Flow of the application

Definition of the mapping Creation of Data Tables Import dataflows from MS A Creation of new users Publish dataflows Import Data files Flow of the application Administrator user DSD user Dataflow user

CSV Mapping 15 th column= TIME_PERIOD

FLR mapping TIME_PERIOD (from 27 th to 30 th character)

What we have done before this demo • Installed Microsoft SQL Server Express 2014 • Created an empty database MASTORE_NA • Created a demo database NA with some sample data • For part 1: Installed SDMX-RI tools (xcopy versions) • • • Mapping Assistant. net 5. 0. 5 (ultimate version) Test. Client. net 4. 1. 4 (ultimate version) NSI Web Service. net 4. 0. 6 (ultimate version) NSI Web Client. net 3. 1. 1 (ultimate version) Configured Web Service and Web Client in IIS Downloaded SDMX-NA package (DSDs, Dataflows, Excel templates) • For part 2: Installed ISTAT Loader application

SDMX Tools - Demos • SDMX Converter • Graphical user interface • Batch mode, proof of concept • SDMX Reference Infrastructure (SDMX-RI) • • SDMX-RI Mapping Assistant Web Client (push, disseminate) Test Client (push) Web Service (pull) • ISTAT SDMX Loader & SDMX-RI • Eurostat Structural Validation Service (STRUVAL) Eurostat

Further Information • SDMX-NA maintenance page • http: //sdmx. org/? page_id=1498 • Eurostat SDMX Info Space • https: //webgate. ec. europa. eu/fpfis/mwikis/sdmx • ISTAT Loader • http: //sdmx 2. istat. it/sodidownload/Download. aspx • SDMX Support Team • ESTAT-Support-SDMX@ec. europa. eu Eurostat 20