SQL Multiple Data Resource Accessor

Overview

The SQL multiple data resource accessor allows connection to a number of data service resources that expose corresponding JDBC-enabled relational databases. 

The following figure describes how architecture that this accessor is based on. The mDSR is a data service resource which uses an SQL Multiple Data Resource Accessor. Through this, it can contact a number of data service resources (DSR1, DSR2, DSR3) than can be exposed by the different data services or even by the data service of mDSR itself.

Resource Properties

The SQL multiple data resource accessor provides the following property for any data service resource which uses it:

{https://ogsadai.org.uk/namespaces/2005/10/properties}statusOfDataServices - information on the data service resources being contacted by the activities using the multiple data resource accessor. This includes whether the last attempted access to each aggregated data service resource was successful.

Class

This data resource accessor is implemented by the following Java class:

uk.org.ogsadai.dataresource.SQLMultipleDataResourceAccessor

Configuration

Any data service resource using a SQL multiple data resource accessor uses the following configuration file:

• A data resource configuration file which specifies information about the data services, data service resources and, implicitly, relational data resources managed by the data resource accessor

These files are constructed automatically by the tools we provide to deploy data service resources. However, if you are interested, a detailed description of these files can be found on this page.