“And will you succeed? Yes indeed, yes indeed! Ninety-eight and three-quarters percent guaranteed!”
Linking keys are an important consideration for cross-referencing disparate data sets. And in OSS you have lots of disparate data sets to pull together. For example, every different NMS, EMS, BSS (and even other OSS tools) create / manage disparate data sets. Some of the greatest insights delivered by an OSS come being able to link / merge data sets.
Since the data sources are designed / created independently of each other, they often don’t have naturally occurring linking keys. This is where you can use free-fields to synthetically create linking keys.
Just one thing to check before excitedly jumping up and down at having found a way of linking data sets. The data source may allow you to create linking keys within its user interface, but if its API or data export tools don’t give access to all data objects (including free fields), then you may have difficulty accessing the linking key data.
When assessing your OSS interface, don’t forget to pay close attention to what information is exposed by the API. It is common for less than 100% (less than 98 and three quarters percent even) of data fields to be exposed, so don’t forget to check that the ones you need (eg your free-field text objects) are accessible.
PS. Thanks to David for a recent discussion that spawned this post! 🙂
PS2. Thanks to Mark for the helpful reminder that field lengths also need careful consideration (click on comments to see Mark’s notes)Read the Passionate About OSS Blog for more or Subscribe to the Passionate About OSS Blog by Email