SSP v2.8.0 Data Integration Mapping
The Excel spreadsheet is a template to map data required for SSP and optionally displayed throughout SSP. The template can be used to map database columns to SSP fields.
Download the template
View Usage
SSP uses the view names defined below, prefixed with "v_". These views can select data from any underlying datasource. The below examples show corresponding database tables, found in the external database schema, that the SSP views utilize by default. For those institutions that wish to utilize a linked server setup, simply modify the view selection query to select from real-time data, a data-warehouse, etc. Note that when using the views linked to sources that are not the local tables performance times for the SSP application and the corresponding API may be negatively affected.
More notes on data integration strategies here.
All varchar
fields listed below are implemented as nvarchar
in SQLServer deployments and as character varying
in PostgreSQL deployments.
All date
fields listed below are implemented as date
in both SQLServer and PostreSQL deployments. The application interprets these values in the default JVM timezone, which should typically be configured for institution-local time.
All datetime
fields are implemented as datetime
in SQLServer deployments and as timestamp without time zone
in PostgreSQL. The application interprets these values in UTC by default, but this timezone is configurable in ssp-config.properties
.
Mapping Template
Excel: spreadsheet preview is finally here!
You can now display this file as a spreadsheet, instead of a PDF. Re-upload SIS Data Mappings v2.8.0.xlsx to display the new preview. You can access the file here.