Completing steps

The Load step imports your data from your source files to the dataload staging forms. This step leverages Atrium Integrator jobs, which integrate source and target data stores with data transformation based on specific rules.

The DMT User or DMT Admin provides the source location and connection information that the Atrium Integrator adapter uses for the transformation process.

Data can be imported to one or more staging forms in one Load step. For example, a Load step can import company and company alias data from a Company.xlsx spreadsheet to two different staging forms.

Load step Imports your data from your source files to the staging forms:

• Loading BMC Asset Management data
• Configuring an Atrium Integrator job for a Load step
• Registering a new Atrium Integrator job for a Load step
• Registering Atrium Integrator job variables
• Configuring Data Management for LDAP or LDAPS import

When you decide to run a dataload job, the data load is automatically validated. The validation of data occurs before the data is promoted. Each Validate step represents the validation of data for one staging form.

Validate step validates staging form data

• Alias replacement during validation
• Case insensitivity correction during validation

The Promote step either automatically or manually pushes all staging form records that are valid to their respective target forms within the BMC Remedy ITSM applications, based on the option selected for each Promote step within the job. Each Promote step represents a data promotion for one staging form. You can also choose automatic or manual promotion when you configure your application preferences for all jobs. For more information, see Configuring Data Management application preferences.

Data must be validated without error before it can be promoted. All errors are captured in the Error Management console. For more information about using the Error Management console, see Managing data errors from data load jobs. If you selected the Create Only mode for the Validate step, the related Promote step only creates new records in the target forms. If you did not select the Create Only mode, the new records are created in the target forms and the existing records are updated.

• License validation during a data load job
• Propagation
• Best practice for normalizing and reconciling ITSM data loaded through Data Management

BMC Knowledge Management follows these rules when articles with multiple versions are promoted:

• If an article has multiple versions, and the newest version is in a Draft state, the article with a version that is one less than the newest version will be promoted with a Published state. All the articles with a version less than that will be promoted with a Closed state.
• If the newest version for an article is in the Published state, all the articles with a version less than the newest version will be promoted with a Closed state