This documentation supports the 20.02 version of BMC CMDB.

To view an earlier version, select the version from the Product version menu.

Managing data sources and datasets in BMC CMDB

A dataset is a logical grouping of data in BMC CMDB and is used to capture data from different data sources. It can represent data from a particular source, a snapshot from a particular date, and so on. You must create datasets in BMC CMDB to store data provided by different data sources. Creating datasets is the first step when importing data.

Related topics

Planning to populate BMC CMDB

Default datasets in BMC CMDB

Creating and editing a dataset

Video: Datasources Open link

Best practice

Each discovery application that you use should store the data that it discovers in a separate dataset. Data from a separate database that you import to BMC CMDB through Atrium Integrator should be stored in a separate dataset.

You can also use datasets for partitioning data. For example, you could use datasets to represent production data or obsolete data. Your datasets do not all need to contain different versions of the same CIs and relationships. For example, you could use datasets to hold:

  • Subsets of your overall data, such as departments or regions
  • Data from different companies for multitenancy
  • Test data

A dataset can contain only one instance of a given CI. An instance of that CI might also exist in other datasets to represent the CI in the contexts of those datasets. Instances representing the same CI or relationship across datasets share the same reconciliation identity, or reconciliation ID.

Each CI and relationship in BMC CMDB must reside in a dataset, meaning that they have a DatasetId attribute that must contain a value.

Overview of working with datasets

These are the high-level steps required to create datasets:

  1. Identify your data sources.
  2. Create a dataset for each data source that you have identified.
  3. Import your data source content into the relevant dataset.
The image below gives you an overview of the recommended dataset model

Task or conceptReference
Scenarios and the recommended best practicesBest practices for managing datasets
Create a dataset for a data sourceCreating and editing a dataset
Modify a datasetRestricting access to the dataset
Deleting a datasetDeleting a dataset

Know more about the existing datasets that are defined in BMC CMDB upon installation

Default datasets in BMC CMDB
Overlay datasets and how they workOverlay datasets
Set permissions to various datasets and manage themDataset permissions

Was this page helpful? Yes No Submitting... Thank you