Reference Data Management Functions

Data in relational databases can be processed in MediationZone for a range of purposes including enrichment, applying formatting, routing rules, and more. This data may require periodical maintenance and review, manual or automated.

Making this data available for various users and applications can be challenging due to security policies. If a database user needs access to only a subset of tables in a schema, the typical solution is to create table views. This can be cumbersome when you need to differentiate access to different users that maintain different subsets of the tables.

Reference Data Management mitigates this problem by delivering the capability to query and edit specific table sets in relational databases while schema permissions remain unaltered.

A MediationZone user with the appropriate access rights can create profiles that limit read and write access to sets of tables. Other users, possibly with more restricted access, can then use these profiles in workflow configurations.

Secure access via Reference Data Management

Reference Data Profile

The Reference Data Profile contains settings for selecting Database profile, tables, access permissions, and logging.

Reference Data profile

You can use the Reference Data profile to select the tables that should be available for query and editing. You can then use the Web GUI to query, edit, import or export data in the database tables specified in the Reference Data profiles, without any knowledge about SQL.

The database operations available for Reference Data Management are also supported via a REST interface on the Platform. In addition, a DB Ref Event is triggered when you commit changes to a database table, or perform import operations in Reference Data Management.