Transferring data from external data stores to BMC CMDB
You can load data from database tables of a discovery source into BMC CMDB using Atrium Integrator. This data could include inputs, such as LDAP, BMC Remedy AR Systems forms, BMC Remedy ITSM forms, and those requiring complex staging tasks or complex data manipulations. The data is imported and transformed by creating jobs in Atrium Integrator or Atrium Integrator Spoon, which is the Pentaho Spoon application. BMC provides several sample jobs that you can use as a starting point.
After you create a job you can edit the job using Atrium Integrator Spoon only. You cannot run clustered execution of transformations using Atrium Integrator Spoon.
Process Diagram
The process of transferring data to BMC CMDB is depicted with the help of the following diagram.
To transfer data from external data stores into BMC CMDB
To transfer data into BMC CMDB, follow the process outlined in the following steps.
| Step No | Task | Description |
|---|---|---|
| 1 | Configure the source and target connection. | You must define connection parameters (such as host name, port number, user name, and password) to your external data store and the CMDB. After you create a connection, you can reuse it for multiple transformations or jobs. |
| 2 | Create a job to import data | |
| 3 | Modify the job using Atrium Integrator Spoon. | You can add intermediate steps for cleaning up or manipulating your data before adding it to CMDB. Atrium Integrator Spoon provides support for JavaScript and a variety of pre-built functions. |
| 4 | Verify and run the job. | If the job completes without any errors, verify that the data has been added to the appropriate CMDB class. If the job displays error messages, debug the job and run it again. |
| 5 | Monitor the job. | After you create and run your job, you can monitor it. The Atrium Integrator console displays the job run information. |
Comments
Log in or register to comment.