One of our users want to create SIP Peers for an Asterisk server out of CMDB objects. SIP Peers in Asterisk are managed in a MariaDB database (https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime). For each SIP peer, an entry in the following three database tables need to be created:
A generic MariaDB plugin for Exportd can be created, which creates an entry in one or multiple database tables per CMDB object. With this generic approach we can also easy integrate a lot of other external systems, like freeradius, OTRS CMDB, or other systems.
Within an export, DATAGERRY object data should be synced with a specific database table (add missing entries to the table, update existing data, delete non existing data from the table).
A configuration can look like this:
This is also a wish from our community:
Nice to have:
We should check, if we can support other database systems with this exporter:
Implementation done for MySQL/MariaDB.
Tested with inserts into multiple tables and everything works
Merged into development
Changed the Jira Workflow from DATAGERRY -> DATAGERRY 2.0