Polaris is used for displaying site information for American Tower monitored sites pulling from an SQL database. Polaris is currently updated on a nightly sync schedule from another application called GAM, which is an asset management software tool. ATC uses GAM for everything apart from DAS. The purpose of this project was to interface between the SnmpManager and Polaris so that updates in Polaris for any Asset data are reflected in the SnmpManager. Updates in the SnmpManager were also required to be reflected in Polaris for equipment related data only as EMS will be the generator of this data going forward.

In terms of development the following summarise the main features of this project

1. Development of file retrieval and processing functionality to update the SnmpManager database with Polaris 'Asset' data.
2. Development of file generation and sftp put functionality to update the ftp location with a new file containing the SnmpManager's database values for updated Equipment data.
3. Development of an on demand file sync in the ems to retrieve files and update our database outside of the scheduled process.
4. UI development to represent the equipment data in the EMS.

For further information see requirements documenthere

All the relevant scripts can be found here