Multiple data sources

How to scope data with multiple sources in openfunds

The issue

Fund data from fund houses can be hosted independently at locations in different countries. This could lead to problems, e.g., when two locations send the same data records having different values to the same data recipient. The data which first reaches the recipient will be deleted by the second data record. The graphic below illustrates an example in which two locations send two spreadsheets to a data recipient, whereby the data in grey is provided by both sources. Although A has the data ownership, these data are deleted by B, since B has sent the data to the recipient after A did.

Graphic multiple sources

Solution

This problem can be solved by the fact that the fund house knows which source has data ownership. It can thus prevent the fields from the data ownership possessor from being deleted. There are three possibilities in openfunds to ensure this:

  • Complementary Data
  • OFST999999
  • [IGNORE] command

Complementary Data

The first possibility to solve this problem is to send complementary data. That means, what A sends, B does not and vice versa. If this possibility cannot be implemented, one of the other two options should be chosen.

OFST999999

OFST999999 replaces the previously sent OF-ID and tells the recipient to ignore the values in it. E.g., if B has technical reasons to send the same data records like “OFST005010 Umbrella” as A, B can transmit such data using the field “OFST999999 Field To Ignore”. In doing so, the records of A will not be deleted as the recipient will ignore the records coming from B. This field can be used as often as required in a spreadsheet as shown below.

Graphic multiple sources

[IGNORE] Command

The openfunds standard follows the principle of mirrored databases. This means that if the sender exports all data from its database and the recipient imports it, the two databases should contain identical data. If you send a flat file with a value in a certain field and later send an update where the same field is empty, the initial value will be deleted. That means an empty field leads to a deletion of a value. For more information about empty fields, please consider our white paper Ambiguity of Empty Fields . To avoid any deletion of a value in the receiving database, openfunds recommends using the “[IGNORE]” command instead of an empty field (including square brackets and all capital letters).

Graphic multiple sources

The best solution to choose

The solution that is easiest to implement should be chosen. If consistent fund house databases should be constructed, then it can be done based on one of the three options described above. These solutions can be used not only for internal records, but also for external ones in order to avoid the unintentional deletion of data.

Document Information

Title: How to scope data with multiple sources in openfunds
Language: English
Confidentiality: Public

Revision History

Version Date Status Notice
1.0 2018-06-05 Final First Version
If you wish to read or download this white paper as PDF, please click here