Data Reconciliation

Data synchronization with external systems, via connectors. Personnel data, computers and software, virtual servers, network infrastructures.

Data Reconciliation

The manual management of the information processed in the CMDB can introduce delays or inaccuracies in updating the data.

To overcome this problem it is convenient, where possible, to activate automatic connectors that contact the external systems to be synchronized, detect any misalignments between the two data sources, notify the operators of such situations and update the CMDB.

CMDBuild READY2USE includes the following standard connectors, which are normally scheduled to be run every night: Active Directory, OCS Inventory, VMware VCenter, Amazon AWS, SNMP / LLDP.

Other custom connectors have already been made for some Customers, which can be reused by making the necessary changes, if deemed useful.

Additional custom connectors can be implemented according to the specific needs of the customer.

All data synchronization connectors are implemented using the CMDBuild Advanced Connector framework.

Active Directory

It guarantees the synchronization of the personal data of the employees:

  • access to the Active Directory LDAP repository (or other LDAP implementations)
  • analysis of available data (name and surname, registration number, email, telephone number, organizational unit, status, etc.)
  • identification of any differences (new staff or with modified data)
  • updating of the CMDB (data and reports)
  • sending of emails with summary reports of the changes made on the CMDB, with links to the modified data sheets for direct control
  • night batch execution

OCS Inventory

It guarantees the synchronization of the working places (computers and software installed):

  • access to the OCS Inventory database (mySQL), which collects the information provided by the "agents" installed on the single computers connected to the company network
  • analysis of available data (hostname, serialnumber, CPU, RAM, HD, operating system, network data)
  • identification of any differences (new and modified computers)
  • inventory of the software you want to control (by defining specific "white lists" based on regular patterns and expressions) and correlation with the relative licenses
  • sending of emails with summary reports of the changes made on the CMDB, with links to the modified data sheets for direct control
  • updating of the CMDB (data and reports)
  • night batch execution

VMware VCenter

Ensures data synchronization of virtualization systems (virtual servers and physical servers that deliver resources):

  • access to VCenter data via API
  • analysis of available data (hostname, CPU, RAM, HD, operating system, network data, status, execution cluster, notes)
  • identification of any differences (new and modified servers)
  • sending of emails with summary reports of the changes made on the CMDB, with links to the modified data sheets for direct control
  • update of the CMDB (data and reports)
  • night batch execution

Amazon AWS

Ensures data synchronization of virtualization systems (virtual servers and physical servers that deliver resources):

  • access to AWS data via API AWS EC2
  • analysis of available data (instance name, type and size, operating system, network data, status, custom fields can be set)
  • identification of any differences (new and modified servers)
  • sending of emails with summary reports of the changes made on the CMDB, with links to the modified data sheets for direct control
  • night batch execution

Service SNMP/LLDP

Ensures data synchronization of the network infrastructure:

  • access to the information of each network device (switch / router) via the SNMP protocol
  • retrieval of information on devices connected to that device, collected through the LLDP protocol
  • analysis of switch and router data (hostname, description and network information) and of the list of connected devices
  • identification of any differences (new or modified network equipment and changes in the relations with the devices connected to each device)
  • sending of emails with summary reports of the changes made on the CMDB, with links to the modified data sheets for direct control
  • update of the CMDB (data and reports)
  • night batch execution