Fivetran’s SFTP connector pulls files from a source folder and syncs them into your warehouse. Files.com is that source, run as a service. It receives partner files, decrypts and normalizes them, and presents clean data for the connector to load.
No credit card required · 7-day free trial · Live in minutes
Real companies. Real file flows. Real results.
Fivetran’s SFTP connector is disciplined: a folder, a file pattern, a schedule, incremental syncs by modified date. What it reads is only as good as the folder behind it. And that folder usually sits on a server somebody stood up and forgot to monitor, with every counterparty’s quirks landing raw in the sync path.
Files.com is the source folder with a whole File Orchestration Platform underneath it. Counterparties deliver into their own scoped folders, PGP decrypts on arrival, Automations enforce the names and layouts the connector’s patterns expect, and monitoring catches the upstream feed that would have synced as silence.
A governed source folder, clean inputs, and an alert when upstream goes quiet.
Fivetran’s SFTP connector pulls files from a folder and syncs them into Snowflake, BigQuery, Redshift, or Databricks. Point it at a Files.com folder and that folder becomes the source, with everything upstream of it governed.
The data Fivetran syncs starts at counterparties. Each one delivers into its own scoped folder over SFTP, FTPS, AS2, or a browser, and Automations route clean files into the folder the connector reads.
Merge mode maps file patterns to destination tables, which only works when names and layouts hold steady. Automations enforce the naming convention and TransformScript fixes the format, so the connector’s regex keeps matching no matter what the sender did.
Fivetran can decrypt PGP files itself, with keys uploaded to Fivetran. Or Files.com decrypts on arrival. Keys stay in one key manager, every counterparty’s encryption is handled in one place, and Fivetran reads plain files.
Fivetran reads by modified date and moves forward. It is not an archive. Retention policies and archive Automations keep the original files as long as compliance wants them, and clear them when it doesn’t.
A connector syncing an empty folder reports success. Delivery monitoring knows when each upstream feed is due and alerts when the window closes without files, so the missing table rows get explained before anyone queries them.
Fivetran’s setup guide is specific about what its SFTP source must do. Files.com already does all of it.
Password or key pair. For keys, Fivetran generates the public key in its setup form. Add it to the Files.com service user and the connector signs in with no shared password. Safelist Fivetran’s IPs against the endpoint if you restrict by address.
The connector takes a base folder, an include-subfolders toggle, and regex file patterns (per-table in merge mode). Give it a Files.com folder dedicated to the sync, fed by Automations, and the pattern stays trivially simple.
Fivetran does not support SFTP servers that allow only one session at a time. Files.com serves concurrent connections as a matter of course. The connector, your partners, and your team can all be on at once.
The connector infers .gz, .zip, .tar, and .bz2 compression automatically. Where a sender’s packaging is stranger than that, Files.com unzips on arrival, so the extracted files are already sitting in the folder before the connector lists it.
“Files.com's strengths are simplicity, ease of use, and the cloud connectors. We don't have to invent custom infrastructure for every partner.”
“Files.com is versatile — it can manage many different situations from a single platform. We've consolidated multiple tools onto it.”
“Files.com is robust and scales to a large enterprise. We get multiple files per minute, per second — and we're a 24/7 organization, so everything has to always be up.”
What data teams ask most when pointing Fivetran’s SFTP connector at a source.
A governed SFTP source with partner intake, decryption, normalization, and monitoring built in. The connector just reads clean files.
No credit card required • Free for 7 days • Live in minutes