I continue to see a lot of posts requesting database integration between Orion NPM and Orion NCM where the primary use-case is the ability to add nodes and custom properties once in NPM and have them automatically synched to NCM. We’re actively exploring centralized node/attribute management, but in the meantime, you can leverage the “Import from Orion database” job in NCM to keep your nodes and your properties in sync.
Here’s how to do it:
1. In NCM desktop application, click Schedule > Create New Job and select Import Devices from Orion Database
2. Follow the steps in the wizard to setup your sync schedule and then click on Import tab to connect to your Orion NPM database
3. Now you can map each NPM database column to an NCM field name. This is done by clicking on the column header and selecting an NCM field from the list. You can select <ignore> to bypass the column. For example, if you had a custom property in Orion NPM called Asset Tag, you would create a custom property in NCM called Asset Tag and map them using this interface.
NOTE: If you need more granular control over which nodes get added, there is a special EnableOrionImport field in NCM. If it is mapped to a custom true/false property in Orion NPM, you can control which nodes get imported from NPM using that node property.
4. Finally, you can setup node addition, merging options, and filters. I’d recommend you leave the default node import settings, which will add all new nodes and merge data about existing nodes.
That’s it. It’s a good idea to do a test run to ensure it has the expected results. You can do this by right-clicking on your newly created job and selecting Test Job.
We’d love to hear how this job is working for you (good, bad, and ugly), so please don’t be shy about posting any feedback you have to the Orion NCM forum!