File Geodatabase Integration Enterprise Database of Record Script

File Geodatabase Integration Enterprise Database of Record Script to periodically update feature classes Imported Data CMMS/Work Data CCTV Data Info. Asset Planner – File Geodatabase Individual One-Offs *AS NEEDED Paste / y p o C Linked Data Background Data Media Files (CCTV)

Enterprise Database Integration Individual One-Offs *AS NEEDED, IF NEEDED Enterprise Database of Record Script to periodically update feature classes Imported Data CMMS/Work Data CCTV Data Info. Asset Planner Enterprise Database Linked Data Background Data Media Files (CCTV)

All-in-One Enterprise Database Integration Merged Enterprise Database with Info. Asset Planner Database Imported Data CMMS/Work Data CCTV Data Individual One-Offs *AS NEEDED, IF NEEDED Linked Data Background Data Media Files (CCTV)

File Geodatabase vs. Enterprise Database • Enterprise implementation would be great to keep facility types in sync and minimize database duplication, but… • Info. Asset Planner significantly alters enterprise feature classes • Users will still have to periodically run other Info. Asset Planner tools to bring model up-to-date • Typically, number of Info. Asset users is relatively small • Info. Asset Planner does not generally need to be ‘real-time’; typically more of a project based software • Info. Asset Planner needs full read-write permissions within project database. This is something IT groups generally do not support for an organization’s database of record