Jump to content
Toggle menu
  • 131 articles
  • 373 files
  • 34 users
  • 7K edits
Voror_Wiki
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Discovery Remote Subscriber Database Familiarisation: Difference between revisions

From Voror_Wiki
 
(4 intermediate revisions by 2 users not shown)
Line 6: Line 6:
== End User Acceptance Testing ==
== End User Acceptance Testing ==
[[Remote Subscriber Database Testing and Assurance|Follow this link]] to go to the article that outlines the strategy to be used for end user testing and assurance of data published to a remote data distribution service.  
[[Remote Subscriber Database Testing and Assurance|Follow this link]] to go to the article that outlines the strategy to be used for end user testing and assurance of data published to a remote data distribution service.  
== Remote Subscriber Database User Forum ==
All organisations accessing DDS on remote subscriber database are invited to a user forum to share knowledge and learning from their experience using the product.
[https://endeavourhealth.atlassian.net/secure/RapidBoard.jspa?rapidView=43 Follow this link] to access our Extract & Queries Forum.
[[Extract & Queries Forum and Issue Logging|Follow this link]] for our user guide to our Extract & Queries Forum.


== Data Mapping ==
== Data Mapping ==
The links below take you to our schemas which list the contents and references for each table in the Compass databases.
The links below take you to our schemas which list the contents and references for each table in the Compass databases.


=== Current Schema ===
[[Compass 2.3.0 Schema Documentation]]
=== Retired Schema ===
[[Remote Subscriber Database (RSD) Schema (Compass 1)|Compass 1 Schema]]
[[Remote Subscriber Database (RSD) Schema (Compass 1)|Compass 1 Schema]]


[[Compass V2.1 Schema Documentation|Compass 2 Schema]]
[[Compass V2.1 Schema Documentation|Compass 2 Schema]]


This is an example of a schema table.
[[Compass 2.1 Schema Documentation|Compass 2.1 Schema]]
[[File:Schema table example.jpg|none|thumb|Schema table example]]
 
 
 
This is an example of a schema table. [[File:Schema table example.jpg|none|thumb|Schema table example]]


== Remote Discovery Database SQL Guides ==
== Remote Discovery Database SQL Guides ==

Latest revision as of 10:50, 19 August 2025

Overview

The purpose of this article is to assist users of the DDS Remote Subscriber Database in testing understanding and maximising the benefits of the system.

It includes testing guidance, hints and tips from developers who have experience with the system, and guidance on how to use tools share knowledge and record issues.

End User Acceptance Testing

Follow this link to go to the article that outlines the strategy to be used for end user testing and assurance of data published to a remote data distribution service.  

Data Mapping

The links below take you to our schemas which list the contents and references for each table in the Compass databases.

Current Schema

Retired Schema

Compass 1 Schema

Compass 2 Schema

Compass 2.1 Schema


This is an example of a schema table.

Schema table example

Remote Discovery Database SQL Guides

The articles below were written by our developers, who are experts with the DDS, to introduce you to how they create cohorts, build datasets and call store procedures.

Compass 1 SQL Guide

Compass 2 SQL Guide