Register the BIJDBC Application using JWT Assertion

You register the BIJDBC application in Oracle Cloud Infrastructure using JWT assertion to authenticate your public JDBC connections.

Before you start, generate a Client Private Key and Client Certificate File as specified in the previous step.
  1. In Oracle Cloud Infrastructure Console. navigate to Identity & Security, and click Domains.
    If your cloud account doesn't offer identity domains, you don't see the Domains link. This means your cloud account federates with Oracle Identity Cloud Service. Click Federation, select oracleidentitycloudservice, and then click the Oracle Identity Cloud Service Console URL.
  2. Navigate to the Applications tab and click Add.
  3. In the Add Application dialog, click Confidential Application.
  4. Specify a Name (for example, bi-jdbc-connection) , a Description, and then click Next.
  5. Select Configure this application as a client now.
  6. In Allowed Grant Types, click JWT Assertion.
  7. For Security:
    1. Select Trusted Client.
    2. Click Import , enter a Certificate Alias, and then upload your client certificate file.
    Add Confidential Application
  8. In the Token Issuance Policy section:
    1. Under Authorized Resources, select Specific.
      If your cloud account uses identity domains, select Add resources.
    2. Click Add Scope.
    3. Select the Oracle Analytics Cloud instance you want to connect to (for example, select AUTOANALYTICSINST_<my_instance_ID>).
    4. Click Add.
  9. Click Next and then Finish to display an Application Added window.
  10. Copy the Client ID and Client Secret to use later.
  11. Close the Application Added page.
  12. Click Activate, then click Activate Application.
  13. Click Save to display a confirmation message.