Orange County NC Website
Browse       Search
DocuSign Envelope ID:8D6BF819-7F7F-492F-B590-6156F7327668 <br /> Overall Architecture of Conversion: <br /> There are 3 SQL Se rver data hales involved in the conversion process. <br /> 1. EG Template M{this database houses the data from each legacy data source) <br /> 2. Mapping$Conversion Cade_DD{this database contains all conversion p—esses and mappingtables.This is maintained by Tyler's data conversion team.This db takes <br /> the data from EG_Tempate DB,translates it,and populates it into the EnerGov_DB. <br /> 3. EnerGov_DB(the production EnerGov RDBMS) <br /> EG Template 1(5QL server) !: <br /> Gmversion <br /> ►i <br /> 17 6..- --.A <br /> Progression of Conversion Process: <br /> Data conversion is an iterative process with most projects involving 3—4 complete passes leading up to final crrtover. With respect to timing and position within the overall SOW, <br /> conversion-related activities typically begin no later than Stage 4-Build/Build Specifications <br /> Data Review Ec Templ <br /> &dreept O¢ Data lead <br /> BA= s <br /> reactor Da <br /> Dan Lead Tenw le <br /> —Load <br /> M.M.v Ds TFm➢lore <br /> Data Load Data¢eview <br /> EG Template <br /> ® Dan Review <br /> Mappi�& <br /> CbnYefsYOn <br /> code Tming <br /> s• •. tyler <br /> 47 <br />