Using the ODBC Exposure Tool

Use the ODBC Exposure tool to add a query table to the Greentree database. That table exposes queries to external applications. You can use the table to pull data into a third-party reporting, spreadsheet, or auditing tool like Microsoft Excel.

To use the ODBC Exposure tool:

1. Select System > Utilities > Query Designer > ODBC Exposure.
2. Enter a name for the query table you're creating in the Table name field.
3. Select the record on which to base the table from the Record type list.
4. Select the query view to use from the Data view list.
5. Select the query to use from the Query list.
6. Click Run.