This documentation supports the 19.02 version of BMC Atrium Core.

To view the latest version, select the version from the Product version menu.

Creating a job through the Integration Job Builder wizard

You can use the Integration Job Builder wizard in the Atrium Integrator console to create a simple job for transferring data from XML files, CSV files, or databases (IBM DB2, Microsoft SQL Server, MySQL, Oracle, and Sybase) to BMC CMDB. The wizard has built-in templates that specify typical integrations based on BMC experience in populating the CMDB.

You must specify the business names for the information types to be transferred to BMC CMDB. The wizard automatically selects the Common Data Model (CDM) classes and relationships based on the information entered.

Notes

  • The best-practice templates are installed as part of the BMC CMDB installation and not the Atrium Integrator server installation. If the templates are not displayed in the Integration Job Builder wizard, you must verify that they have been successfully installed on the BMC CMDB server that you have specified as the target source. To verify, check the NGIE:BSM template.
  • When creating an Atrium Integrator job using Job Builder wizard, make sure that the job name does not contain a space before and after the special character.
    For example, test & delta is not considered as a valid job name.

High-level steps for creating a job through the Integration Job Builder wizard

BMC recommends that you use the Integration Job Builder wizard to automatically generate a job and transformations from the best practice templates. This improves your productivity by providing a starting point for developing and simplifying the transformation of data into BMC CMDB. If you want to import CIs that are not included in the best practice templates, you must create a relationship between the CIs before creating a job.


Step no

Task

Description

1

Specify source and target details.

You must specify the job name and description, external data store, and the CMDB class and DatasetID to which you want to transfer data. For more information, see Specifying source and target details.

2

Select CI types to transfer.

Select the CI types that you want to transfer from the external data store. You can either select CIs from a list, or select CIs based on a template. For more information, see Selecting CI types to transfer.

3

Select the relationships to transfer for the CI types.

Based on the CI types that you want to transfer, the Integration Job Builder wizard displays the relationships between the CI types. Select the relationships that you want to transfer. For more information, see Selecting relationships to transfer for the CI types.

4

Map target attributes to source columns.

Map the target attributes of the CI to the columns in the external data store. For more information, see Mapping target attributes to source columns.

5

Define the relationship mapping for the CI types to be transferred.

Specify whether the source has a:

  • Direct association between parent and child classes
    This option creates a mapping for a relationship class based on attributes in the CI classes (parent-child) that are members of this relationship.
  • Separate table to define relationships
    This option creates a mapping for a relationship class based on relationship data stored in the external data store.
    For more information, see Defining relationship mapping for the CI types to transfer.

6

Schedule the job to run at a specific time or timed interval.

For more information, see Creating an Atrium Integrator job schedule.

7

View the job summary

Verify the job name, and the CI types and relationships that you are transferring. For more information, see Viewing the Atrium Integrator job summary.

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

Comments