The Progress DataDirect Autonomous REST Connector for JDBC is a driver that supports SQL read-only access to JSON-based REST API data sources. To support SQL access to REST services, the driver creates a relational map of the returned JSON 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 that allows you to modify and persist a map.

The use of the Autonomous REST Connector allows Corticon to present REST services as if they are relational databases. You map a Corticon vocabulary to a REST service as if you are mapping to a database. The only difference is in the configuration of the data source. Internally, the Autonomous REST Connector stores data in an in-memory database which Corticon accesses with SQL queries - the same as it does for database data sources.

This sample introduces the Autonomous REST Connector to retrieve reimbursement rates for medical procedure codes from a REST service. A procedure may have more than one rate where each rate has its range of effective dates.

To use REST services:

  1. Add a REST data source to your vocabulary - Specify a REST URL, and then provide authentication credentials, and specify any parameters.
  2. Map your vocabulary to a REST Datasource - In the Corticon vocabulary editor, map the entities, attributes, and associations that transform data retrieved from the REST Datasource.
  3. Add the REST Service callout to a Ruleflow - In the Corticon Ruleflow editor, when you add a Service Call-out to a Ruleflow, you configure it to use the REST Datasource and identify the queries to be performed by selecting whether to do specific or bulk reads.

When all steps are completed you are ready to deploy your Ruleflow or test it in the Corticon tester. You can use multiple REST Services in a Ruleflow.

The following topics walk through the REST Connectivity sample. You are encouraged to follow along in Corticon Studio. After this sample has completed, advance to the Mixed Connectivity sample where relational database and REST Datasources work together seamlessly.