Connecting to a Secure Oracle NoSQL Database Store

To connect to a secure Oracle NoSQL Database store, follow the steps below:
  1. Obtain the SSL security files (client.trust and client.security) from your store's administrator that is used by an Oracle NoSQL Database client to connect to the store. This file was generated during the installation process of your secured store. Place these files on your local hard drive.
  2. Open SQL Developer and click + in the Connections tab.
  3. Choose New Oracle NoSQL Connection.

    Figure 2-3 New Oracle NoSQL Connection

    Description of Figure 2-3 follows
    Description of "Figure 2-3 New Oracle NoSQL Connection"
  4. Enter your Connection Name, for example Oracle NoSQL Connection, and also the Username and Password that you use to log in to the Oracle NoSQL Database store.
  5. Select SSL in the Security section. Provide the paths to the client.trust and client.security files that you placed locally on your machine. Note that after configuring and starting the KVStore successfully, you can see that the security directory is created and the security files are available to use. To know more details about the security files and the installation, contact your Oracle NoSQL Database administrator. For more information about Security Configuration, see the Oracle NoSQL Database Security Guide.

    Figure 2-4 Security Installation

    Description of Figure 2-4 follows
    Description of "Figure 2-4 Security Installation"
  6. The new secured connection is now listed in the Connections tab. To view data, see the section titled Creating Oracle NoSQL Database Tables and Loading Data to the Store.

    Figure 2-5 Listed NoSQL Connection

    Description of Figure 2-5 follows
    Description of "Figure 2-5 Listed NoSQL Connection"