by: Brandon Amick
Recently, we have been working on projects that involve integrating AutoCAD Map 3D with other products to allow for AutoCAD Map 3D to operate as a “One-Stop Shop” for not only GIS but also for asset management. With the right customization, data can travel back and forth between AutoCAD Map 3D and asset management software or other software without having to switch between interfaces to input data a second time (…or third time).
One such project involved integrating AutoCAD Map 3D with Infor Hansen to create and update assets in Hansen as they were being created and updated in AutoCAD Map 3D. There are a variety of ways to accomplish this and our project involved using the AutoCAD Map 3D API and the Hansen web services. Since this customer was using an Oracle database backend, we collected data from AutoCAD Map 3D as each job transitioned through various job states to pass along into Hansen. This allowed the customer to utilize the job states within Map 3D to help them create a stable internal workflow process. Our work resulted in allowing assets to be created in Map 3D and Hansen simultaneously without any additional effort for a seamless workflow and time saved.
Another customer called on us to aid in bringing transformer data from NorthStar Harris into the Map 3D environment for the users to view it. We worked with the SQL Server database for this customer to set up database links between the Map 3D database and the database used for Harris asset management software. This would allow the user to bring in asset management data about their electrical infrastructure using master detail records created in Infrastructure Administrator.
Additionally, we created links to other software called Savage to load the corresponding Savage URL in the user’s web browser and view the data about a transformer or meter. This was completed using the data available from the Map 3D API to construct the proper URLs. When everything was finished, the user simply had to click a button on the Map 3D form and their web browser would automatically navigate to the correct Savage URL for that transformer or meter.
As you can see there are many ways that Map 3D can be used as an all-encompassing software to handle design, GIS, and asset management data all at once. It can be as simple as adding appropriate fields to your data model in order to track the data that you need to as complex as full plugins that work within Map 3D to synchronize your data from platform to platform.