| |
Home > Products > G2 Data Warehouse
G2 Data Warehouse
Trade data is the core of your business. You need easy access and control for analysis, migration and reporting. G2 Data Warehouse delivers all this and more.
An advanced data storage system for portfolio accounting data, G2 Data Warehouse provides a snapshot of your data stored within leading back-office hedge fund accounting systems. G2 Data Warehouse maintains an automatically refreshed copy of the investments, tax data, and performance metrics of your company's investment portfolios. Once in the warehouse, your trade data is easy to analyze and migrate to either standard software programs or custom applications. That means you have control over which programs access this data. The data is also easy to report on using standard tools, such as Microsoft SQL 2005 SSRS and SSIS, and Crystal Reports. G2 Data Warehouse helps you maintain an up-to-date profile of your trade data so you can make informed and timely investment decisions.
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.
Product Benefits
- 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.
For more information, review the detailed fact sheet for G2 Data Warehouse.
Back to top |
Tax Management
