top of page
Impressionen_Aufmacher_edited.jpg

OData - THE NATIVE EXCEL INTERFACE TO PATRONAS OPUS

Author Thomas Ehret, Updated 5 Jul

OData - THE NATIVE EXCEL INTERFACE TO PATRONAS OPUS

| Open Data Protocol - the best way to REST

OData

Until now, with PATRONAS OPUS you could already quickly and easily receive displayed data (e. g. portfolio, order book, master data) directly via Generic Export as an Excel file for further processing. PATRONAS has set itself the goal of providing you with even more support for regular data queries. We asked ourselves how to map this with a modern technology framework in a most reasonable way.

 

Our approach:

The tried and tested PATRONAS OPUS already enables this task very well via our REST API. Therefore we worked on making the strength of the system - a modern and flexible API framework - available to users who do not develop themselves.

 

The solution:

The Open Data Protocol (OData) is an http-based protocol for data exchange between compatible software systems, in our case between MS Excel and PATRONAS OPUS. OData works on the basis of entities, i. e. defined, typified classes with properties.

This means that OData can also be used by end users who want to directly use relevant entities for an evaluation. You can therefore easily create queries optimised for your use case in OData. To do this, it is sufficient to use an Excel version more recent than Excel 2016 and to have created a user specifically for the use of OData.

 

Your benefit:

With this technology, you can easily access the data of our integrated portfolio, risk, compliance and order management solution PATRONAS OPUS from MS Excel and thus create the basis for regular reports.

 

Good to know: OData is documented in the PATRONAS OPUS HelpCenter, and we also offer training on this topic upon request.

 

Contact:

Please contact us at academy@patronas.com for enquiries about training or if you need direct support in creating OData use cases.

 

 

Examples of current application scenarios of our customers:
 

  • Portfolio enquiries, asset allocation evaluations based on them

  • Passing on data to external parties, e. g. fund databases

  • Checking stored data, e. g. comparison with data supplier

  • Reconciliation of model portfolios with pre-trade portfolio, especially for complex ESG mandates

  • Evaluations within the scope of authorisation management, e. g. overview of assigned user authorisations

OData

Example: result of master data query

OData

Example: portfolio query

bottom of page