System Requirements

• A Strategy One (June 2025) or later environment with Cross-Origin Resource Sharing (CORS) Cross-Origin Resource Sharing (CORS) is a mechanism that uses additional HTTP headers to tell a browser to let a web application running at one origin (domain) have permission to access selected resources from a server at a different origin. enabled. Strategy for Google Sheets™ uses Strategy Library. For steps, see How to Enable CORS Settings.

• The Enable Google Workspace Connectivity toggle must be enabled on the Library Admin page.

• A Strategy Library Server that uses the HTTPS protocol. You must have the appropriate certificate to use Strategy Library with HTTPS protocol.

• Strategy One Update 1 or later Intelligence Server. You must have the same version of the Intelligence Server and Strategy Library.

• Set cookies for SameSite Attributes to None in the Library Admin page:

  1. Open the Workstation window.

  2. In the Navigation pane, choose Environments.

  3. Right-click your environment and choose Properties.

  4. In the left pane, click Library.

  5. Under Cookies, in SameSite Attribute, select None.

  6. Click OK.

Supported Authentication Methods

• Standard

• LDAP

• Guest

• Identity

• Any SAML 2.0 compliant idP

• Okta (OIDC)

• Azure AD (OIDC)

Strategy for Google Sheets™ supports all authentication types configured in your environment.

Authentication Configuration

1. Establish a trusted relationship between your Library and Intelligence server to securely authenticate Google Workspace users.

   Only perform this step if you are configuring OIDC for the first time or if you use other authentication methods such as Standard without the intent to switch on OIDC. If your environment is already configured with OIDC, you may have already performed this step.

   1. Open Workstation.

   2. Right-click your environment and choose Properties.

   3. In the left pane, click Library.

   4. In Library Server, select the check box next to OIDC in Authentication Modes.

   5. Click Create Trusted Relationship.

      

   6. Enter your administrator or super user credentials and click OK.

      If you do not want to use OIDC as a login method in your environment, you can unselect the OIDC check box after you create the trusted relationship.

2. If you are using an MCE instance based environment, enable OAuth2 support:

   1. Open the WEB-INF/classes/config/configOverride.properties file.

   2. Add or update the following properties:

• auth.oauth2.server.enabled=true

• auth.oauth2.server.storage=inMemory

3. Restart Tomcat.

Supported Operating Systems

• Windows 10 and 11

• macOS Sonoma (14) and Sequoia (15)

  The current version does not support iPhones and iPads.

Supported Web Browsers

The latest versions of the following browsers are supported:

• Chrome

• Edge