1. Administrator's Guide
  2. Tools and Utilities
  3. Using Plugins and Extensions for Development
  4. About IntelliJ Plugin
  5. Connecting to Oracle NoSQL Database from IntelliJ

Connecting to Oracle NoSQL Database from IntelliJ

Learn how to connect your NoSQL project to Oracle NoSQL Database KVStore using the IntelliJ plugin.

Prerequisites:
To create a successful connection to your Oracle NoSQL Database KVStore, ensure that:
  • The KVStore is deployed and running.
  • The Oracle NoSQL Database Proxy is started. See Configuring the Proxy. Starting the release 19.5, Proxy is bundled along with the Oracle NoSQL Database download package.
Perform the following steps:
  1. Open your NoSQL project in IntelliJ.
  2. Click the wrench icon in the Schema Explorer window to open the Settings dialog for the plugin.
  3. Expand Tools > Oracle NoSQL in the Settings Explorer, and click Connections.
  4. Select Onprem from the drop-down menu for the connection type.
  5. Enter values for the following connection parameters, and click OK.

    Table 5-5 Connection Parameters

    Parameter Description
    Proxy URL http://<proxy_host>:<proxy_http_port> or https://<proxy_host>:<proxy_http_port> where:
    • http or https indicates the store security. For a secure KVStore, the proxy URL begins with https.
    • proxy_host is the host name of the machine to host the proxy service. This should match the host you configured earlier.
    See Configuring the Proxy.
    SDK Path Complete path to the directory where you extracted the Oracle NoSQL Java SDK. For example, D:\oracle-nosql-java-sdk-5.2.11
    Security Select SSL for secure KVStores. In case, you are creating connection to a non-secure KVStore, select None. The default value is SSL.

    Note:

    In case of secure KVStores, the proxy URL must begin with https.
    Username User name to connect to the secure store. This value is required only if you select SSL for the Security parameter.
    Password Password to connect to the secure store. This value is required only if you select SSL for the Security parameter.
    TrustStore Browse to the location where the certificate trust file is placed. See Using the Proxy in a secure data store.
  6. The Intellij plugin connects your project to the Oracle NoSQL Database KVStore and displays its schema in the Schema Explorer window.
After you successfully connect your project to your Oracle NoSQL Database KVStore, you can manage the tables and data in your schema.