|
|
- SunGard FAME read and write capabilities from an ODBC source
- ANSI 99 SQL compliance
- Access to FAME data without requiring knowledge of FAME programming languages
- An interface to FAME databases for OLAP tools
- Object level authorisation on the FAME database
- Creation of true time-series/relational hybrid databases by running FAME and a relational database side by side to form a “logical” database
- Ability to extract FAME data and insert it into Excel and other Microsoft products
- Ease of installation
- Database administration GUI tool
Genic QueryPoint Excel Add-In Features
- Read FAME objects via QueryPoint directly into Excel
- Use expressions to perform server side calculations and return the results into Excel
- Builds an Excel query table allowing you to distribute the spreadsheet to other users to dynamically re-query
- Allows updating of FAME data directly from Excel
- Create FAME objects from Excel data with an easy to use interface
- Run QueryPoint procedures easily and directly from within Excel
QueryPoint Tools and Utilities
- ISQL utility
- A Java command line utility that interacts with the server
- SQL Macro
- A windows executable that provides the option of running the SQL scripts to the user
- Can be accessed through Tools
- Run SQL Script
|
|