Set an Authentication Method for a REST Service
Configure authentication for Oracle Visual Builder Add-in for Excel when connecting to the REST service.
When you create a new catalog from a URL, you can configure the authentication method depending on the service. The add-in provides five authentication options: Default, Basic Access Authentication, Oracle Fusion Applications Token Relay, OAuth 2.0 Authorization Code (PKCE), and No Authentication.
At log in, the add-in uses this setting to determine how to log in. If required, you can change the authentication method using the Advanced tab of the Business Object Catalog Editor.
See Authentication Options for more information.
- Click Manage Catalogs.
- In the Manage Business Object Catalogs window, select your existing catalog and click the Edit Business Object Catalog icon.
- In the Business Object Catalog Editor, click Advanced.
- Select an authentication method from the Authentication list:
- Default: At login, the add-in pings an Oracle Cloud Application anti-CSRF servlet endpoint. If the ping succeeds, Token Relay is used. If the ping fails, Basic authentication is used instead.
- Basic Access Authentication: See Basic Authentication.
- Oracle Fusion Applications Token Relay: See Oracle Fusion Applications Token Relay Authentication.
- OAuth 2.0 Authorization Code (PKCE): See OAuth 2.0 Authorization Code Flow with PKCE.
- No Authentication: There is no prompt for credentials. No authentication-related headers are added to requests.
Caution:
Be sure to choose an authentication method that is compatible with your catalog. - If the authentication method includes configuration properties, the Edit Authentication Properties button is enabled. Click the button to edit those properties.