14.3.1.3 Creating an Oracle Wallet Data Source

To create a wallet data source in the Query UI application, you must have a wallet zip file. It can be a simple wallet zip file created with Oracle utilities such as mkstore or orapki, or a wallet downloaded from Oracle Autonomous Database.

In general, wallets are obtained from the Autonomous Database. See Download Client Credentials (Wallets) for more information to download a wallet from Oracle Autonomous Database.

The following figure displays the contents of the wallet zip file:

Figure 14-19 Cloud Wallet

Cloud Wallet

Note that the tnsnames.ora file in the wallet zip file contains the wallet service alias names, and TCPS information. It does not contain the user credentials for each service.

Using this wallet zip file, you can define an RDF wallet data source in the Query UI web application by directly entering the user credentials. Optionally, you can also have the user credentials stored inside the wallet for each desired service. If you choose to store the user credentials in the wallet, then see Storing User Credentials in a Wallet for more information.

The following describes the steps to create a wallet data source:

  1. Click Wallet in Figure 14-11.
    Create Wallet Data source dialog opens as shown:

    Figure 14-20 Wallet Data Source from cloud zip

    Wallet Data Source from cloud zip
  2. Click the upload icon and select the wallet zip file.
    The zip file gets uploaded to the server.
  3. Enter the data source Name.
  4. Optionally, enter the Description.
  5. Select the required Wallet Service name.
  6. Provide the user credentials using one of the following options as it applies to you.
    • Enable Use wallet credentials if you have stored the user credentials in the wallet.
    • Otherwise, enter directly the User and Password credentials.
  7. Optionally, enter the proxy details.