Batch Processing
Overview
For many firms, sending data through secured FTP (SFTP) is a reliable, lighter-weight option compared to API development. Through Batch Processing via SFTP, firms can send data stored in structured files directly from their institution to Wealth Access on a nightly basis. Once configured, your data will be updated daily and ready to use without the need for manual work.
Each Batch Processing integration is unique and will require a point-of-contact who is knowledgeable of both the data available from the source system and the rules around the data. Wealth Access can accommodate a flexible implementation of this transfer – accepting either push or pull transfers for the exchange.
The Wealth Access Implementation and Product teams will consult and guide your business and technical teams in selecting and creating the file record types and formats that accomplish your business’ needs. This includes determining file structure, naming conventions, identifying unique client identifiers, and data mapping exercises.
Real World Solutions
Batch files provide a great option for integrating data that does not need to be updated in real time or that is stored in proprietary data warehouses.
Our client AMG National Trust has seen benefit in using batch processing to integrate their FIS IBS bank data through an automated nightly process that exports the required data from FIS and transfers it to Wealth Access using SFTP. Another client, Merit Financial Advisors, uses a similar process to integrate account data from their custom data warehouse.
By automating batch file transfers, these firms ensured clients had a reliable and updated view of all their data and saved valuable resources by eliminating the need for complex API development.
How to Get Started
Wealth Access offers a basic standard data format template that drives the minimum data requirements for the Wealth Access portal. Preferred format includes pipe-delimited, daily full refresh files. Please note, the layouts provided are minimum requirements and additional data points or file records may be required for your institution as determined by your firm’s business needs and/or based upon the data and format of data available from the designated integration source.
Batch file integrations will require effort from your firm and the Wealth Access development team to implement. We ask that you please allow approximately 4-6 weeks for development following completion of agreed upon data specifications and validation efforts.
Process Overview
- Establish SFTP connection between your firm and Wealth Access – If pushing data to Wealth Access, a member of the Wealth Access team will provide you with SFTP credentials for data delivery.
- Consult with the Wealth Access team to determine appropriate file records and file formats for the integration.
- Create and configure chosen file records for batch processing.
- Determine and flag appropriate data for delivery to Wealth Access in daily files.
- Engage Wealth Access team to initiate test delivery and processing of test files once Wealth Access build of agreed upon integration is complete.
- Create nightly job for generation and transfer of daily batch files to Wealth Access.
- Validate data within the Wealth Access portal.
Standard Data Templates