icon_CloudMgmt icon_DollarSign icon_Globe icon_ITAuto icon_ITOps icon_ITSMgmt icon_Mainframe icon_MyIT icon_Ribbon icon_Star icon_User icon_Users icon_VideoPlay icon_Workload icon_caution icon_close s-chevronLeft s-chevronRight s-chevronThinRight s-chevronThinRight s-chevronThinLeft s-chevronThinLeft s-trophy s-chevronDown

BMC Helix CMDB 20.x: Advanced Using REST API and Pentaho Spoon

BMC Helix CMDB provides a complete, accurate, and up-to-date view of the people, technologies, and services that make up your business and IT environments.

The BMC Helix CMDB 20.x: Advanced Using REST API and Pentaho Spoon course teaches students about CMDB REST API, how to use the syntax and schemes for the CMDB REST API, how to write custom and complex Pentaho Spoon Jobs, and other functions such as importing and exporting Spoon jobs. This three-day course is focused on learning advanced concepts of BMC Helix CMDB.

This course combines classroom instruction with laboratory exercises to guide students through the advanced concepts of BMC Helix CMDB. Students will develop skills in working with REST API and Pentaho Spoon custom jobs.

Major release:

BMC Helix CMDB 20.x

Good for:


Course Delivery:

Instructor-Led Training (ILT) | 24 hours

Course Modules

  • Introduction to Spoon
    • Overview of REST API
    • Role of the Pentaho Spoon in CMDB
    • Spoon steps that are supported by BMC Software
    • Spoon installation
    • View OOTB BMC jobs and transformations
  • Creating Transformations in Spoon
    • Creating a basic CSV import transformation in Spoon
    • Adding data to the stream with constants
    • Selecting the correct CMDB CI class to import into
    • Reviewing CMDB classes and their underlying AR System forms
    • Configuring a CMDBOutput step
    • Importing data from an XML file and from an MS SQL Server Database table
  • Exporting Data from CMDB
    • Exporting data from CMDB to a CSV file in Spoon
    • Adding CMDBInput and Text file output steps to a transformation
    • Using CMDBLookup to find related CIs
    • Exporting related CIs from different classes to a single CSV file
  • Atrium Integrator Transformations
    • BMC best practice to create jobs in Atrium Integrator (AI)
    • Folder structure of AI-created jobs and transformations
    • Logging in Spoon jobs and transformations
    • Detailed look at Text file input and CMDBOutput steps
    • Using CMDBLookup to create correct relationships in CMDB
    • Investigating how the Delta
  • Spoon and Foundation Data
    • Spoon’s role in loading ITSM Foundation data
    • Structure of the spreadsheets used in DMT and OnBoarding Wizard
    • Microsoft Excel input and Value Mapper steps
    • Using AROutput to write to a Form instead of a CMDB Class
    • Reviewing
  • Overview of the REST API
    • Concept of the REST API
    • General principles for using the REST API
    • Supported resources/operations and status codes
    • Various examples of using the REST API
  • Syntax and Schemes for the CMDB REST API
    • General principles for using the REST API
    • Access and authentication for the REST API
    • Versioning scheme for the REST API
    • End Points in REST API
    • Pagination schemes for REST API responses
    • Troubleshooting steps for the REST API
  • Using the CMDB Swagger UI
    • Introduction to CMDB Swagger UI
    • The process of authenticating and accessing the CMDB REST API
    • The process of consume CMDB REST API