SFTP Connection

Files can be delivered to the Brinta platform over SFTP. The same delivery contract applies to every client, reporting form, and country.

Values in {CURLY_BRACES} are placeholders. The Brinta team provides the actual values for each integration.

Prerequisites

SFTP credentials: host, port, username, and password, delivered separately through a secure link.
Datasource key(s): the root folder name for each file type.
File format specification: columns, encoding, and delimiter for each datasource.

🚧
Credential handling
Do not share SFTP credentials over email or chat. If credentials are exposed, contact Brinta support to rotate them.

Path structure

Brinta resolves the datasource, reporting period, and company from the file path:

/{DATASOURCE_KEY}/{YYYYMMDD_YYYYMMDD}/[{COMPANY_EXTERNAL_ID}/]{FILE}.csv

Level	Segment	Description	Required
1	`{DATASOURCE_KEY}`	Datasource (file type) identifier. Provided by Brinta.	Yes
2	`{YYYYMMDD_YYYYMMDD}`	Reporting period start and end date, in `YYYYMMDD` format. Example: `20250701_20250731`.	Yes
3	`{COMPANY_EXTERNAL_ID}`	Company external ID.	Only when reporting multiple companies
4	`{FILE}.csv`	File to process.	Yes

Multiple companies

One folder per company under the period folder:

/
└── {DATASOURCE_KEY}/
    └── {YYYYMMDD_YYYYMMDD}/
        ├── {COMPANY_EXTERNAL_ID_1}/
        │   ├── file1.csv
        │   ├── file2.csv
        │   └── file_1000.csv
        └── {COMPANY_EXTERNAL_ID_2}/
            └── file_a1.csv

Single company

Files go directly under the period folder, with no company level:

/
└── {DATASOURCE_KEY}/
    └── {YYYYMMDD_YYYYMMDD}/
        ├── file1.csv
        ├── file2.csv
        └── file_1000.csv

File requirements

Property	Requirement
Format	CSV, matching the agreed specification for the datasource (columns, delimiter).
Encoding	UTF-8, unless a different encoding has been agreed with Brinta.
Size	Split into files of approximately 150 MB each.

📘
Validate before scaling
Run the connection test before sending large volumes of data.

Connection test

Run this test before sending production files.

Create the test path using the period 20250701_20250731:

# Single company
/{DATASOURCE_KEY}/20250701_20250731/TEST.csv

# Multiple companies
/{DATASOURCE_KEY}/20250701_20250731/{COMPANY_EXTERNAL_ID}/TEST.csv

Upload a TEST.csv file with minimal content, for example:
```
SFTP connection test - Brinta
```
Notify Brinta support to confirm receipt.

Once receipt is confirmed, production files can be delivered using the same path structure.