Managing Data Sources

Data source management can be divided into two main aspects: data source setup; and management of user access to data source servers, data models, databases, and all related elements.

Data sources must be setup up by an Admin from the Data Sources page. Apart from providing a convenient mechanism to add new data sources for end users (who don't need to handle all the complexities of setting up a data source), it also provides the main mechanism for governing who can see which data source (by role) and who will be able to write-back and build models into the data source where possible.

Edit Data Sources

Users can perform the following actions:

  • Edit Model Name: (red box) - Change the name of the model
  • Change Data Source: (green box) - Change the data source using the explorer content folder. This enables users to change the data source for the underlying Discovery queries. It has the same effect as using the data source changer for Discoveries, Presentations and Publications.
  • Add Connection: (yellow box) - Add additional data sources to allow users to query data sources using the formula wizard, without adding Discoveries (see below).

Using Formula Wizard

The formula wizard can be used to access data from any existing data connection, without having to create Discoveries first.

Admin Functions

Once the materialized data artifacts have been created, admins can continue to administer and adjust these security settings through the Data Source Manager while model owners can administer the

same security settings through the Materialized Data Manager - albeit with less scope and functionality.

The Data Source Manager is where admins manage user access to data source servers, databases, data models and all related elements. This is also where admins can edit metadata overlays within data models, enabling them to ensure that the data is named and described for each user role in the required way. As security and metadata is role-based, the admin simply needs to assign the relevant roles to the selected items.

Other topics