Defining a Data Source Configuration

To define a new data source configuration:

  1. Make sure you are logged in as a Composer administrator or a user with the Can Create new Data Sources privilege.

  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.

  3. On the Sources page, select the button. The Select a Source Type dialog appears, listing all of the available connection types.

  4. Select a connection type.

  5. After making your selection, the data source configuration wizard starts. It consists of a series of tabs, with the General tab displaying first. Provide a name for the new data source and an optional description on the General tab. See General Tab.

    If you select a Fusion, flat file or upload API data source, the tabs are different than they are for all other data source configurations. See Creating a Fusion Data Source, Uploading a Flat File into Composer, and Using the Upload API.

  6. Select to proceed to the Connection tab. Select an existing connection definition for the data source or provide credentials for a new connection definition on the Connection tab. See Connection Tab, Selecting a Data Store Connection for a Data Source Configuration and Adding Data Store Connections.

    This tab is only available if you are logged in as an administrator or as a user with both the group privileges Can Manage Connections and Can Create new Data Sources.

    For flat file data connectors, the Connection tab is replaced with a Data tab and there is no Tables or Indices tab.

  7. Select to proceed to the Tables or Indices tab. Select the data table you want to use for this data source configuration on the Tables or Indices tab. You can also use this tab to enable data caching. See Tables/Indices Tab and How Composer Caches Data.

  8. Select to proceed to the Fields tab. Configure the fields for the data source configuration on the Fields tab. You can alter the field labels, types, format, ranges, and enable or disable distinct counts. You can also define derived fields and custom metrics for the data source. See Fields Tab, Enabling Distinct Counts, Maintain Composer v6 Derived Fields, and Maintain Composer v6 Custom Metrics.

  9. Select to proceed to the Refresh tab. Define refresh jobs for the data that Composer caches for the data source configuration. See Refresh Tab, Setting Up a Data Source Refresh Job, and Triggering Refresh Jobs.

  10. Select to save the data source configuration and proceed to the Visuals tab. Define default settings for visuals created using the data source configuration. You can also configure the time bar (including refresh rates) and search bar defaults for your data source. See Visuals Tab, Configuring Time Bar Defaults, and Configuring Search Box Defaults.

  11. Select to save the data source configuration. Your new data source configuration is listed in the list on the Sources page.