Loading Foundation data in bulk
BMC Helix Platform enables the administrators to load Foundation data in bulk. Bulk data loading is the process of copying the Foundation data sets from Microsoft Excel spreadsheets and loading the data sets to BMC Helix Platform. This capability makes the Foundation data available to the consuming applications and ensures onboarding of users in the organization.
To load the Foundation data in bulk, BMC Helix Platform provides a Data Management Console application.
For more information about Foundation data, see Creating-or-modifying-Foundation-data.
List of Foundation data that can be loaded in bulk
You can load the following Foundation data in bulk by using template spreadsheets:
- Cities
- Location
- Organization
- Categorization
- People data
- Support group
- Direct or indirect Foundation associations
Process for loading Foundation data in bulk
The following table describes the details of each of the tasks involved in this process:
Task | Description | Reference |
|---|---|---|
1 | Download and use the Excel spreadsheets provided by BMC Helix Platform to enter the Foundation data. | |
2 | Update the downloaded Excel spreadsheets with relevant Foundation data. You must update the spreadsheets in a specific format so that your Foundation data is validated for further processing. | |
3 | Upload the updated Excel spreadsheets to BMC Helix Platform so that the Foundation data is available for processing. | |
4 | Run the data load job to process and load the Foundation data from the Excel spreadsheets to BMC Helix Platform. |
Related topics
Foundation-data-library-and-data-model