Home > Products > G2 Data Warehouse


G2 Data Warehouse

The G2 Data Warehouse provides a snapshot of your data stored within leading back-office fund accounting systems. This product maintains an automatically refreshed copy of the investments, tax data, and performance metrics of your company’s investment portfolios. Once in the warehouse, it is easier to analyze, migrate and report on your data using standard tools such as Microsoft SQL 2005 SSRS and SSIS, and Crystal Reports.

Product Features

• Automatic updates keep your data up to date, even in the face of historical revisions and corrections.


• All data in warehouse stored in a relational database, such as SQL Server 2005.


• Support for standard objects within your back-office accounting system, as well as key performance indicators such as daily profit and loss, open tax lots, and per transaction cost details.

• Rapid Queries and Reporting
  Data is pre-processed overnight so users can perform instant queries without waiting for your fund accounting system to perform a time-consuming execution run. G2 Data Warehouse has all your tax lots, positions and P&L pre-computed.


• Load Transfer
  By transferring the overhead of handling reporting requests to a relational database, the G2 Data Warehouse allows the mission-critical accounting system’s server to run efficiently and smoothly, regardless of the number of report users.


• Reporting Flexibility
  Leverage your in-house expertise using your own reporting tools, use our catalog of standard reports, or request customized reports that match your business’ distinct and unique needs.


• Flexible Access
  Access your accounting system?s data via company intranets, MS Excel, or other custom applications.


• Data Integration
  Merge your accounting system's data with data from other sources to provide a comprehensive, one-stop repository for information.


• Additional Data Redundancy
  Data in the G2 Data Warehouse operates independently from the production accounting system's environment. This guarantees that you can continue to access your data, even if the accounting system's server is unavailable.