Skip to main content
Version IIoT Core
Hitachi Vantara Lumada and Pentaho Documentation

Query databases

  1. Last updated
  2. Save as PDF

You can query various databases like InfluxDB, CouchDB, Postgres, and MinIO using the credentials of the respective database.

Parent Topic
  • Use

    This guide describes the features of the IIoT Core Services UI and how to use them.

Child Topics

Querying InfluxDB using Passport

Passport is the proxy service used for InfluxDB. It receives requests that use Keycloak credentials and validates those credentials through OAuth Helper. It then sends the request to the appropriate database using the database credentials. This enables you to take advantage of Keycloak roles and control user access.

The external port used by InfluxDB for the Passport service is 30223. Using this port, you can also use Passport to access other supported databases like CouchDB, Postgres, and MinIO.

NotePassport does not support the use of the U and P query parameters for username and password respectively in InfluxDB queries. All authentications are done through standard basic authentication or OAuth tokens.

Before you begin

  • Create a data route using Influx data type, AMQP data source, and InfluxDB as the destination. Use NiFi to send some data to the route to ensure that the data route is working.
  • Log in to the InfluxDB UI with the following information and view the buckets and data needed for this procedure:

    URLhttps://<cluster_fqdn>:30086/
    Username and Password

    Admin username and password. See the iiot install configuration.yaml file for username and password.

Procedure

  1. Use the following code for querying InfluxDB through Passport using the REST client.

    {
    "query":"import "influxdata/influxdb/schema" schema.measurementFieldKeys(bucket: "test_db", measurement: "test_table")",
    "type":"flux"

}

  2. Change the bucket and measurement names based on your environment.

  3. Check the basic authentication credentials. Click the Basic tab and check that the admin username and password created in Keycloak are specified to use basic authentication.GUID-A26B4BCE-9C49-427D-92E8-043327325FB7-low.png

  4. Click the Query tab and check that the parameter org=hiota is specified. The organization name can be found in the InfluxDB UI.GUID-34939A4C-52F3-4EC4-8872-4915CAD51381-low.png

  5. Click Send to execute the query.GUID-FC146BF6-6EA7-452F-858A-A028082344A5-low.png

Parent Topic