Importing data into BMC CMDB

Populating BMC Configuration Management Database (BMC CMDB) includes activities such as importing and filtering data and verifying that each data import is successful.

See Importing data to BMC CMDB.

Importing data into BMC CMDB using Atrium Integrator

Calbro Services needs to transfer its existing data about processors, disk drives, printers, and so on to their centralized database in New York. This data resides in multiple databases, flat files, and XML files in various locations across the globe. Calbro Services wants to transfer information from its Chicago, London, Dublin, and Adelaide sites to their New York centralized database. Calbro Services also wants to transfer the personnel records of employees from the Dublin site to the New York site.

Calbro Services administrator, Allen Allbrook, prepares his CMDB for Atrium Integrator, creates and runs an Atrium Integrator job, verifies its success, and schedules it to run repeatedly.

You can use Atrium Integrator to load data from multiple external data stores into BMC CMDB. You can define how external data maps to BMC CMDB and transform external data using various rules.

With Atrium Integrator, you can schedule and perform bulk data transfers. You can also use Atrium Integrator for initial data loading, incremental data transfers, and data synchronization. For example, you can use Atrium Integrator to synchronize IT data from a discovery application with BMC CMDB, where it can be reconciled with data from other sources to your production dataset.

During data transfers, Atrium Integrator identifies the records to be transferred and performs some or all of the following tasks, depending on how you have configured your integration:

• Extract records
• Creates new records
• Updates records
• Deletes records
• Transforms data (such as concatenating fields)