Insights : What is a fully extendable Cloud CTRM Data Model?

Jan 2020

CoreTRM is a fully extendable cloud based multi-tenant application.

A multi-tenant application is one where the database is shared by multiple tenants (clients) but each one is isolated from the other by application code. For clients who prefer it, CoreTRM is also available using a private database with segregated cloud resources.

Cloud based multi-tenant systems have many advantages including a single fully secure and fully patched environment, a single continually updated code-base, easily configurable database geo-location for disaster recovery, database encryption for security, and seamless scaling of hardware resources.

Ordinarily with a shared database setup there is no ability to extend the database for specific clients other than adding new tables and columns to the shared database even though they are not required for other clients.

Reasons why you may want to extend the database include the ability to view and update additional data specific to your company, build out the core system with additional functionality, or to facilitate two-way integration with connected applications.

CoreTRM addresses this by using tenant-specific metadata to create a dynamic data model for each client which is made up of core objects (tables) and items (columns) and extended objects and items.

Extendable cloud CTRM

There is no limit to the amount of extended data you can add and all extended objects and items are treated as first-class citizens in the data model. To the end-user there is no difference between a core item or an extended item. Extended data objects and items utilize the same security control, api and ui access, auditing, lookups, relationship integrity and validation rules as core objects and items.

All of this can be done using the online interface with no coding required. As well as allowing for future enhancement this ability makes for an easier initial implementation as the consultants, who may be working to tight deadlines, are less dependent on central development resources.

Ease of Integration

Each client will inevitably need to integrate with other applications.

For example, a finance application may retrieve settlement data. It may further process that data and then send status updates, etc back to the CoreTRM instance so that users can track the full life-cycle of the settlement. Different clients may use different finance systems and the individual requirements will vary.

Being able to extend a client's data model means that this scenario and many other integration challenges can be easily addressed.

Private Cloud

CoreTRM can also be implemented in a private segregated cloud environment which could be single or multi-tenanted. If your organization has multiple types of trading businesses CoreTRM provides the ability to pool them in a private cloud setup for ease of maintenance and optimization of costs while still allowing individual customization.