Purpose: Orion provides large data sets via flat files produced by an SSIS package. Referred to commonly as the Portfolio Extract, this set of .CSV files can be produced quickly, at scale, and delivered to an SFTP, PGP encrypted. This solution is both detailed and comprehensive, but does not provide customization or on-demand file generation. The files are a set output, scheduled for set delivery time.
Simple Use Case: A customer wants to archive an entire audit of Households, Accounts and Transactions, including all related details, each day by loading this data into a database within their own tech stack.
Scope and Outputs: The output of this solution includes files for Representatives (Advisors), Households, Registrations, Accounts, Assets, Transactions, Cost-Basis, Models , Systematics, and Household Billing. The files can be requested to be enabled/disabled by file type, but are not otherwise customizable. The file names are set, but include the customer’s firm ID (Database ID), the file type, and the date the files were created. The content and format of the files can be provided upon request.
Process Overview:
- Complete initial setup steps.
- Orion to generate and deliver files.
Process Steps:
- Communicate to Orion the context for and desire to use this solution for your organization. We want to help ensure this is the right solution for the requirements.
- Provide to Orion an SFTP address, username and password, and PGP public encryption key for files.
- If provided target for the files is a server or platform not directly owned by the customer, this third party must be approved by Orion including submitting to Orion an MNDA, a completed vendor risk assessment (VRA), a data protection agreement (DPA), and a release of information form (ROI).
- Provide Orion with desired run/delivery time. The files typically take less than 10 minutes to generate and deliver. The time chosen should be coordinated with Orion’s reconciliation team to ensure that the files run a safe amount of time after the average or normal time that reconciliation is completed for the customer’s database to ensure accuracy of data and to include all daily updates needed as part of morning processes.
Process Tips or Controls:
- The files contain the entity IDs for each data object (Household, Account, etc) so that the objects can be related to each other.
- Orion provides data queries with the Query App that deliver the same results as these files. These queries can be used to review an example or the file output or for troubleshooting to review the content of the files or how changes made impact the output.