Data Integration Project Guide

This guide will go over the end-to-end phases for a ByAllAccounts Data Integration Service project to efficiently and cost-effectively expand your data distribution network by onboarding you to the ByAllAccounts aggregation platform as a data provider.

📘

Helpful Context

We recommend reviewing Data Integration 101 to familiarize yourself with the service and ByAllAccounts Data Integration Offerings to learn about the types of data integration we support.

✍️

Pre-requisites

Before you can get started with development and gain access to more detailed data integration documentation, you will need to:

Project Phases

1. Project Sizing

The ByAllAccounts implementation team captures high-level requirements about the integration to determine appropriate size (small, medium, large, custom), and delivers pricing and project estimates. You can find the various factors that go into determining the right data integration solution for your needs on the ByAllAccounts Data Integration Offerings page.

2. Statement of Work Presented and Signed

The Statement of Work (SOW) documents the scope of the project, timelines, and technical requirements. Once the document is agreed upon and signed, the project is queued up for delivery with the ByAllAccounts engineering team.

3. Discovery and Project Set-Up

An implementation team from ByAllAccounts including a project manager is assigned to your project. A kick-off meeting is held to share and review the collaborative project plan (using Asana) with milestone dates and team responsibilities, confirm project resources, and establish meeting cadences. SFTP connectivity is established.

4. Requirements

Data transmission timing is confirmed, operational processes including authorizations are documented, and data mapping requirements are developed (custom files) and tested. Coordination with client and ByAllAccounts to address any requirement questions or gaps.

5. Development

The ByAllAccounts engineers begin developing the integration (API or Files) based off the requirements gathered. Regression testing is performed, and coordination with the client project team occurs if any requirement or development gaps are identified.

6. Data Validation

The ByAllAccounts implementation team reviews the production (or production-like) data based on delivered frequency. This is a comprehensive confirmation of key data elements (i.e., codes, account types, holding types, positions, transaction types, transaction detail, and delivery window). A summary of validation tests and findings are delivered to the client.

7. Go-Live

Client confirms implementation results are satisfactory, and the new data integration is made available for use.

8. Ongoing Maintenance Review

As a new data recipient (firm and/or advisor) is onboarded and leveraging the data feed, the ByAllAccounts team conducts another round of quality assurance testing to improve data quality.

9. (Optional) Co-Marketing Opportunities

As a partner with ByAllAccounts, we have co-marketing guidelines that we can review with you post implementation.