DX NetOps

  • 1.  Accessing Spectrum data

    Posted May 23, 2018 03:22 AM

     

    Hi All,

     

    Is there any way to allow connectivity to the Spectrum Database so third parties can access data? Also if there is a document that describes how to set this up, would be appreciated.

     

    Thanks,

    Sheethal



  • 2.  Re: Accessing Spectrum data

    Posted May 23, 2018 03:31 AM

    To what database are you referring exactly? There are several databases in Spectrum: models database, events database, reporting database.



  • 3.  Re: Accessing Spectrum data

    Posted May 23, 2018 03:39 AM

    For any database in Spectrum, how can we access data so that we can use it in third party tools.



  • 4.  Re: Accessing Spectrum data

    Broadcom Employee
    Posted May 23, 2018 08:43 AM

    Hello Sheethal, 

     

    as Catalin already posted - there are at least 2 very different databases for a CA Spectrum install. 

    Both are important - most important is the SpectroSERVER database covering the device(modeling) (socalled SSdb) - followed by the ArchiveManager database covering the event-information (socalled DDmdb). 

     

    It is recommended to do a "read" for these databases only - as the database access is vital for CA Spectrum runtime. Therefore I would suggest NOT to do any native database access - but to use the "restful" API which allows to retrieve most of all data via one common API. 

     

    The SSdb is a Berkely-DB, the DDmdb is a mysql-DB. Both databases - when accessed and "updated" could cause a full failure for the Spectrum application. Using the "restful"-API ensures the access is gracefully and most likely validated before reading/writing the data. 

     

    May you can provide more info what your target is - that would help a lot. 

     

    hth - cheers, Joerg 



  • 5.  Re: Accessing Spectrum data

    Posted May 23, 2018 09:52 AM

    Joerg,

       Since we normally recommend that customers do regular backups of these databases, couldn't these database backups be restored to a separate user accessible DB server?   These data contained in the restored databases would be somewhat delayed by the backup/restore interval, but would otherwise be a complete copy. 

     

    Isn't it true that reads and or writes to this separate database would have no impact on normal operations? 

     

    Thanks,

     

    David



  • 6.  Re: Accessing Spectrum data

    Broadcom Employee
    Posted May 25, 2018 02:07 AM

    Hi Sheetal,

     

    If you are looking for sending the alarms to a third party application then AlarmNotifier is the best way.

     

    Regards

    Sunny



  • 7.  Re: Accessing Spectrum data

    Posted May 25, 2018 04:44 AM

    There are a number of tools that ca be used to extract data out of SPECTRUM. It would first depend on what exactly you're trying to achieve. After that you can decide which is the best way of getting that data.