For adding data sources via SFTP, can I only upload one file at a time?

Correct. SFTP only works with a single file at a time. Connecting to an existing database using JDBC or ODBC will allow Panoply to grab all the data in the database without multiple file uploads.