Data Warehouse

Celent will help qualify your requirements and introduce you to the vendor
Spotted a missing vendor? Use this form to alert a vendor to the Celent service
Create a vendor selection project & run comparison reports
Register to access this feature
Click to express your interest in this report
Indication of coverage against your requirements
A subscription is required to activate this feature. Contact us for more info.


The Data Warehouse from NorthPoint Financial / ACA Technology Solutions is a central data repository that is optimized to store and manage the data that Investment Managers use to run their business. It solves the age old problem of consolidating and aggregating data from multiple systems and service providers into a single, easy to use source for investment professionals to conduct business analysis and produce mission-critical reporting.

Key Features

  • Central data repository optimized for analysis and reporting
  • Provides predefined schemas for securities, transactions, positions, taxlots, prices, and reference data
  • Unique data integration tool that allows end-users to integrate data from existing systems into the data warehouse without the need for programming
  • Automatically propagates schema changes in data files into the Data Warehouse
  • Supports knowledge date, versioning of data for both "as of date" and "effective date" basis
  • Provides high performance reporting
  • Includes a standard report suite and a powerful browser for ad hoc queries and "what if" scenarios
  • Utilizes a central Calculation Engine to recalculate changes to historical data

Key Benefits

  • Provides easier and more flexible trend analysis and reporting
  • The Calculation and Data Exchange Engine guarantees consistent data for real-time and historical information
  • Ability to quickly reconstruct point-in-time data for audit and regulatory reporting
  • Quick, low risk implementation
  • Low overhead for support vs. traditional data warehouses
  • Lower overall total cost of ownership

Product/Service details

Geographic Availability
North America, North America