Overview

This guide explains how to configure your SFTP server so FundApps can securely pull files from it at agreed-upon times. It covers the technical requirements (connectivity, authentication, folders, and file naming) and what information you’ll need to share with us.

The SFTP setup in FundApps consists of two distinct parts:

Host configuration (set up by FundApps)
File schedules (configured by you in the FundApps user interface)

To access the configuration screen, navigate to Admin & settings > SFTP.

Host Configuration (FundApps Setup)

Currently, clients cannot edit the Host configuration directly within the platform. Please provide the following details to your Implementation Manager or CSM so we can complete the backend setup for you:

SFTP Host: Provide the DNS name or IP address.
Port: This is usually 22. If you use a non-standard port, please provide the specific number.
FundApps API User Username and Password: You must create an API User prior to setup by following this guide. Share the API User credentials via a secure channel.
Email Address: Provide the email address or addresses to receive automated notifications if an SFTP file retrieval fails.
Authentication Method: Choose one of the two supported methods:
1. Option A (Recommended): SSH public key authentication.
2. Option B: Username and password authentication. If your corporate policies require password-based login, please share the SFTP credentials via a secure channel.

Technical Notes

SFTP runs natively over SSH and is fully encrypted in transit, meaning no additional transport encryption setup is required on your side.

If your SFTP server restricts access using an IP allowlist, you will need to add the FundApps IP address displayed on the SFTP configuration screen.

File Schedules (Client Configuration)

File schedules tell the platform exactly when to check your SFTP server, where your files are located (including folder and filename patterns), which dated file to pick up, and what specific date the data should be recorded under.

Managing Your Schedules

To manage your file schedules, follow these steps:

Go to Admin & settings > SFTP.
Select File Schedules from the left-hand panel.
Click Create New Schedule to build a new routine, or click an existing schedule to open the editor.

Schedule Settings Reference

General Information

Schedule Name: Choose a clear, distinct name to differentiate your configurations (for example, positions-daily).

Schedule Details

Enabled: Toggle this on to activate the schedule. You can toggle it off to pause pickups at any time without deleting your settings.
Days of the Week: Select the specific days the schedule should run (typically Monday–Friday).
Pickup Times: Add one or more times for FundApps to look for the file. If your data occasionally arrives late, add a second pickup time later in the day to serve as an automatic retry.
Time Zone: Select the time zone the schedule must follow. The system automatically adjusts for Daylight Saving Time (DST) where relevant.

File Information

This section specifies exactly what data FundApps should retrieve from your SFTP server.

File Format: Select FundApps. If you are integrating with the BlackRock Aladdin platform, select Aladdin instead.
File Type: Select the intended purpose for this schedule. You should create separate schedules for different data types as needed. Options include:
- Positions (CSV)
- Composites BYOD (CSV)
- Transactions (CSV)
File Path Template: Input the exact folder path where your files are uploaded. Use {0} as a placeholder where the date appears in the filename.
- Example: /positionsfile/positions_2026-06-02.csv translates to /positionsfile/positions_{0}.csv.
Date Format: Specify how the date is formatted inside the filename. Examples include:
- yyyyMMdd (e.g., 20260515)
- yyyy-MM-dd (e.g., 2026-05-15)
File Name Date: Controls which dated file the system looks for on your SFTP server.
- Today: Looks for a filename containing the current date.
- Yesterday: Looks for a filename containing the previous day's date.
  - Example: If today is 15 May 2026 and Today is selected, the system looks for 20260515.csv. If Yesterday is selected, it looks for 20260514.csv.
Snapshot Date (NAV Date): Controls the date under which FundApps records the data. Selecting Today assigns the current date, while selecting Yesterday assigns the previous business day's date.
- Today: Records data under today's date.
- Yesterday: Records data under yesterday's date.
  - Example: For a file retrieved on 12 February 2026, selecting Today sets 12 February 2026 as the positions NAV Date. Selecting Yesterday sets 11 February 2026 as the position's NAV Date.