Inserting or updating bulk records in BMC Helix CMDB

To insert or update bulk records in Atrium Integrator

1. In Atrium Integrator Spoon, open the job you created.
2. Double-click the CMDBOutput step.
3. Select Use cache.
   For jobs created through Atrium Integrator console, the Use Cache option is set by default.
   Cache for each transformation is created in the $ATRIUMINTEGRATOR_HOME$/AIcache folder.
   In Atrium Integrator server group environment, the cache is created on the the server from where you execute a job. For example, if server A is the primary server and server B is the secondary server, and if you execute the job from server B, the cache will be created on server B. If you schedule a job on a server with the cache enabled and then schedule the same job on another server within the server group, you must manually copy the cache to the second server to avoid a negative impact on the performance.
4. Select Only insert new CIs.
5. If you do not select this option, a record in CMDB is updated only if that record is changed in the source.
6. In the Update fields table, in the Update column select Y for columns you want to be always updated in CMDB.
7. In Update column if you select N that column is not considered during updates.
   CIs are updated in the CMDB only when they meet the qualification criteria.