Typical Workflow to Query Data Models Remotely Using JWT Assertion

If you’re querying semantic models remotely for the first time using JWT assertion as the connection method, follow this workflow. See Choosing an Assertion Type for Your JDBC Connection.

JWT Assertion

Task	Description	More Information
Register the BIJDBC application	Register the BIJDBC application to authenticate your JDBC connection.	With JWT assertion: First, generate a private key and certificate that JWT requires, see Generate the Client Private Key and Client Certificate File. Then, use JWT assertion, see Register the BIJDBC Application using JWT Assertion.
Enable refresh security tokens	Configure your BIJDBC application to refresh security tokens.	Set Up Refresh Security Token
Download the JDBC driver	Download the JDBC driver for Oracle Analytics Cloud.	Download the JDBC Driver
Connect to Oracle Analytics Cloud	Connect to Oracle Analytics Cloud remotely using JDBC. Refer to the example as a guide, see Example: Connect to a Semantic Model Remotely Using SQuirrel.	Connect to Oracle Analytics Cloud Using a JDBC URL (Using JTW Assertion)