The Progress DataDirect Autonomous REST Connector for JDBC is a driver that supports SQL read and update access to JSON, XML, and CSV REST API data sources. To support SQL access to REST services, the driver creates a relational map of the returned data and translates SQL statements to REST API requests. The driver can either infer a map at the beginning of a session or can leverage a configuration REST file (Model file) that allows you to modify and persist a map. In addition, the driver employs a SQL engine component that provides support to SQL constructs unavailable to most REST services. This functionality offers a number of advantages, including support for reporting data and metadata in a form JDBC applications are ready to use.

Once you are ready to start accessing your data with your application, the driver requires you to complete several tasks to ensure the driver is deployed properly. The following topics help you get started acquiring a Model file and connecting to your REST service:

The documentation for the driver also includes the Progress DataDirect for JDBC Drivers Reference. The reference provides general reference information for all DataDirect drivers for JDBC, including content on troubleshooting, supported SQL escapes, and DataDirect tools.

For the complete documentation set, visit the Progress DataDirect Connectors Documentation Hub.

Note: The documentation library uses the terms the driver and the connector to refer to the Autonomous REST Connector.