Morningstar Office

Morningstar Office is a data sync integration that imports portfolio data from Morningstar’s wealth management platform into RightCapital. Unlike Morningstar Advisor Workstation which generates reports on-demand, this integration synchronizes client data on a nightly basis.

Overview

Attribute	Value
Integration Type	Data Sync (Inbound)
Authentication	OAuth 2.0
Data Flow	Morningstar → RightCapital (inbound only)
Sync Schedule	Nightly automatic sync
Owner	Winston Li
Status	Sunset: 2026/02/28

Data Synced

Households

Client households are the top-level entity containing profile information:

Household ID (reference)
Name
Address, Email, Phone
Profile details (birthday, age)

Accounts (60+ Types)

Investment accounts (portfolios) linked to households:

Category	Examples
Retirement	401(k), 403(b), 457, Traditional IRA, Roth IRA, SEP IRA, SIMPLE IRA
Taxable	Individual, Joint (JTWROS), Tenants in Common, TOD
Education	529 Plan, Coverdell, UGMA/UTMA
Trust	Trust, Revocable Trust, Charitable Trust
Insurance	VA (Variable Annuity), VL/VUL

Holdings

Security positions within each account:

Field	Description
`secid`	Morningstar security ID
`symbol`	Ticker symbol
`market-value`	Current market value
`quantity`	Number of shares/units
`price`	Current price

How It Works

sequenceDiagram
    participant A as Advisor
    participant RC as RightCapital
    participant M as Morningstar Office

    A->>RC: Connect via OAuth 2.0
    RC->>M: Request authorization
    M->>A: Login & consent
    M->>RC: Authorization code
    RC->>M: Exchange for access token

    Note over RC,M: Nightly Sync Process
    RC->>M: GET /office-household/v2/profiles
    M->>RC: Household list (paginated)
    loop For each household
        RC->>M: GET /office-portfolio/v2/profiles
        M->>RC: Account list
        RC->>M: GET /office-portfolio/v2/holdings
        M->>RC: Holdings data
    end

Setup

Login to Advisor Portal
Navigate to Integrations
Select Morningstar Office
Click Connect to initiate OAuth flow
Login to Morningstar and authorize access

Nightly Sync

# Command
php artisan morningstar_office:sync

# Queue
retail-integration-morningstar-office-nightly-sync

Technical Details

Code Locations

Component	Path
Backend Integration	`retail-api/app/Integrations/MorningstarOffice/`
Connector (OAuth)	`Connector.php`
Integrator	`Integrator.php`
OAuth2 Provider	`OAuth2/Provider.php`
Models	`Models/Household.php`, `InvestmentAccount.php`, `Holding.php`
Sync Command	`app/Console/Commands/Integrations/MorningstarOffice/Sync.php`

API Endpoints

Purpose	Endpoint
List Households	`GET /office-household/v2/profiles`
List Accounts	`GET /office-portfolio/v2/profiles?householdIds={id}`
Get Holdings	`GET /office-portfolio/v2/holdings?portfolioIds={ids}`

Comparison with Morningstar Advisor Workstation

Aspect	Morningstar Office	Morningstar Advisor Workstation
Purpose	Data import	Report generation
Data Flow	Inbound (M* → RC)	Outbound (RC → M*)
Authentication	OAuth 2.0	SAML 2.0
Sync	Nightly automatic	On-demand only
Data Stored	Yes	No
Status	Sunset 2026/2/28	Active

Common Issues

OAuth Token Expired

Symptom: invalid_grant error during sync

Solution: Advisor needs to reconnect via Advisor Portal

Holdings Not Syncing

Symptom: Accounts sync but holdings are empty

Solution: Holdings are fetched in batches of 10 to avoid timeouts; check logs for errors

Morningstar Advisor Workstation - Report generation (active)
Morningstar Security Master - Security data source