Steps: Swap CCDS and Planning Data Source Credentials to Workday Credentials
For increased security and functionality, you can swap to a Workday Credential that authenticates with a JWT Bearer Grant Token for a:
- Custom Cloud Data Source (CCDS) that connects to Workday via OAuth 2 credential
- Planning Data Source (Adaptive Planningas a data source) that authenticates with username and password
Prerequisites
Prerequisites
- In Workday
- Enable Public API and create an ISU.
- Enable the security policy on the domainAdaptive PlanningAPI Access and provision a group where the new public API ISU you just created resides.
- Enable User Sync and synchronize users at least once.
- Enable theAdaptive Planningfunctional area if it isn't already set up and activate any pending security policy changes.
- InAdaptive Planning
- Give the ISU you created a permission set with Design Integrations permissions and data access.
Steps
Steps
- Create the Workday Credential inAdaptive Planning.
- Register a Workday API Client with JWT Bearer Grant.
- Swap the Credential in Planning Data Sources and CCDS.
Create the Workday Credential in Adaptive Planning
Adaptive Planning
You can associate a single Workday credential within
Adaptive Planning
with one or more Workday data sources, CCDS, or loaders.- Log in as the ISU created for your Public API earlier.
- Navigate toIntegrations>Design Integrations.
- Expand theCredentialspane in the Component library and selectCreate New Credential.
- SelectWorkday Credentialin the Credentials menu.
- Enter a unique name that helps you identify the Workday tenant and user it connects to.
- SelectCreate. VerifyClient Grant TypeusesJwt Bearer Grant.
- For Connection, selectExternaland provide theRemote Tenant ID,Remote UI URL, andRemote Rest URLof the Workday Tenant you want this credential to work with. The Remote Tenant ID, Remote UI URL, and Remote Rest URL fields are case sensitive.
Register a Workday API Client with JWT Bearer Grant
- SelectView Certificateto copy the x.509 certificate. You need this certificate to register an API client in Workday.
- Open a new browser window and log in to Workday as a user who can register API clients.
- Search for and selectRegister API Client.
- Provide aClient Namethat makes it clear this API client integrates withAdaptive Planning.
- Select Client Grant TypeJwt Bearer Grant.
- SelectCreate x509 Public Keyand paste the certificate you copied from your Workday Data Source view certificate link.
- Copy in theRedirection URIfromAdaptive Planning. Though this is a required field, JWT bearer grant will not call this URL.
- Select Access Token TypeBearer.
- Set Scope (Functional Areas) toAdaptive Planning.
- SelectOKto generate the Client ID and other details that identify your new integration client.
- Copy theClient IDso that you can paste it into your Workday credential inAdaptive Planning.
Complete the Workday Credential in
Adaptive Planning
for JWT Bearer Grant- Return to the browser window forAdaptive Planningcontaining the incomplete Workday credential.
- Enter the Workday ISU username you want associated with this credential.
- Paste the Client ID you copied from Workday.
- SelectTest Connectionin the Actions pane, and selectTest. A message indicates if the connection succeeded.
Swap the Credential in Planning Data Sources and CCDS
- Select the CCDS or Planning Data Source you want to swap credentials for.
- Select the new Workday Credential you just created.
- For CCDS, update the content of the CCDS script to retrieve the token to withai.oauth.getPlanningTokenFromWorkday()
Your data source definition won't change if you connect to the same Adaptive Planning environment regardless of the warning message "
Existing definition of data source will become invalid if the credential is changed. Do you want to continue?