RODBA is an optional module which provides back-end access for MSDE databases and support resources for SQL Server Standard and Enterprise Editions. It is available for The Raiser's Edge 7.6 and higher and The Financial Edge 7.2 and higher and Education Edge or Blackbaud Student Information System (RODBA is available for products contained within The Financial Edge shell).

The Read-Only Database Assistance Query Tool plug-in lists the following information from a selected table: fields, indexes, primary and foreign keys, data type, and length in bytes. Use the following steps to access the query tool.

For The Raiser's Edge:
  1. Click Plug-Ins from the navigation bar.
  2. Click the Read-Only Database Assistance Query Tool link.
  3. Select the Tables tab. In the left frame, all of the tables are listed.
  4. Highlight the appropriate table and the fields appear in the right frame.

For The Financial Edge/The Education Edge:
  1. Click Plug-Ins from the navigation bar .
  2. Click the FE:Open SQL Query Tool or EE:Open SQL Query Tool link.
  3. Select the Tables tab. In the left frame, all of the tables are listed.
  4. Highlight the appropriate table and the fields appear in the right frame.
Note:
1. If your software is hosted through Blackbaud Hosting Services, please refer to: How to run a plug-in in a hosted environment?

2. For more information on RODBA, refer to What are Extended Database Assistance (EDA), RODBA, and Open?

3. In order to use RODBA, it must be first be unlocked. Please refer to How to unlock optional modules?