Versions Compared

Old Version 2

changes.mady.by.user Randall Ward

Saved on

compared with

New Version 3

changes.mady.by.user Smita Nair

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description

With With release 7.0, we introduced a drop-down list on the dataSource parameter for the various sql macros. This gives the Confluence administrator an opportunity to make it easier for users to discover Data Sources data sources available for use. This article describes how this works and how it can be best customized for your site.

How

...

it works

  • Only data source profiles are provided in the list. See below for how to add application defined Data Sources data sources to the list.
  • A Data Source A data source name can be directly typed in whether it is on the list or not.
  • Even if a Data Source a data source is protected by by Macro Security, it will still show shows up in the list.

Image RemovedImage Added

Browser

...

support

  •  Chrome Chrome
  •  FireFox FireFox
  •  IE  IE 10 or higher is required, otherwise degrades to previous support, no list - you need to type in the Data Source the data source name.
  •  Safari  Safari (8) degrades to previous support, no list - you need to type in the Data Source the data source name. Future support is expected.

Customization

  • The default behavior was is to not expose application defined Data Sources data sources in the list. This gives administrators control over what is exposed. Administrators can easily add a Data Source data source profile to link to a application provided Data Source an application provided data source if they want it exposed on the list. This is done by:
    1. Go to UPM, find the SQL add-on app, and press the click Configure button.
    2. Add a new Data Source new data source profile to the configuration.
    3. Name the profile the same as the application defined Data Source defined data source (or different if you prefer).
    4. Specify the dataSource parameter in the profile pointing the the application defined Data Sourcedata source: dataSource = my_application_defined_data_source_name.
  • Administrators may not want to expose certain application Data Sources data sources - they may be highly restricted (macro-security) or "need to know" usage.