How to Configure NDEX for the Cloven Integration

How to Configure NDEX for the Cloven Integration

Introduction

In order to integrate NDEX with Cloven, the first step is to setup an "extract" within the NDEX interface to regularly send data to Cloven.
This article walks you through the steps involved in this process.
Notes
Note: Some of these steps may be already done for you by the NDEX or Cloven teams, and if so, feel free to skip the respective step.

Stage 1: Setting up Destination Server

The first stage in setting up extraction management from NDEX is confirming / creating the destination server. Navigate to destination server in NDEX Systems and confirm your destination server has been setup as required and is activated.

Notes
Note: If you don't see your destination server already set up, follow the following steps to set it up manually or reach out to support@bluroot.ca for assistance. If the server is already setup, then you can skip to Stage 2
1. Navigate to Destination Server module in NDEX Systems
2. Click Add to create a new destination server.
3. Fill out the following fields on the 'Add Server' Page.
Notes
Cloven / NDEX will provide the Username, Password, Port ID and Server Address.
  1. Protocol: Choose 'SFTP'
  2. English Name: Choose a name for the Server in English (ex: Cloven Financial)
  3. French Name: Choose a name for the Server in French (ex: Cloven Financial FR) 
  4. Server Address: Input the server Address (ex: 123.456.78.90)
  5. Directory: Input '.'
  6. Port: Input port for your server
  7. Username: Input the username of your server.
  8. Password: Input the password to your server.
  9. Roles: Input Roles for your server 
4.Click on save and Activate the server!

Stage 2: Setup Extraction Management in NDEX

1.Navigate to 'Extraction Management' in NDEX systems.
2.Click 'Add' to create a new extraction. 
3. Fill out the fields at the top of the extraction setup form:
  1. English Name: Name of your extraction in English (ex: Clovenfinancial-Data)
  2. French Name: Name of your extraction in French (ex: Clovenfinancial-Data_FR)
  3. File Name: Name of the file (ex: Clovenfinancial-Data_%Timestamp%) 
AlertNote: Add '_%Timestamp%' at the end of the file name.
  1. Language: Choose your preferred language from the drop-down.
  2. File Format: Choose 'CSV' as your desired file format; Choose 'Comma (,)' as delimiter.
  3. Date Format: Choose 'Default'
  4. Destination: Choose your server, Check Yes for 'Keep a copy on F-engine'
  5. Frequency: Set as 'Daily'
  6. Extract From: Choose 'All_BKS'

4. Select the Data to Include in extraction: Please check mark the following data fields from the Data types: 

Portfolio Investment

(Currency: CAD)

  • Portfolio ID (#1)

  • Client Name (#2)

Account Information

(Currency: Account Currency)

  • Account Rep ID (#3)

  • Account ID (#4)

  • Account Type (#5)

  • Account S/D Cash Balance (#6)

  • Account Book Value (#7)

  • Account Market Value (#8)

  • Account Unrealized Gain / Loss (#9)

  • Account Opening Date (#10)

Client Information

  • Client Name

  • Postal Code

  • Primary Email Address

  • Phone Number (Home)

  • Phone Number (Office)

  • Date of Birth

  • Gender

  • Language



5. Once complete, click save and activate to complete setup!