Creating a MetaData Set

Home > Connector > Getting Started > Creating a MetaData Set

Creating a Metadata Set

Sage Intelligence Reporting uses Metadata to describe an organizations useful data. Metadata is often referred to as data which describes data. Typically a Metadata set will provide a user friendly view onto a set of technically obscure data. It allows data to be more easily available to non technical users or to users who have no knowledge of the underlying source data system. A good Metadata set should describe a data set in a manner which is consistent and easy to understand. Where data comes from different sources and systems with inconsistent naming conventions, the Metadata can achieve a consistent facade allowing the user to be unconcerned with the source and source type of any given data.

Sage Intelligence Reporting allows a System Administrator to perform a Metadata mapping exercise once which then benefits all end users. The Connector is used to perform this mapping exercise. In addition to mapping the Metadata the exercise should also involve some configuration to optimize the way in which data is accessed by Sage Intelligence Reporting.

Creating a Metadata set:

1. Create and test a Data Connection.
2. Publish Data Containers and Data Expressions giving them meaningful names.
3. Configure the Data Expressions so that the data is accessed in a sensible manner.

Once a good Metadata set is published the users of the Report Manager Interface will be able to easily access the data.

The Connector allows the System Administrator to rename the technical expression names normally contained in databases. By renaming the expressions, the System Administrator creates a metadata set that is user friendly and which allows the user to clearly identify the relevant fields for reporting when using the Report Manager Interface.