Introduction This document will step through all of the tables in the staging database and applies to all versions of core from 7.9.0 onwards (unless otherwise noted). All tables are in a schema called source; any other schema and tables in the staging database that ShareDo connects to will be ignored. The use of the schema name source is omitted be...

This introduces the design principles and overall structure of the schema for staged data. It will be largely agnostic to the version of core, though it will assume 7.9 as the ‘applicable from’. The data sets that can be loaded fall into two taxonomies: Relating to the Operational Data Store (aka ODS) - organisations, people, contact methods, etc. R...

There are three methods of ingesting data: Using public REST APIs: Suitable for real-time integrations or to keep two systems that are both masters of data synchronised with each other. Excel/CSV data table upload: For small volumes, where data is processed via a workflow. Bulk data loading: For large volumes, using SQL, as part of an Extract, Trans...