Data Mediation › How to Implement Data Mediation

How to Implement Data Mediation

The following steps describe the overall process for implementing Data Mediation:

1. Create profiles for each data set that is to be mediated and then aggregated.
2. Import the data (files, external DB) for the associated profile.

   Note: Table names and columns names in the data being imported must be in English.

3. Ensure your fiscal period has been defined to fit your business model.
4. Aggregate data (one or more times) so that the metric result and transactions are created. Repeat the aggregation process if any new data is imported or changed for that fiscal period.
5. Generate the invoices to reflect the data being aggregated, after all the data is imported and aggregated.

Profile Management

Profile management is a definition of the data feed of the external data, providing powerful features to manipulate and normalize usage event data. The profile also contains the initial aggregation logic in the form of an SQL statement. This initial aggregation logic is specified during profile definition.

If necessary, usage event data can be normalized or aggregated, preparing it for the Data Mediation's aggregation and cost allocation processes through a SQL query or procedure defined in the profile. This profile feature helps normalize the data to a common format understood by Data Mediation.