About the SFTP File System catalog source
You can use the SFTP File System catalog source to extract metadata from the SFTP File System source.
SFTP is a secure file transfer protocol that enables you to transfer files over SSH, also known as Secure Shell protocol.
Extracted metadata
You can extract specific metadata from an SFTP File System with an SFTP File System catalog source.
Metadata Command Center extracts metadata from the following objects:
- •File Systems
- •Flat Fields
- •Flat Files
- •Folders from an SFTP File System source
You can extract metadata from the following files:
- •XML File
- •XSD File
- •Attribute
- •Element
- •AVRO
- •CSV
- •JSON
- •Parquet files based on the partition structure
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 |
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
Compatible connectors
Before you configure a catalog source, you must connect to the SFTP File System source system.
Use the Advanced SFTP V2 connector to connect to the SFTP File System source system.
For information about configuring a connection, see Connections.