ODBC / JDBC Driver for FAMEEnd-to-end connectivity
  • 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
Supporting Material
Genic QueryPoint