Extracted metadata
You can extract specific metadata from a Microsoft SharePoint Online source system with a Microsoft SharePoint Online catalog source.
Metadata Command Center extracts the following metadata from a Microsoft SharePoint Online source system:
- •Site
- •Subsite
- •Document library
- •Folder
- •Hierarchical file
- •Flat File
- •XML File
- •XSD File
- •Attribute
- •Element
- •Hierarchical field
- •Flat field
You can extract workbooks, worksheets, and columns from Microsoft Excel files.
The following table lists the structures associated with the file types that you can extract metadata from:
File Type | Partition structure |
|---|
AVRO | Single partition, multiple partitions, schema merge |
CSV | Single partition, multiple partitions, schema merge |
JSON | Single partition, multiple partitions, schema merge |
Parquet | Single partition, multiple partitions, schema merge |
XML | Single partition, multiple partitions, schema merge |
Excel file types
You can extract metadata from the following Microsoft Excel file types:
- •Excel 97-2003 Workbook with XLS extension
- •Excel Workbook with XLSX extension
- •Excel Macro-Enabled Workbook with XLSM extension