Choosing an Assertion Type for Your JDBC Connection

If you want to connect to Oracle Analytics Cloud using JDBC, you must first decide which assertion type you want to use to secure your connection: Resource Owner or JWT (JSON Web Token).

Assertion Type	Use this option when:	Considerations
(Recommended) Resource Owner	You want to connect to Oracle Analytics Cloud with a specific user name and password. You want to create a 'gateway' connection to query data from the semantic model in Oracle Analytics. Gateway accounts always use one single user name and password.	We recommend using this assertion type. It's simpler to configure.
JSON Web Token (JWT)	You don't have the password and you need to connect to Oracle Analytics Cloud as different users.	This assertion type is more complex to configure. It also allows you to impersonate any Oracle Analytics user in the system, therefore you must ensure that the keys you generate are secured appropriately.

Assertion Type

Use this option when:

Considerations

(Recommended) Resource Owner

You want to connect to Oracle Analytics Cloud with a specific user name and password.

You want to create a 'gateway' connection to query data from the semantic model in Oracle Analytics. Gateway accounts always use one single user name and password.

We recommend using this assertion type. It's simpler to configure.

JSON Web Token (JWT)

You don't have the password and you need to connect to Oracle Analytics Cloud as different users.

This assertion type is more complex to configure. It also allows you to impersonate any Oracle Analytics user in the system, therefore you must ensure that the keys you generate are secured appropriately.