Configuring the Service Graph Connector for Microsoft Excel

Configure the Service Graph Connector for Microsoft Excel to import your existing Operational Technology data from a populated Microsoft Excel flat-file spreadsheet.

Use the Service Graph Connector for Microsoft Excel Excel guided setup and complete tasks in sequence to configure the Service Graph Connector for Microsoft Excel

Navigate to All > Industrial Workspace Admin > Guided Setup, open the following guided setups, and complete the tasks.

For more information on using guided setup, see Guided Setup.

• Assign Pre-import OT Worksheet Entry Review roles
  Assign roles to the users  or user groups so that you can manage the Service Graph Connector for Microsoft Excel staging table and ETL.
• Review class mappings
  Review and update the class mappings available for the Service Graph Connector for Microsoft Excel.
• Review the system properties used by the Service Graph Connector for Microsoft Excel
  As an OT Admin or CMDB Integration Admin, view system properties related to the Service Graph Connector for Microsoft Excel.
• Add a custom field mapping in the staging table for Service Graph Connector for Microsoft Excel
  With the Service Graph Connector for Microsoft Excel, add a custom field to the staging table and map the custom field to the configuration item (CI) field.
• Add a custom implementation for device classification
  Customize the base system classification of an device based on the type, os_version, and firmware_version.
• Add a custom validation for devices
  Customize the validation for your OT devices.
• Test the Service Graph Connector for Microsoft Excel
  The troubleshooting actions can help resolve common issues when importing your Operational Technology devices or data. Access the System Log to troubleshoot for these errors.
• View script includes used by the Service Graph Connector for Microsoft Excel
  As an admin, view the script includes related to the Service Graph Connector for Microsoft Excel