Microsoft OneDrive is a file hosting and synchronization service operated by Microsoft as part of its suite of online Office services.
Objects extracted
Metadata Command Center extracts files and folders from a Microsoft OneDrive source system.
You can extract workbooks, worksheets, and columns from Microsoft Excel files.
Note: In the following scenarios, column names of delimited files are extracted as generic columns, such as Column1 and Column2:
•Column headers contain formulas.
•A file contains duplicate column headers.
•Column headers contain only numeric values.
•Column headers are blank.
Metadata Command Center extracts the following metadata from a Microsoft OneDrive source system:
•File system
•Flat field
•Flat file
•Folder
•Hierarchical file
•Hierarchical field
File types
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
Parquet
Single partition, multiple partitions, schema merge
You can extract metadata from TSV and TXT file types.
You can extract metadata from XML and XSD file formats as XML file objects. Metadata Command Center extracts only elements and attributes from XML and XSD files. If the size of the XML file exceeds 100 KB, Metadata Command Center extracts metadata from the initial 100 KB of the file. However, for XSD file types, Metadata Command Center extracts complete metadata.
You can extract metadata from the following Microsoft Excel file types: