Overview
This document describes two high-level approaches to integrating "external" data with SSP.
The contracts for the default SSP database-local views and tables are linked to as child pages from here.
Option 1: ETL
Transform and load data from arbitrary authoritative datasources into physical tables local to the SSP database. The ETL itself could be evented or batched, but at this writing is always a purely custom development effort. I.e. OOTB SSP has no support for importing flat files or other data feeds.
...
| Gliffy | ||
|---|---|---|
|
Option 2: Remote Relational
Redefine the relational views in the SSP database to query data in external datasources on a just-in-time basis.
...