Overview
This article will cover two main sections:
Resetting an environment (clear down).
Copying data from one environment to another to mirror each other.
Resetting an Environment (Clear Down)
During the implementation process with FundApps, your environment will understandably accumulate test data. Prior to going live, there may be instances where clearing this test data becomes necessary. This process allows for a cohesive and continuous data history. Clearing the environment involves deleting all generated result data from the system.
What Can Be Done During a Clear Down?
The way data is stored in our databases depends on other factors, so it is not always possible to delete specific subsets of data.
So what is dependent on what?
Portfolios Depend on Aggregation Structures
Transactions Depend on Results
If you want to clear down the aggregation structures, you will need to also clear down the portfolios, and similarly, if you want to clear down results, you will need to also clear down transactions. Other parts of the system can be cleared down without thinking about dependencies. These are:
Data Overrides
Rule Approvals
Imported Disclosures
Deleting data from a FundApps environment is a risky procedure, so we want to ensure that our client's expectations are aligned appropriately. The process can take a bit of time, but you should expect about three days before the clear-down is done. Clear-downs can also be scheduled for a future date.
Contacting Support
When contacting support to request a clear-down, please specify the following:
Environment
DateRange (i.e. whether you want all historical to be cleared or a specific range only)
What Should Be Kept (see above list)
What Should Be Removed (see above list)
FundApps will create a Task in your environment, which you will need to confirm before we can proceed. We will then contact you close to the time of the clear-down to notify you that it will be taking place so that you do not upload any files during that time. Once it has been complete, we will again confirm this in the support ticket.
Finally, we are also able to remove the open tasks in an environment, which is not the same as a clear-down. If this is more suitable for your situation, then please specify what is required instead.
Copying Environments (Staging <-> Production)
Users can copy over data from one environment to another (essentially mirroring environments) in order to test out certain FundApps features/rules.
How to Copy Environments
To create a fully mirrored environment, three components need to be replicated:
Portfolio Structure which Replicates the Aggregation Structure
Position File, which updates your holdings and;
Data Overrides
Users should clear existing portfolios from their target environments IF they contain portfolios different from the environment being copied. Otherwise, uploading a new portfolio file will simply add to any portfolios that are present in the environment. Please follow the steps below:
Export Your Portfolios: Portfolios & Entities > Download.
Export Your Positions File of the Correct NAV Date: Admin > Previous Uploads > Download the relevant file (Document with green arrow icon).
Export Your Data Overrides: Admin > Setup > Data Overrides > Export.
Once you have done this, upload each of the above three in your other environment.