What is Open-DAI

Open-DAI is a software platform that directly extracts data from legacy DBs that sit behind existing public sector applications. Under the rules defined by the data holder, Open-DAI generates a virtualised version of the database in the cloud, and exposes the transformed data as services (RESTful APIs), therefore providing data reusers (e.g., developers) with a ‘real time’ connection with the legacy data. Open-DAI is particularly useful for organisations – such as, primarily, public administrations – willing to expose their datasets as open data services.

A user-friendly Open-DAI interface will we available in September 2014!

In the meantime, have a look at our tutorials below.

Adopting Open-DAI on GoAnimate

If you are a Public Administratiom you have two options:

  1. owning an Open-DAI instance: if you have a cloud infrastructure on premise
  2. using Open-DAI from a provider that offers is as a service: such as CSI-Piemonte, one of the project partners

As you can see in the following video Open-DAI offers you many benefits for publishing your data as both Open Data or as API dedicated to specific users


Learn more about the Open-DAI components

Access to legacy databases is ensured by a data virtualisation layer (the open-source component JBoss TEIID), using VPN connections, and also allowing data transformations. Using the D2RQ platform as semantic module, Open-DAI also enables linked data exposure, with an RDF triple store coupled with a SPARQL endpoint. Geographic data are released using GeoServer, an open-source Java J2EE application designed for that purpose.

The task of publishing of data services (as RESTful APIs) is carried out by the open-source web server Apache, with WSO2 API manager, so that the existing infrastructure (including servers, storage systems and/or relational DBs) is retained. This approach is particularly suitable for the exposure of frequently changing data. As a ‘proof-of-concept’ of possible data reuses enabled by Open-DAI, several pilot services were created by the project partners.

A ‘common components’ group encompasses a set of tools which are meant to facilitate the management and monitoring activities carried out by the platform user (typically, a public administration), including features to support automatic configuration of computer systems provided through the open-source tool Puppet.

Check out the Open-DAI installation manual

Open-DAI is available as open-source software: here is its source code

Are you interested in gathering more information, as a potential adopter?

You have several options:

  • Have a look at the public deliverables of the Open-DAI project
  • Directly reach us at info@open-dai.eu
  • Let us know about your profile by filling out this small survey (so to allow us to contact you back)