This documentation supports the 22.1 version of BMC Helix CMDB, which is available only to BMC Helix customers (SaaS).

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

Copying CIs from one dataset to another

As a configuration manager you use the Copy activity to copy instances from one dataset to another. You can use this activity to create datasets such as baselines and snapshots. To copy instances from one dataset to another, you must first create a reconciliation job.

Best practice

We recommend creating an Atrium Integrator job to copy data from one dataset to another. If you want to copy identified CIs, you can also use a Merge activity.
Copy activity uses Graph API to traverse in both the directions for each connected CI to copy the data. Hence, it is a slow process compared to Merge activity or an Atrium Integrator job which does not use Graph API to copy data.

Additionally, Copy activity might create duplicate data unlike Merge activity or Atrium Integrator job.

Example

Calbro services wants to make changes to the CIs in BMC.ADDM dataset to run some tests. Instead of making changes to the production dataset directly, they want to copy the CIs to a test dataset and then run the tests. They choose to copy all those CIs in which 'Model' = $\NULL$ AND 'MarketVersion' != "1.2.3" from BMC.ADDM dataset into a new dataset.

Before you begin

To copy CIs from one dataset to another

  1. On the CMDB Portal, open Jobs > Manage Reconciliation.

    • To add the Copy activity in a new job, click Create Job. 
      See Creating a reconciliation job.

    • To add the Copy activity to an existing job, on the reconciliation dashboard, select an existing reconciliation job from All Job Run Activities and then click Edit Job.


  2. Create a Copy activity in the reconciliation job.

    1. In the Activities area, click Add activity and select Copy from the list.

    2. Enter the following information

      FieldDescription

      Name

      Type a unique name for the activity. The name must contain only those characters that the operating system of your server allows for file names. For example, on a Windows server, your job name cannot contain the following characters: \ / : * ? " < > |.

      Namespace

      Select a Namespace from the list. Only classes in the selected namespaces can participate in the activity. For more information, see Namespaces and reconciliation.

      Status

      Active - Runs the activity when the reconciliation job runs.

      Inactive - Does not run the activity when the reconciliation job runs.

      Continue on Error

      Defines whether the job continues if the activity has an error.

      Selected - The job continues to run even if an error occurs in this activity.

      Cleared - The job is terminated if an error occurs in this activity.

      Sequence

      Specify the sequence value for this activity in relation to other activities in a job. For example, if this activity has a sequence value of 2, it runs before an activity with a sequence value of 3. The sequence can be from 0 to 1000.

    3. Select Source Dataset and Target Dataset.

    4. Set the option combination for the Copy activity by using the information in the following table. 
      For possible combinations of the options available in a Copy activity, see Option combinations for Copy activity.

      OptionDescription
      Copy RelationshipsDetermines whether to restore direct relationships to instances in the target dataset. For example, when a copied CI is a member of a relationship in the source dataset, and another member of the same relationship already exists in the target dataset without the relationship, the relationship instance is copied to restore the connection between those CIs in the target dataset. The other member of that relationship is not copied.
      • By Qualifier — Copies only the relationships included in the Qualification Set.
      • Copy All — Copies relationships included in the Qualification Set, and also restore direct relationships to instances in the target dataset.
      Collision ResolutionDetermines the action when there are matching instances in the source and target databases.
      • Overwrite - Replaces the existing instance in the target dataset with the instance from the source dataset.
      • Display Error - Writes an error message to the activity log file and not copy the instance.
      Include Child CIsSelect whether to copy weak destination CIs.
      • Select - Copies only the CIs included in the Qualification Set.
      • Clear - Copies CIs included in the Qualification Set, the weak relationships, and the CIs related as destination members in the weak relationships. This option preserves composite objects.
      Identity RequiredSelect whether to copy instances with or without a reconciliation identity.
      • Select - Copies only identified instances.
      • Clear - Copies identified and unidentified instances.
    5. (Optional) In Qualification, add a qualification set to select the classes and instances to copy. 

      • Clear Use all classes and instances to restrict the Copy activity by using a qualification set.

      • Click Select qualification rulesest to select a qualification set. 

    6. In the Schedule area, select the frequency and condition to run the job.

  3. Click Save to save the reconciliation job with the Copy activity.
  4. (Optional) To run the job immediately, open the job from All Job Run Activities and click Start Job.


