Enabling the Addepar Integration

Follow

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.

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*

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

mceclip0.png

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

Click on New

mceclip1.png

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

mceclip2.png

mceclip0.png

Provider Type: StaticOAuthProvider

Name: Use Addepar OAuth  Choose the name carefully!  Once the name has been created, do not delete it and try to use the same name again.  Salesforce still retains a reference to the original name, and will have trouble authenticating with Addepar again after the change.

URL Suffix: <follow default>

Consumer Key: <This is a partner Consumer Key issued to Practifi by Addepar, to be shared across all the mutual client firms. It is stored in LastPass under "Addepar oAUTH Prod".  "Consumer Key" is Username.>

Consumer Secret: <This is a partner Consumer Secret issued to Practifi by Addepar, to be shared across all the mutual client firms. It is stored in LastPass under "Addepar oAUTH Prod".  "Consumer Secret" is Site Password.>

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

Token Endpoint URL: https://api.addepar.com

Default Scope: portfolio files

Send Access Token in Header: Ticked

mceclip1.png

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

 mceclip5.png

mceclip6.png

 

Label: Suggest Addepar OAuth Prod

Name: <follow default>

URLhttps://<client_prefix>.addepar.com  (URL provided by Addepar for the integration)

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.  This will take the user to the Addepar logon page, on which the Admin user provides their username and password.  The integration is then authenticated to get client data.

Generate Authorization Header: Ticked

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

 mceclip2.png

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

 mceclip7.png

mceclip0.png

1) Remote Site Name: AddeparAuthorize

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

Click Save.

 

2) Remote Site Name:  AddeparToken

Remote Site URLhttps://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.

mceclip9.png

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

mceclip10.png

Note: A major change in this newer integration method is the elimination of the need for ViewIDs to indicate which collection of fields should be used in the integration.  The new method uses a Query API, which specifies the fields needed, and is common to all systems.  The references to ViewIDs in the panel may be ignored. 

Supply the following:

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

Credentials *: Name of the Named Credential set up earlier , or the API Key Named Credential (see note below)

Verbose Logging: Tick only for testing

View Id: Ignore, this relates to the earlier method of integration

List View Id: Ignore, this relates to the earlier method of integration

Request Limit: 20

Timeout: 5

Enabled: Ticked

HTTP Timeout: 120000

Sync from Addepar: Ticked

API Version: v1

Annualize Days: 365 (the daily fee earnings figure is multiplied by 365)

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.

Asset Default Under Advice Status: Tick if new incoming Assets should be set as "Under Advice" when first received in an integration

Client Portfolio Type: firm

Entity Portfolio Type: entity

QueryAPI Enabled: Ticked

 

Alternate Asset Default Category Codes

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

mceclip11.png

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

mceclip12.png

Look up AddeparScheduleSync and select as the Apex Class

mceclip13.png

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

mceclip14.png

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)

mceclip15.png

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

mceclip16.png

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

mceclip17.png

Enable Data Management Tab

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

mceclip18.png

Select the Menu Items page.

 mceclip19.png

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

mceclip20.png

 

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

mceclip21.png

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

mceclip0.png

Check that these jobs are flagged as Active

mceclip1.png

mceclip2.png

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.