State Historic Preservation Office
Web Technology: ASP.NET
, Extract, Transform, Load (ETL)
, XML Web Services
GIS Technology: Esri ArcGIS ModelBuilder
, Esri ArcGIS Server
, Esri ArcPy
, Esri ArcGIS Desktop
Database Technology: Esri ArcSDE
, Microsoft SQL Server
In the past, SHPO and AZSITE data had to be accessed through the two separate data entry and maintenance systems. The need to develop and program a method to facilitate data sharing between the SHPO and the AZSITE systems emerged in response to calls to make the overall management of cultural data more efficient.
An automated Extract, Transform, Load process was created to synchronize data between the two enterprise databases. We used Oracle Heterogenous Services and SQL Server SSIS packages to perform the ETL and move the data into the a common, AZSITE Database warehouse. Users can now query SHPO data through the AZSITE system and view dynamically generated web reports to review data originating from both systems.