Set Up Salesforce OAuth2 Credentials
- A Salesforce org where you can create a Connected App (or External Client App).
- Client ID (consumer key) and client secret from the Connected App.
- Security:
- Integration Operatorpermission
- Data Designerpermission
Create an authorized Salesforce OAuth2 credential so Adaptive Planning can connect to your Salesforce instance. New Salesforce data sources require an OAuth2 credential. Password credentials aren’t available for new data sources.
You create the credential in Adaptive Planning and complete the OAuth settings using a Salesforce Connected App or External Client App. When you select this credential on a Salesforce data source, Adaptive Planning authenticates with the Salesforce OAuth2 flow and refreshes access tokens automatically.
If you connect to a Salesforce sandbox, use the sandbox authorization and token URLs in the credential settings.
- In Adaptive Planning, select from the main menu.
- In theComponent Library, expandCredentialsand selectCreate New Credential.
- SelectOAuth 2, enter a descriptive name such as "Salesforce Production OAuth", and selectCreate.
- Copy theRedirect Uridisplayed in the credential settings. You cannot change this value after creation.
- Return to your Salesforce Connected App or External Client App and paste the Redirect Uri into theCallback URLfield. Save the Salesforce app.
- Back in Adaptive Planning, complete the OAuth 2 credential settings in Adaptive Planning:OptionDescriptionConsumer KeySalesforce consumer key (client ID)Consumer SecretSalesforce consumer secretRedirect UriAdaptive Planning populates this (already copied to Salesforce)ScopeAPI refresh token (add scopes to match your Connected App)Authorization Header RequiredClear the option unless your Salesforce configuration requires itAccess Token RenewableSelect the option. Salesforce supports refresh tokens when refresh token scope is grantedAuthorize Redirect URLProduction: https://login.salesforce.com/services/oauth2/authorizeSandbox: https://test.salesforce.com/services/oauth2/authorizeAccess Token Service Http MethodPOSTAccess Token Service EndpointProduction: https://login.salesforce.com/services/oauth2/token Sandbox: https://test.salesforce.com/services/oauth2/tokenToken Expiry Default (sec)Optional. Salesforce returns token expiry in the response; use a default such as 3600 if needed
- UnderActions, clickSave.
Select the OAuth2 credential on your Salesforce data source, then test the connection and import structure. See Steps: Set Up Salesforce Data Sources.
- If Test Connection or import fails because the session expired or was revoked, open the credential and selectRequest AuthorizationorReset Authorization, then try again.