BMC Helix CMDB 20.x: Advanced Using REST API and Pentaho Spoon (ASP)
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 (ASP) 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 will guide students through the advanced concepts of BMC Helix CMDB. Students will develop skills in develop skills in developing custom attributes and classes, working with REST API and Pentaho Spoon custom jobs.
Major release:
BMC Helix CMDB 20.x
Recommended Prerequisites:
Good for:
Administrators
Course Delivery:
Assisted Self Paced (ASP) | 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 update option works in a transformation
-
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 Mappe steps
- Using AROutput to write to a Form instead of a CMDB Class
- Reviewing the OOTB LDAP transformation in Spoon
-
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
-
Basics of BMC Helix CMDB REST API
- Overview of the CMDB REST API
- Benefits of the CMDB REST API
- Scenario to SEARCH for CI using the CMDB 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
-
Use Cases for CMDB REST API
- Various use cases for CMDB REST API
- Create, read, update, delete CI instances