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:
| Location | Scope |
|---|---|
HKEY_LOCAL_MACHINE\Software\Adaptive Insights | All users on the machine (preferred) |
HKEY_CURRENT_USER\Software\Adaptive Insights | The 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\Connections2
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.