No edit summary |
No edit summary |
||
Line 13: | Line 13: | ||
* The Remote Filer application currently only supports loading data into these two database engines, and part of the data feed (for reference data) is sent as raw SQL and only these two formats are supported. | * The Remote Filer application currently only supports loading data into these two database engines, and part of the data feed (for reference data) is sent as raw SQL and only these two formats are supported. | ||
* DDS still supports data feeds to an older version of the subscriber database known as '''Compass v1''' (the current version being v2). Although v1 is still supported, new instances of this will not be deployed and this | * DDS still supports data feeds to an older version of the subscriber database known as '''Compass v1''' (the current version being v2). Although v1 is still supported, new instances of this will not be deployed and this article specifically addresses the v2 standard. Future developments/improvements to the DDS subscriber database will be iterative upgrades to v2.}} |
Revision as of 08:52, 10 June 2021
This article describes how the Discovery Data Service makes data available for Remote Subscriber Databases (RSDs) and how the DDS Remote Filer application interacts with this to update an RSD. Although it is recommended that the Remote Filer application be used for updating RSDs, any other technical solution can be substituted provided it is able to match the Remote Filer behaviour as far as the points of interaction are concerned.
Subscriber database schema
DDS currently provides SQL scripts for creating subscriber databases, one for each of the two support database engines; the database scripts are the same no matter what configuration options are selected when setting up the feed from DDS (e.g. PI versus de-identified).
- MySQL
- SQL Server (or compatible, e.g. Azure SQL DB)
Please note the following:
|