Hello,
I am attempting to use a Lighting Management System in an ArcSDE environment and need a little bit of direction. I was thinking that I should integrate this software as a model using model builder but I am not sure. Does anyone have any experience integrating third party software into an ArcSDE environment? Thanks!
Randall,
First off thanks for replying, and you are correct I did not go into detail. I understand ArcSDE is the infrastructure, and my question was a bit unclear. Essentially, the LMS software will act as a front end application to log work orders, as well as adjusting lighting scenarios. To do a quick road map: Field person will show up to a light--log the work order using the LMS--The LMS will send this data to any number of geodatabases without creating any duplicates, or having to download/upload excel files--the geodatabase will make adjustments to the designated attributes within the shapefile(s), the problem will be fixed and then will update on the other end. This will be a bilateral system, with the LMS software having the ability to read and write to the geodatabase(s). I am just looking for examples of anyone who has successfully done this, so that I may have a road map of sorts to build off of. The solution suggested above would not work, as this software does more than function as an asset management system. I hope my explanation was a bit clearer? Thank you for your help on this!
Hi Tirrell,
I think there's a little confusion here. ArcSDE (the Enterprise Geodatabase) is a data tier concept. A model built with model builder typically takes data as an input, does something to the data, the then produces another data set as an output. It sounds like the LMS is a front end that can be used to display information and adjust lighting scenarios based on need and environmental factors. With that in mind, does the LMS provide for a way to make an ODBC connection to a 3rd party database, or does it use a built in/proprietary database? Is the LMS primarily an inventory system, or does it offer additional capabilities (I'm personally unfamiliar with the technology). If it's primarily an inventory system, have a look at this solution:
Streetlight Inventory | ArcGIS Solutions for Local Government