Please enable JavaScript.
Coggle requires JavaScript to display documents.
BI Team (Kenny (Crimefile (Disaster Recovery (Veritas, Grampian 2 sites,…
BI Team
Kenny
ODS
tidy-up
keep up to date with changes
Pilot
Missing Persons
Custody Data
Cellfile (National Custody System)
Crimefile
Grampian
Fife
Central
Sopra Steria
1000s of nominal data
Oracle 9/1/11 not 12
Disaster Recovery
Veritas
Grampian 2 sites, 7km apart
DBA
Oracle 97%
Solaris
Timeline
Grampian constabulary 11 years
National (UK) Listpoint
Mapping to PND
SID
CHSS
Other
ANPR
Custody
iVPD
IT Connect
Trevor
IT/PA/HR Connect
BOXI Enterprise + Crystal
High/Med/Low complexity
Audit + Usage?
Forms
IT Connect Universe (ScOMIS)
ScOMIS
ScOMIS Performance Reports
Crystal 10
High/Med/Low complexity
Usage + cull?
Crystal -> BOXI/Power BI?
Timelines
FoxPro
Gartcosh
Crystal printer
Avanti printer/driver
Handover
Rob Gilmore (Application Estate)
Speeding Fines
PenTip (transport)
All Crystal Reporting
Gillian M
Timeline
2002 Ingres DBA
2013 DBA team
BOXI - Northern constabulary
5 years DBA/BOXI
National Custody
Universe/Reports
Version control for developers 'flyaway'
National SHOGUN
National INNKEEPER
IMPACT
Legacy 1995
Ingres - SSIS - ODS - BOXI
Jenna
Timeline
14 years Grampian
PC support
Application support
Grampian DataWarehouse (developed by Northgate)
BI recent years
iVPD
SRs
Reporting
Universe changes
ScOMIS migrations
Fife
Universes/Reports
Deski -> Webi
Crimefile (Charge codes on Excel)
Northern
Universes
Reports
Citations
iCAP legacy system