Our integration solution seamlessly connects Blackbaud and SFTP, facilitating the efficient transfer of data from multiple Blackbaud objects to a designated SFTP folder. Streamline your data management process effortlessly with our integration solution to transfer data from multiple Blackbaud objects in CSV format, our system automates the upload to your desired SFTP folder, ensuring efficient and secure data delivery. The uploaded files will be named as Object_currentdate.
Setup Guide
This integration will pull the data from each Blackbaud object specified in the Object List parameter. The integration will then generate a CSV file for each object and send all files to the desired SFTP folder.
To run this integration and connect Blackbaud to SFTP, it is necessary to configure the parameters that are mentioned below.
Blackbaud
Token FileRequired. Select the Rest Token file from the drop-down list. Review the KB-Article mentioned here regarding how to generate the token file.Object ListRequired. This parameter accepts comma-separated values if you want to pull data from multiple Blackbaud objects, e.g. School | Course,Financial | Account etc.Batch SizeRequired. The default is set to 200.Query ParameterOptional. Multiple query parameters are separated by a new line.CompressionOptional. The default is set to True.
SFTP
Server HostRequired. Specify the name or IP address of the SFTP server.PortRequired. Specify the port number.UsernameRequired. Specify a username to access the SFTP server.PasswordRequired. Specify a password to access the SFTP server.Destination FolderRequired. Specify the path to the destination folder ending with a trailing slash.