The Progress® DataDirect® for ODBC™ for Aha!™ driver (Aha! driver) supports SQL read-only access for ODBC applications to Aha!. To support SQL access to Aha! services, the driver creates a relational map of the Aha! data model and translates SQL statements to Aha! REST API requests. In addition, the driver employs a SQL engine component that provides support to SQL constructs unavailable to Aha! services. This functionality offers a number of advantages, including support for reporting data and metadata in a form that ODBC applications are ready to use.

For an overview of the relational tables exposed by the driver and their corresponding API calls, see Introduction to the Aha! data model.

The documentation for the driver also includes the Progress DataDirect for ODBC Drivers Reference. The reference provides general reference information for all DataDirect drivers for ODBC, including content on troubleshooting and supported functions. For the complete documentation set, visit the Progress DataDirect Connectors Documentation Hub.