Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Clarify db-specific implementation of date/time fields

...

More notes on data integration strategies here.

All varchar fields listed below are implemented as nvarchar in SQLServer deployments and as character varying in PostgresSQL deployments 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
nameSIS Data Mappings v2.0.0.xlsx

...