If there are multiple activities in a reconciliation job and you want to run a specific activity, use the Status button to make the other activities inactive.

Option combinations for Copy activity

The following table describes the behavior of the Copy activity for each combination of options. Use the table filters to specify the options that you want to set to know the result of that combination.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

Copy RelationshipsCollision ResolutionInclude Child CIsIdentity RequiredBehavior
By QualifierOverwriteNoYes

Only instances with a reconciliation identity are copied, and they replace existing instances.

Only CIs and relationships specified in Qualification are copied.

Copy AllOverwriteNoYes

Only instances with a reconciliation identity are copied.

They replace existing instances in the target dataset.

Relationships of copied CIs, where another member of the relationship exists in the target dataset, are also copied.

By QualifierDisplay ErrorNoYes

Only instances with a reconciliation identity are copied.

If they match existing instances in the target dataset, an error is written to the activity log.

Only CIs and relationships specified in Qualification are copied.

Copy AllDisplay ErrorNoYes

Only instances with a reconciliation identity are copied.

If they match existing instances in the target dataset, an error is written to the activity log.

Relationships of copied CIs, where the other member of the relationship exists in the target dataset, are also copied.

By QualifierOverwriteYesYes

Only instances with a reconciliation identity are copied.

They replace existing instances.

In addition to instances specified in Qualification, all weak relationships and CIs under them are also copied.

Copy AllOverwriteYesYes

Only instances with a reconciliation identity are copied.

They replace existing instances.

In addition to instances specified in Qualification, all weak relationships and their child CIs are also copied.

Relationships of copied CIs, where the other member of the relationship exists in the target dataset, are also copied.

By QualifierDisplay ErrorYesYes

Only instances with a reconciliation identity are copied.

If they match existing instances in the target dataset, an error is written to the activity log.

In addition to instances specified in Qualification, all weak relationships and CIs below them are also copied.

Copy AllDisplay ErrorYesYes

Only instances with a reconciliation identity are copied.

If they match existing instances in the target dataset, an error is written to the activity log.

In addition to instances specified in Qualification, all weak relationships and CIs below them are also copied.

Relationships of copied CIs, where the other member of the relationship exists in the target dataset, are also copied.

By QualifierOverwriteNoNo

Instances with and without a reconciliation identity are copied.

They replace existing instances.

Only instances specified in Qualification are copied.

Copy AllOverwriteNoNo

Instances with and without a reconciliation identity are copied.

They replace existing instances.

Relationships of copied CIs, where the other member of the relationship exists in the target dataset, are also copied.

By QualifierDisplay ErrorNoNo

Instances with and without a reconciliation identity are copied.

If they match existing instances in the target dataset, an error is written to the activity log.

Only instances specified in Qualification are copied.

Copy AllDisplay ErrorNoNo

Instances with and without a reconciliation identity are copied.

If they match existing instances in the target dataset, an error is written to the activity log.

Relationships of copied CIs, where the other member of the relationship exists in the target dataset, are also copied.

By QualifierOverwriteYesNo

Instances with and without a reconciliation identity are copied.

They replace existing instances.

In addition to instances specified in Qualification, all weak relationships and CIs below them are also copied.

Copy AllOverwriteYesNo

Instances with and without a reconciliation identity are copied.

They replace existing instances.

In addition to instances specified in Qualification, all weak relationships and CIs below them are also copied.

Relationships of copied CIs, where the other member of the relationship exists in the target dataset, are also copied.

By QualifierDisplay ErrorYesNo

Instances with and without a reconciliation identity are copied.

If they match existing instances in the target dataset, an error is written to the activity log.

In addition to instances specified in Qualification, all weak relationships and CIs below them are also copied.

Copy AllDisplay ErrorYesNo

Instances with and without a reconciliation identity are copied.

If they match existing instances in the target dataset, an error is written to the activity log.

In addition to instances specified in Qualification, all weak relationships and CIs below them are also copied.

Relationships of copied CIs, where the other member of the relationship exists in the target dataset, are also copied.



The following video (3:00) shows an example for a copy activity and the steps required to create a copy activity in a reconciliation job:


https://youtu.be/LXFAZwOeOhk

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

Comments