Building Sonus Transformation Tables…fast…very fast!!!
If you have been using Sonus Session Border Controllers (Sonus SBC’s 1000/2000) for any amount of time you probably are well aware about the amount of time transformation table entries can consume. Anywhere from few minutes for couple of transformation table entries to few hours or even days if you have got couple of 100 to create. If you have got 100’s of these transformation table entries to be copied across multiple SBC’s…well you are in for some serious fun!
Needless to say adding creating 100’s of transformation table entries manually via GUI is tedious, error prone and highly inefficient. It certainly doesn’t seem to be sort of thing you should be wasting your or your customers time in this day and age of automation, efficiency & cost cutting!
To take the pain out of building transformation table entries I have created an Excel spreadsheet – SonusSBCTransformationTableBuilder. It allows you to build Transformation table entries offline – anywhere, without access to the SBC.
You can also have base set of transformation rules ( e.g. UK, US, etc) and then re-use them in every deployment rather then manually creating them every time. You would require my SonusUX module to execute cmdlets.
Once you have downloaded the spreadsheet, make sure to read through the Instructions tab
The TransformationTableBuilder tab creates the actual transformation table entries. You enter your Input in the Red columns which will generate necessary cmdlets in the Green column.
Once you are done all you need to do is copy the generated cmdlets (from the Green column) and paste into the PowerShell session. Make sure before you paste the cmdlets you have imported the SonusUX module and established a connection to the Sonus SBC.
Other then creating new transformation table entries you can grab transformation table entries from existing SBC using get-uxtransformationtableentries cmdlet and export them. You can then import those transformation table entries back into the SBC using this spreadsheet. This is useful if you have got multiple SBC’s which need to have identical set of transformation tables entries.
Download link: The SonusSBCTransformationTableBuilder spreadsheet can be downloaded here.