Typical Workflow to Query Data Models Remotely Using Resource Owner Assertion
If you’re querying semantic models remotely for the first time using Resource Owner assertion as the connection method, follow this workflow. See Choosing an Assertion Type for Your JDBC Connection.
Resource Owner Assertion
| Task | Description | More Information |
|---|---|---|
|
Collect connection details for bijdbc.properties |
Determine various property values for the bijdbc.properties file that you'll use to connect to Oracle Analytics Cloud. |
Collecting Details That You Need for the bijdbc.properties File |
|
Download the JDBC driver |
Download the JDBC driver for Oracle Analytics Cloud. |
|
|
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 (with Resource Owner Assertiion) |