Skip to main content
Home
Logo -BNY

Primary menu

  • Solutions
    • pControl Solutions
    • Asset Allocation
    • Oversight
    • Fund Processing
  • About Us
    • About Milestone Group
    • Why Milestone Group
    • Governance
    • Clients
    • Community
  • News & Resources
    • Press Releases
    • Media
    • Events
    • Whitepapers & Resources
    • Market Insights
    • Case Studies
  • Contact Us

Breadcrumb

  1. Home
  2. Solutions
  3. Data manager

Data Manager

Data Manager provides an integrated data movement, transformation and validation engine to integrate external data sources with client implemented or hosted environments, and providing connectivity to counterparties, trading networks, and third-party service providers.

Data Manager concurrently handles multiple data feeds in multiple formats, facilitating upstream and downstream systems integration as part of a single end-to-end process.  Data Manager receives, integrity checks and drives data to the pControl processes requiring it, while escalating any late or invalid data through dashboards and email notifications.

Data Manager is a foundation capability to support data integration across all Multi-Asset, Oversight and Fund Processing solutions.

Features

  • Eliminates input and output errors via direct uploads
  • Supports wide range of transports and data formats
  • Standard field validations include text, date, look-up and numeric value checks
  • Format translation and transformation allows custom client formats to be integrated

Transports Supported

  • File System. The ability to recognize when a file is in a file system directory and import the data contained within the file
  • FTP/SFTP. The ability to push and pull via an FTP/SFTP service
  • SQL Database. The ability to read and write data to and from external database tables, or call remote database stored procedures
  • Message Queue (JMS). The ability to read (event driven) or write a message on a specific subject or queue
  • e-Mail Send*. Sending an e-Mail to a recipient list / cc / bcc list with or without attachments
  • e-Mail Read*. Reading an e-Mail based on criteria, unload and processing of attachments as a file
  • Web Service. The ability to read from or write data to an external Web Service

* IMAP, SMTP & POP3 mail servers are supported.

Data Formats Supported

  • Delimited files, of any type of delimiter, including comma (CSV), pipe and tab delimited
  • Fixed width
  • XML
  • SWIFT 15022
  • SWIFT 20022
  • EMX
  • FIX (4)

For XML based formats, the data structure is read within the file and record processing is based upon the XML schema.

Exports and Report Writing

  • User configurable creation of flat files from export tables
  • Ability for columns to export from a nominated export table and also (via a query definition) which rows to export as well as the format of the resulting file
  • Generated outputs can be pushed to an external Data Warehouse or be reported via the in-built report writing engine
  • In-built report writing engine can be used to produce formatted reports based on the data stored in pControl’s export tables
  • The finished reports can be automatically FTP’d or e-Mailed as needed

Service Level Aware

Data Manager plays a critical role in ensuring pControl solutions are Service Level Aware through internal monitoring and escalation of late running events such as late data arrival, and late override / approvals and final release within operational cut-offs and processing calendars.

Operations teams can monitor Service Level compliance through the following dashboards:

  • Production Summary dashboard to deliver progress monitoring of all daily NAV calculations and NAV production activities for each processing date
  • Attention Status Monitor dashboard to provide real-time exception monitoring and aging for any activity with critical completion or Service Level Agreement deadlines

 

More from this section

Solutions with this functionality

  • Oversight NAV Oversight
  • Oversight Backup NAV
  • Asset Allocation Investment Operations
  • Fund Processing NAV / Unit Pricing
  • Fund Processing Income Control
  • Asset Allocation Fund Accounting
  • Fund Processing NAV Control
  • Asset Allocation Discretionary Portfolio Management
  • Asset Allocation Algorithmic Portfolio Management
  • Fund Processing Unitized Order Management
  • Fund Processing Income Distributions
  • Fund Processing Tax Expense

Contact Us

Country
CAPTCHA
The information provided will be used in accordance with our privacy policy.
Logo - BNY update

Secondary Menu

  • SOLUTIONS
    • pControl Solutions
    • Asset Allocation
    • Oversight
    • Fund Processing
  • ABOUT US
    • About Milestone Group
    • Why Milestone Group
    • Governance
    • Clients
    • Community
  • NEWS & RESOURCES
    • Press Releases
    • Media
    • Events
    • Whitepapers & Resources
    • Market Insights
    • Case Studies
  • CONTACT US
    • Connect with us
    • Follow Us

Tertiary Menu

  • Privacy Policy
  • Cookie Policy
  • Preferences
  • Unsubscribe
  • Sitemap

Copyright © 2025. Content on this site is the intellectual property of Milestone Group.
pControl™, pControl SmartSourcing™, pControl FairValue Control™, and NAV Protect™ are registered trademarks of Milestone Group Pty Limited.