This documentation supports the 9.1 to 9.1 Service Pack 3 version and its patches of BMC Atrium Core. The documentation for version 9.1.04 and its patches is available here.

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 Atrium CMDB.

Using the wizard has the following benefits:

  • You need to specify only the business names for the information types to be transferred to BMC Atrium CMDB. The wizard automatically selects the Common Data Model (CDM) classes and relationships based on the information entered.
  • The wizard has built-in templates that specify typical integrations based on BMC experience in populating the CMDB.

To quickly understand about data integration, watch the following video:

Note

  • The best-practice templates are installed as part of the BMC Atrium 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 Atrium 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.
  • The wizard adheres to best practices for populating data, such as auto populating categorizations and name fields for relationships.
  • When multiple CI and relationship classes are selected, data transfers are sequentially ordered.
  • Processing of delta records is simplified.

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

This section describes the high-level steps for creating a job to transfer data from an external data store to BMC Atrium CMDB using the Integration Job Builder wizard.

Recommendations

BMC recommends that you use the Integration Job Builder wizard to automatically generate a job and transformations from best practice templates. This will improve your productivity by providing a starting point for developing and simplifying the transformation of data into BMC Atrium CMDB.

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

 

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 Managing a 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 job summary.

Note

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. For more information, see Creating relationships between CIs.

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

Comments