Read-Only Database Assistance (RODBA) is a service that enables external applications such as Microsoft Access or Crystal Reports to have read-only access to The Financial Edge 7 database. To enable this access, you must first unlock RODBA:
  1. Select Tools, Unlock Add-On Modules from the menu bar
  2. On the Unlock Optional Modules screen, enter your activation key and click OK
  3. The Select FE:Open Username and Password screen appears. Enter your username and password. You will use these when connecting to the database using external applications. The username defaults to FEOPEN7, but you can change this.
  4. After you enter the username and password, exit and sign out of The Financial Edge. When you reenter The Financial Edge 7, RODBA is activated. The Plug-Ins page includes the Read Only Database Assistance Query Tool, and you can view a query's SQL statement by selecting View, SQL from the menu bar.

    Read Only Database Assistance Query Tool

The Read Only Database Assistance Query Tool gives you several advanced database views within The Financial Edge 7.
    • On the SQL tab, you can write advanced queries that interact directly with the Financial Edge 7 database table structure. The Financial Edge 7 remembers the last 10 queries you write using the Read Only Database Assistance Query Tool.
    • The Plan tab shows in detail how the query gets the data from the requested data.
    • The Results tab shows the query results.
    • The Tables tab lists the tables within The Financial Edge 7 and information about the fields within each table including links and indexes.

      Tables tab

To view the RODBA tables through Microsoft Access:
  1. Open Microsoft Access
  2. Select Create a New Database, Blank Database and click OK
  3. Name the new database, save it in an appropriate location, and click Create.
  4. Select File, Get External Data, Link Tables from the menu bar.
  5. For the Files of Type option, select ODBC Databases ().

    Select Data Source screen

  6. The Select Data Source screen appears. On the Machine Data Source tab, select AFNINI_1 and click OK.

    Link Tables screen

  7. On the Link Tables screen, click Select All and then click OK.
  8. Click OK at the remainder of the prompts.
You can now create views and queries in Microsoft Access, which allows you to write queries in a visual manner as opposed to a straight written query as you would in the Read Only Database Assistance Query Tool.