This documentation applies to the 8.1 version of BMC Atrium Core, which is in "End of Version Support." You will not be able to leave comments.

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.

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.

  • 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 custom relationships.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments

  1. Andrew Hicox

    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 custom relationships.

     

    This link is simply a link back to this page.

    Dec 08, 2014 11:37
    1. Prachi Kalyani

      Hello Andrew,

      Thank you for bringing this to our notice. I have fixed the link.

      Thanks,

      Prachi

      Dec 08, 2014 10:50