SFTP Imports Integration

The SFTP Imports integration enables secure, automated ingestion of data files from an external SFTP server into Asset Panda Pro. After the SFTP connection is authenticated and a source folder is configured, Asset Panda continuously monitors the folder based on the scheduled time and imports supported data files into the platform.

This integration is commonly used for syncing assets, users, or related records from external SFTP systems on a scheduled basis.

Integration overview

When the SFTP Imports integration is enabled and configured, Asset Panda Pro monitors the configured source folder on the SFTP server based on the time scheduled in automation. When the automation runs, Asset Panda Pro automatically processes the file based on the defined import mapping. Successfully processed files are imported into Asset Panda records, while any errors during processing are logged for review and troubleshooting.


Prerequisites

  • Active Asset Panda subscription

  • Administrator access in Asset Panda Pro to configure the integration

  • Access to an external SFTP server

  • Authentication credentials (username/password or public key)

  • SFTP folder structure prepared for inbound files

Asset Panda Pro does not provide SFTP hosting. The SFTP server must be managed by your organization or a third-party vendor.


Best practices

  • Use a dedicated SFTP user account for Asset Panda integrations.

  • Restrict folder permissions to only required directories.

  • Validate file formats in a test environment before enabling production imports.

  • Monitor import logs regularly to ensure data accuracy.


Obtain SFTP connection details

The following SFTP connection values must be obtained from the administrator of the external SFTP server:

  • SFTP Hostname: IP address or domain of the SFTP server

  • Port: Port number used by the SFTP server (commonly 22 or as specified)

  • Username: User account on the SFTP server

  • Password: Password for the SFTP user account (optional if using key-based authentication)

  • Destination Folder: Full path to the directory from which Asset Panda will read files

If using public key authentication, download the public key from Asset Panda Pro and install it on the SFTP server before testing the connection.


Add the SFTP Imports integration

  1. Log into Asset Panda Pro with an administrator account.

  2. Navigate to Settings icon Settings > Account Management.

  3. Expand the appropriate account and module.

  4. Click Manage in the Integrations card.

  5. Select Integration Store.

  6. In the SFTP Imports tile, click Add. The Integrations in this module tab is displayed.

  7. In the SFTP Imports tile, click Configure.

  8. Enter the SFTP Hostname, Port, Username, and Password. See Obtain SFTP connection details.

Leave the Password blank if a public key is used.

  1. If your server uses key-based logins, click Download public key to install the key.

  2. Click Test and save connection.

  3. When the connection is successful, click Continue with Mapping.

  4. Define the SFTP source folder:

    1. Enter a Mapping Name to label the integration.

    2. Click Browse to open the list of folders on the connected SFTP server.

    3. Select the folder and file from which Asset Panda should read incoming files.

    4. Click Done to confirm the folder selection.

  5. Click Save. Asset Panda Pro continuously monitors the configured source folder on the SFTP server based on the time scheduled in automation.

Last updated