Set Up Direct Database Access

If your firm subscribes to the Flex Cloud offering, or if you have a license to use Vantagepoint Intelligence, you can establish a secure, read-only connection to your Vantagepoint transaction database, using ODBC. Use this approach to connect tools such as Microsoft Excel, Microsoft Access, or the Business Intelligence Development Studio directly to your database.

For more information on databases that support an ODBC connection, see the ODBC Environment Permissions topic.

To set up direct database access:

  1. Create ODBC accounts for your users.
  2. Install and configure the ODBC driver.
  3. Connect the Vantagepoint database and the application that supports ODBC connectivity.