Deploy Tenants via Registry

Push OfficeConnect tenant configuration to user machines using the Windows registry.
🔧 IT Admin This is an IT Admin task. It requires access to Windows group policy, deployment scripts, or software distribution tools (e.g., SCCM, Intune).

Instead of having each user manually enter tenant details, you can deploy tenant configuration directly to the Windows registry. This is the recommended approach for organizations with many users.

Registry locations

Choose one:

LocationScope
HKEY_LOCAL_MACHINE\Software\Adaptive InsightsAll users on the machine (preferred)
HKEY_CURRENT_USER\Software\Adaptive InsightsThe current user only

Configuration file format

Create an XML configuration file with your tenant details:

<connections>
  <connection name="Adaptive Planning - Production">
    <Type>adaptiveplanning</Type>
    <WorkdayAuthorizationUrl>https://example.myworkday.com/prodtenant/authorize</WorkdayAuthorizationUrl>
    <WorkdayRestApiUrl>https://example.myworkday.com/ccx/api/v1/prodtenant</WorkdayRestApiUrl>
    <WorkdayClientId>YOUR_CLIENT_ID_HERE</WorkdayClientId>
  </connection>
  <connection name="Adaptive Planning - Sandbox">
    <Type>adaptiveplanning</Type>
    <WorkdayAuthorizationUrl>https://example.myworkday.com/sandboxtenant/authorize</WorkdayAuthorizationUrl>
    <WorkdayRestApiUrl>https://example.myworkday.com/ccx/api/v1/sandboxtenant</WorkdayRestApiUrl>
    <WorkdayClientId>YOUR_SANDBOX_CLIENT_ID_HERE</WorkdayClientId>
  </connection>
</connections>

For Workday Financial Management (Financials) connections, use <Type>financials</Type>.

Deployment steps

1
Add the registry key In the desired registry hive, create the key: Software\Adaptive Insights\Connections
2
Deploy using your preferred method

Add the XML configuration using any standard deployment method:

  • Group Policy — create a GPO that writes the registry key on login
  • PowerShell script — push via Intune or SCCM
  • Registry .reg file — import on each machine

Example PowerShell snippet:

$regPath = "HKLM:\Software\Adaptive Insights\Connections"
New-Item -Path $regPath -Force
Set-ItemProperty -Path $regPath -Name "Config" -Value (Get-Content connections.xml -Raw)
3
Verify on a test machine Open Excel on a test machine. Click Log In in the OfficeConnect tab. Your deployed tenant names should appear in the sign-in drop-down without the user needing to enter any details.

Note on authentication URLs

Authorization URLs and API endpoint URLs vary based on your Workday data center location. Get the exact URLs from your Workday Security Administrator or from the OfficeConnect API client in Workday.