Health & Consumers DG SANCO Unit A.4 Information systems

1. Health & Consumers DG SANCOUnit A.4 Information systems Member State Administrators’ management of TRACES reference data via web services– state of play TRACES Workshop Brussels

2. Contents • Background, summary and objective • Functional overview • Cities web service • Current status • Business web service • Current status • Future steps • Cities • Businesses • Using the service – impact for MS Admins (MSA) and for TRACES TRACES Workshop Brussels

3. Background and summary • TRACES web service exchange project for cities and businesses presented in Palermo, October 2009 • Pilot project: SANCO, Denmark, Greece, Italy (France) • Cities exchange functionality demonstrated in April 2010 • Business exchange development started • Some delays due to shifting priorities TRACES Workshop Brussels

4. Objective • Align and harmonise the ways in which TRACES reference data (= cities and businesses) is handled • Give MSA the opportunity to take active ownership of its reference data • Eventually arrive at one reference database, which is shared by multiple applications’ dedicated DBs TRACES Workshop Brussels

5. Current situation - without the service Create certificate Cities update (.xls) Internet Cleanup tool TRACES user - New Certificate - New Business EC Administrator New cities list Cities update (.xls) TRACES New cities list Create prevalid business Purge duplicate businesses Member State Administrator TRACES Workshop Brussels

6. Future situation – with the service Create certificate Internet XML(cities) XML(businesses) TRACES user EC Administrator New Certificate XML(cities) XML(businesses) TRACES Cities updates Business updates Valid business Member State Administrator TRACES Workshop Brussels

7. Functional Overview • Secure connection (https, SANCAS) • Different access mechanisms: • XMLGate web UI: allows for manual, file-based access • Webservices API: allows for automated access TRACES Workshop Brussels

8. Cities web service • XSD schemas available (on CIRCA) • City name, postal code, LVU, GIS coordinates • First implementation on existing prototype under “XMLGateV1” • Offline tool (Java application) created to help MSA pre-process large number of cities prior to upload • Tests with MS in February – April 2010 • April 2010: successful test of 101 cities updated in a single service call TRACES Workshop Brussels

9. Business web service • XSD schemas available (to be published on CIRCA) • Name, address, establishment type, activity codes, approval number, vehicle fleet info etc. • Implementation based on “XMLGateV2” web services access point • Offline tool not currently foreseen • CRUD operations (Create, Read, Update Delete) foreseen, as well as a Status operation to check staus of ongoing operations TRACES Workshop Brussels

10. Business web service ctd. • Status: • Obtain status / result of outstanding operations • Create: • One at a time or batch • Status response: indication of risk of duplicate, but: • The business is always created • It is the responsibility of MSA to avoid that duplicates occur • Read: • Flexible selection criteria (city, postal code…) • Status response: list of businesses • Update: • One at a time or batch • Subject to business rules • Status response: list of error codes • Delete: • One at a time or batch • Subject to business rules • Status response: list of error codes TRACES Workshop Brussels

11. Next steps • Business web service • Implement CRUD operations • Deploy in acceptance environment • Tests with pilot MS • Cities web service • Migrate to “XMLGateV2” architecture (allows return codes and data and also web service callback) • Adapt offline tool for XMLGateV2 protocol change • Integrate cities web service to framework for the business web service • Deployment in production: target Q1 2011 TRACES Workshop Brussels

12. MSA initialising the service • MSA requests to use the service • ECADM runs “SANCOClean” tool on MSA’s country, duplicate businesses are purged • ECADM provides MSA with: • purged TRACES business list • current TRACES cities list • login credentials • Creation of “prevalid” businesses in the country comes under “web services” regime (i.e. blocked) • SANCOClean tool is run once more, to purge out duplicates created while the MS connection was set up • From now on, MSA is responsible for managing its cities and businesses TRACES Workshop Brussels

13. TRACES interface • Creating a business will depend on: • Member State (“automated” or “non-automated”) • type of activity (Transporter, Bovine Holding…) • Status “Prevalid” will no longer exist for a “web service enabled” country-type combination: • A “non-automated” MSA can not create a business in an “automated” MS • An “automated” MSA can create a business in a “non-automated” MS • NB: The case of “legitimate pre-valid” businesses needs still to be addressed TRACES Workshop Brussels

14. Questions & Discussion TRACES Workshop Brussels