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.
Partner and vendor feeds land the same way whichever storage the warehouse reads: a drop point per sender, and every file in your own bucket the moment it arrives.
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.
Fivetran connects to Files.com through its standard SFTP connector: host, port, and a credential. Files.com is the SFTP server, a managed endpoint with a permanent hostname and host key. Authentication works with a password or with the public key Fivetran generates during setup, added to the Files.com service user.
Fivetran’s SFTP connector handles CSV and TSV with configurable delimiters, JSON and JSONL, XML, and Excel workbooks, plus compressed files: .gz, .zip, .tar, and .bz2 are inferred automatically. Files.com holds whatever partners deliver and stages the supported shapes for the sync.
Magic folder mode syncs recently modified files from a folder tree into your destination. Merge mode maps file patterns to specific destination tables, including regex capture groups that name the table. Both modes read the same Files.com folder. The choice is about how the warehouse side gets organized.
Fivetran can decrypt, or Files.com can. Fivetran decrypts when you upload the private key to Fivetran and senders follow its naming rules. Or Files.com decrypts on arrival, keeping every key in one key manager and handing the connector plain files: one decryption policy for all your counterparties instead of one per pipeline.
Yes. Files.com meets every requirement in Fivetran’s setup guide — including the one that disqualifies many homegrown servers. Fivetran does not support servers that allow only one session at a time. Files.com serves concurrent sessions, holds a permanent host key, and provides static addresses for safelisting in both directions.
Files.com controls what lands in the folder Fivetran reads. Each counterparty gets its own credential and folder, and what arrives gets validated and normalized before it routes to the sync folder. One sloppy sender never breaks the pipeline for everyone else.
The Fivetran sync succeeds at loading nothing, which is worse than failing. Delivery monitoring defines when each feed is due and alerts when that window closes without files: a same-hour alert instead of a puzzled analyst.
Yes. Files.com archive Automations copy each file to a dated folder under retention policies you set, so the original survives as long as compliance requires even after the pipeline has moved on.
Yes. Files.com runs SOC 2 Type II, encrypts in transit and at rest, and offers a pre-approved HIPAA business associate agreement with Files.com Enterprise. Every access lands in the audit log, including every file Fivetran read, and when.
Files.com replaces the bare SFTP server somebody stood up to be Fivetran’s source, plus the missing pieces around it: partner onboarding, decryption, validation, monitoring, and the archive. The connector keeps working exactly as before. Everything upstream of it stops being homemade.
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