Configure queries

The RDBMS adapter defines SQL queries—optionally using time-based placeholders—that are sent exactly as written to the ODBC driver, enabling the adapter to retrieve only the relevant data on each scan.

Queries configuration contains a list of queries to run on the data source.

Postman

To configure schedules using Postman:

1. To initialize the configuration, use the PUT method in conjunction with the http://localhost:5590/api/v1/configuration/<componentId>/Queries REST endpoint.

   Note: If you installed the adapter to listen on a non-default port, update 5590 to the port number in use.

2. Copy and paste an example configuration for schedules into the Body section.

   For sample JSONs, see the Examples section.

3. Update the example JSON parameters for your environment.

4. Select Send to push the configuration to the adapter.

EdgeCmd

To configure schedules using EdgeCmd:

5. Using a text editor, create an empty text file.

6. Copy and paste an example configuration for schedules into the file.

7. Update the example JSON parameters for your environment.

   For sample JSONs, see the Examples section.

8. Save the file. For example, ConfigureQueries.json.

9. Open a command line session. Change directory to the location of your saved file.

10. Use the following edgecmd command with the name of your JSON file. For this example, we will use ConfigureQueries.json for the saved file.

    edgecmd -port <port number> -cid <componentId> set Queries -file /.ConfigureQueries.json

For a list of other REST operations you can perform, like updating or deleting a data source configuration, see the REST URLs section.