(v22) Sources Page

Sources Page

The Sources page allows you to review and maintain your Composer data source configuration definitions.

All users can view the Sources page.

• If you log in as a user who has not been granted permissions for any data sources, the Sources page displays a message indicating that no sources are available.

• If you log in as a user who only has read permissions for one or more data sources, they are shown on this page, but Connection information is not available for the sources.

• If you log in as a user who belongs to a group that is granted the Create New Data Sources or Administer Sources privilege, you can add and maintain data source configurations using this page.

The Sources page includes the following features:

1. The Add Source button allows you to add a new data source configuration. See Define a Data Source Configuration.
2. A table that lists the sources you can see and enables you to maintain defined data source configurations.
3. Options to modify source permissions, view and modify row and column security filters, refresh the cache, and manage Available Visual Types and Materialized Views.
4. A search bar at the top of the page you can use to search for a specific data source configuration in the table.

To access the Sources page:

1. Log into Composer.

2. Select Sources on the UI menu () or the top-level navigation menu, or select the Sources box on the Home page. The Sources page appears.

Depending on your settings, you can edit and delete data source configurations listed in the table on the Sources page. You can also clear the cache for a data source configuration. If there are many sources listed, you may need to search for the data source configuration you need. Use the search bar to search for a source definition in the list. See Search for a Definition in a List.

Each column in the table is described below. The Type, Name, Connection, Author, and Modified Date columns are sortable.

Column	Description
Type	An icon identifying the data store type for the data source configuration.
Name	The name assigned during data source configuration.
Connection	The display name of the data store connection definition connected to this data source. For flat files, you define a Display Name when you upload the file; this name is shown.
Author	The user name of the data source creator.
Modified Date	The time stamp when the data source configuration definition was last modified.
Permissions	Select the permissions button () for a data source to assign and manage its permissions. You can only define permissions for a data source if you are logged in as a user with the Administer Sources privilege, or as a user with the Manage Source Permissions privilege.
Row	Select the row security ( ) button for a data source to define its row security for authorization groups. You can only define row security for a data source if you are logged in as a user with the Administer Sources privilege, or as a user with the Manage Source Permissions privilege.
Column	Select the column security ( ) button for a data source to define its column security for different authorization groups. You can only define row security for a data source if you are logged in as a user with the Administer Sources privilege, or as a user with the Manage Source Permissions privilege.
Actions	Shows icons you can select to perform actions for the data source. Select the trash can () button to delete a data source configuration. Before you delete a data source configuration, you must delete all the dashboards and visuals that use it. See Delete a Data Source Configuration. You can only delete a data source if you are logged in as, a user with the Administer Sources privilege, or a user with read and delete permission for the data source. Select the clear cache () button to clear the data cache for a data source configuration. Select one or more cache options to clear: Data Cache: Clears the cached query results. Statistics Cache: Clears the cache of fields statistic metadata, such as min, max, and distinct values numbers. See How Composer Caches Data and Clear the Cache for a Data Source Configuration. You can only clear the cache for a data source if you a user with the Administer Sources privilege, or a user with write permission for the data source. If a Custom Range has been defined for a field, the minimum and maximum fields used in filters remain unchanged when you refresh source data. These fields are shown with cache actions disabled on the Cache tab. Select the More menu () button to view the More menu for a data source configuration. Options include: Available Visual Types: Select to define what visuals are available for this data source configuration. See Available Visual Types. Materialized Views: Select to define materialized view settings for the data source configuration. See Use Materialized Views (Experimental).