Interface for automatic transfer of accounting data

From the ERP software, accounts receivable data is made available each day via an SQL database. These data, such as customer information, open claims or outstanding balances from open accounts receivable transactions, are read each day automatically, prepared for sending to a financial services provider, and transferred to a defined data format. The results of the data formatting are sent by SFTP to the financial services provider. The interface is based on SQL Server Integration Services (SSIS). The interface is implemented using SQL Server Data Tools (SQL Server Management Studio, Visual Studio).