If you are looking for a solution to get your data from DST FANMail into Advent Axys then our NüWorkflow solution could be an option for you. If you are looking to import FAN Mail files into another portfolio management system, then contact us and we will see if we can help you.
FANMail to SQL
Data aggregation is useful to have because it eliminates manual data entry. NüWorkflow supports downloading files from the DST FANMail data aggregation service provider.
NüWorkflow has pre-built workflows that download your files from the DST FANMail webportal and will load the files to a SQL database. It’s possible to schedule the workflow to run automatically daily or it can be run manually. For example:
Once the files are in a SQL database, it’s easy to extract the data to another system. For Advent Axys, we have another pre-built workflow that will load prices into your pri files and transactions into your cli files via the trade blotter. For example, here is a workflow that creates the last business day’s price file based on trade date and settle date holdings, imports prices from FANMail, and then grabs some additional prices from Yahoo:
This particular workflow solution emails the resulting comma delimited CSV file to one of our clients. Normally we deploy NüWorkflow in your environment, so it will be completely automated.
For systems other than Advent Axys, please contact us and we will work with you to see if automation is possible.
Click here to read more about how NüWorkflow could help automate other processes in your firm.