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.
- 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.
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.
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.
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.
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.
Define the relationship mapping for the CI types to be transferred.
Specify whether the source has a:
Schedule the job to run at a specific time or timed interval.
For more information, see Creating an Atrium Integrator job schedule.
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.