SSP v2.0.0 (beta 2) Data Integration Mapping

Owned by Jason Elwood
Last updated: May 08, 2013Version comment

 

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 are implemented as nvarchar in SQLServer deployments and as character varying in PostgresSQL deployments.

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.0.0 beta2.xlsx to display the new preview. You can access the file here.