Enabling the Addepar Integration - SPA

These instructions refer to the newest and preferred way of integrating with Addepar systems.  Instructions on the previous integration method are found in Enabling the Addepar integration (pre Tempranillo)

Before You Start

Contact your Practifi Customer Success Manager and Addepar's Support team to let them know that you are planning to integrate the two systems. Addepar's Support team will provide you with a Firm ID, which you will need to enable the integration in Practifi.

Reference Currency

If your firm needs to show Asset and Holding currency figures in other than USD ensure that the Addepar portal has its firm-wide Reference Currency set to the required currency eg CAD, SGP.  Otherwise the currency figures will be shown in Practifi in USD and will not match the figures which otherwise appear in the Addepar portal for those same Assets and Holdings.

Data Field Mapping

 The following table details the mapping of values from Addepar across to Practifi Assets and Holdings.

Practifi		Addepar	Note
Client (Name)	🠜    Daily	Top Level Owner (Addepar Client Name)	Mapped through Data Management page
Asset (Description) (Revenue) (Current Value (total of Holding)) (Category) (Stage) (Under Advice)	🠜    Daily	Direct Owner (Name) (Billing Fees)	Category: Default set under Settings Stage: OWNED, or DISPOSED* Under Advice: Default set under Settings
Holding (Holding) (Classification) (Product Code) (Balance) (Unitised (Unit Value)) (Unitised (Units)) (As At) (Value) (Stage)	🠜    Daily	Position (Name) (Asset Class) (Product Code/Ticker) (Value) (Unit Price) (Units) (Valuation Date)	Value: Unit Price x Units Stage: OWNED, or DISPOSED*

* The values of OWNED or DISPOSED are set at the Asset and Holding levels when the synchronization from Addepar is processed.  When an Asset or Holding first appears, and continues to appear between synchronizations, it is marked as OWNED.  If the Asset or Holding no longer appears after a synchronization it is marked as DISPOSED.  This is done to indicate to the Advisor that the asset is no longer recorded in Addepar.  The Advisor may manually delete the Asset or Holding directly within Practifi. 

Enabling the Integration

Enabling the Addepar integration with Practifi requires setting up to seven configurations:

Configuration	Where
Auth Provider (only if OAuth 2.0 to be used)	Salesforce Settings
Named Credential	Salesforce Settings
Remote Site	Salesforce Settings
Enable Addepar Integration	Salesforce Settings
Schedule Synch Jobs	Salesforce Settings
Activate Menu Items	Practifi Settings
Ensure Rollup Jobs Active	Salesforce Settings

Create the Static Auth Provider

The former integration with Addepar used an API Key for its authentication.  This method still works.  The API Key Named Credential name can be placed here, and it will continue to access data from Addepar.  Addepar, however, prefer their customers to begin moving across to the more secure OAuth 2.0 method of authentication, which is what has been outlined here.

If you wish to keep using the API Key approach for now, ignore this step of setting up the Static Auth Provider, and resume these instructions below from Create the Named Credential.

Under OAuth 2.0 the Authentication Provider is set up between Addepar and Practifi for all Client Orgs.  It is the same reference for all Client Orgs, and is only set up once by Practifi.

Go to Salesforce Setup under the user’s avatar/picture icon in the top right

Go to the Quick Find/Search bar, search for and click on Auth. Providers

Click on New

Complete the details on the new Auth Provider panel, as follows:

Provider Type: StaticOAuthProvider

Name: Use Addepar OAuth  Choose the name of the auth provider carefully because once created, they cannot be renamed! Please refrain from deleting auth providers. Once you delete them, their metadata cannot be purged. The Salesforce default behaviour is to choose the last record which is not guaranteed and will create troubles when authenticating with Addepar again after the auth provider was deleted and a new one is created. In such an event, you have to use an advanced feature to choose which auth provider to use by developer name.

URL Suffix: <follow default>

Consumer Key: <Please contact your Practifi Account Manager to get access to your Consumer Key.>

Consumer Secret: <Please contact your Practifi Account Manager to get access to your Consumer Secret.>

Authorize Endpoint URL:  https://<client_prefix>.addepar.com/oauth2/authorize

Token Endpoint URL: https://<client_prefix>.addepar.com/api/public/oauth2/token

Default Scope: portfolio files

Send Access Token in Header: Ticked

Create the Named Credential

Named Credentials are set up individually within each Client Org.

The method which is presently supported is the use of a URL, issued by Addepar, specific to each Client.  This would be in the form of:

https://<client_prefix>.addepar.com

To complete creating the Named Credential the Client must supply the names of an admin user in Addepar.

In Salesforce Setup, go to the Quick Find/Search bar, search for and click on Named Credentials

Click on New Named Credential

 

Label: Suggest Addepar OAuth Prod

Name: <follow default>

URL: https://<client_prefix>.addepar.com/api/v1

Identity Type: Named Principal

Authentication Protocol*: OAuth 2.0

Authentication Provider*: Addepar OAuth (per the StaticAuthProvider set up above)

Scope: portfolio files

Start Authentication on Save: Ticked.  Upon clicking Save this will take the user to the Addepar logon page, on which the Admin user (an Admin user within Addepar) logs in with their username and password.  The integration is then authenticated to link the two systems.  The Authentication Status field changes to Authenticated.

Generate Authorization Header: Ticked

* The Authentication Protocol and Authentication Provider will be different if the API Key approach is used. 

 

Create the Remote Sites

Set up three (3) Addepar remote site settings. 

In Salesforce Setup, go to the Quick Find/Search bar, search for and click on Remote Site Settings

Repeat the steps below for each Remote Site. 

Click on New Remote Site

 

1) Remote Site Name: AddeparAuthorize

Remote Site URL: https://<client_prefix>.addepar.com

Click Save.

2) Remote Site Name:  AddeparToken

Remote Site URL: https://api.addepar.com 

Click Save.

3) Remote Site Name:  AddeparID

Remote Site URL: https://id.addepar.com

Click Save.

Activate Addepar Integration

In Salesforce Setup, go to the Quick Find/Search bar, search for and click on Custom Settings.

Click Manage next to Addepar Integration Settings.

Click Edit. Complete the fields as per the screenshot below, then click Save.

Supply the following: 

Annualize Days: 365 (the daily fee earnings figure for the assets in Addepar is multiplied by 365)

Asset Default Category: Managed funds is the default if this setting is left blank.  This is the Asset Category name the Asset will receive when it is first received in an integration.  Note this spelling and case must be exactly the same as that defined in the list of Default Asset Categories (see Alternate Default Asset Category Codes instructions, below)

Asset Default Category: “Managed Fund” is code PHTASMANFUND.  This is also the default if this setting is left blank.  This is the Asset Category the Asset will receive when first received in an integration.

Credentials: Name of the Named Credential set up earlier.

Enabled: Ticked

External Id Asset Liability: cloupra__External_Number__c

External Id Holding: cloupra__External_Id__c

Firm Id: Addepar will allocate a Firm id for its clients

Is Test Env: Unticked.  Only tick if performing tests with Addepar, as the integration will use a different (Addepar described) URL path

Request Per Batch: 2   The number of Addepar Async Job requests per Apex batch

Time Between Batch: 5  The time in minutes between each Apex batch job

Portfolio Per Request: Number of Client Portfolios requested per Batch.  Default is 10.

Verbose Logging: Unticked.  Only tick if performing tests with Addepar.

Alternate Asset Default Category Codes

The codes available for use as the Asset Default Category can be found under Settings > Categories > Portfolio Holding Category

Named Credential Choice

* The former integration with Addepar used an API Key for its authentication.  This method still works.  The API Key Named Credential name can be placed here, and it will continue to access data from Addepar.  Addepar, however, prefer their customers to begin moving across to the more secure OAuth 2.0 method of authentication, which is what has been outlined here.

Schedule Synch Job

The importing of Addepar Assets, Holding, and Annualized Revenue figures takes place once a day, at the end of the processing day for Addepar.  Bear in mind that Addepar is located in the USA, so the time-of-day chosen should be in the off-work hours.

Go to the Quick Find/Search bar, search for and click on Apex Classes

Click on Schedule Apex

Look up AddeparScheduleSync and select the Apex Class.

Apply the required schedule, bearing in mind the end-of-day completion jobs on the Addepar system

Click Save

Enabling Sidebar Menu Item

Add Picklist Entry

Go to the Quick Find/Search bar, search for and click on Picklist Value Sets

Click on Menu Item Tabs (not Edit)

Check if the word addepar is not there.  If not, click on New

Add the word addepar, lower case, to the field, and click Save

Enable Data Management Tab

Addepar requires a panel on the Data Management tab to appear, for the mapping of Addepar Portfolios to Practifi Clients.

Select the Menu Items page.

 

Switch to Sidebar and filter to datamanagement context.  Click +Add

Complete the new row as follows

• Applies to: Organization
• Context: datamanagement
• Code: SBDATAADDEPAR
• Label: Addepar
• Tab: addepar
• Icon: rss
• Header Page: datamanagement_header
• Order: 19.00 (TBA)
• Sidebar?: Ticked
• Disaply Options > Navigation > Specify Pages:: Selected
• View Page: datamanagement_addeparportfolio_list
• Default: Unticked
• Active: Ticked

Click Save

Enable Addepar Portfolio Assets Tab

Remain on Sidebar and filter to client context.  Click +Add

Complete the new row as follows

• Applies to: Organization
• Context: client
• Code: SBADDPORTF
• Label: Addepar Portfolio
• Tab: addepar
• Icon: bank
• Header Page: client_header
• Order: 25.00 (TBA)
• Sidebar?: Ticked
• Display Options >Navigation > Specify Subtabs: Selected
• Default: Unticked
• Active: Ticked
• Exclude from Tear Sheet?: Unticked

Subtabs  +Add

Subtab One:

• Applies to: Organization
• Code: STAPORTFOLIO
• Label: Addepar Portfolio
• Subtab: assets
• Order: 1.00 (TBA)
• View Page: client_portfolio_list
• Active: Ticked
• Default: Ticked
• Sidebar?: Ticked
• Exclude from Tear Sheet?: Unticked

Subtab Two:

• Applies to: Organization
• Code: STALINKEDSERV
• Label: Linked Service
• Subtab: Service
• Order: 2.00 (TBA)
• View Page: linkservice_basics_view
• Active: Ticked
• Default: Unticked
• Sidebar?: Ticked
• Exclude from Tear Sheet?: Unticked

Some customers prefer to turn off the standard Assets & Liabilities tab, and simply use the above Addepar Portfolio tab.  To do this, for the code SBCLIASSETIABASSTLIBLTY untick the Active checkbox, and Save

Ensure Rollup Jobs Active

Ensure that the rollup jobs are Active

1. Holding Balance to Asset
2. Addepar Portfolio Revenue to Client

In Salesforce, under All Tabs > Lookup Rollup Summaries

Check that these jobs are flagged as Active