The Data Sources view allows you to manage data sources and data source groups. The Data Sources view is available to users with either set of the following permissions.

  • Administrator (12) permission
  • WebUI (8), MgmtAPI (11), and ViewDataSource (2) permissions

The Data Sources view consists of the following pages.

Data Sources

The Data Sources page enables you to create, edit, delete, and share data source definitions. A data source definition configures the connection between Hybrid Data Pipeline and a data store.

data sources page

The following table provides permissions and descriptions for basic actions in the Data Sources page. For detailed information on creating data sources, see Creating data sources with the Web UI and How to create a data source in the Web UI.

Note: With the appropriate permissions, administrators can view data sources owned by other users through the Web UI. However, administrators cannot create, modify, delete, or share data sources owned by other users through the Web UI. To create, modify, delete, or share data sources that belong to other users, administrators must use Hybrid Data Pipeline APIs. See Data Sources API and Managing resources on behalf of users for further details.
Action Permissions Description

Filter data sources by tenant

Administrative access to multiple tenants

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ViewUsers (14)

Note: Any user with the Administrator (12) permission can view the data sources of any user across all tenants.

An administrator with administrative access to multiple tenants will have the option of filtering by tenants to view data sources owned by a given user. Select the tenant in which the user resides from the Select Tenant dropdown.

Filter data sources by user

Administrative access to the tenant

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ViewUsers (14)

Note: Any user with the Administrator (12) permission can view the data sources of any user across all tenants.

A user with administrative access to a tenant can filter data sources by user. Select the user whose data sources you want to view from the Select User dropdown.

Search for a data source

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

Use the search field in the upper right to filter data sources by name, data store, and description.

Create a new data source

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

CreateDataSource (1)

To create a new data source, click + New Data Source. See How to create a data source in the Web UI for details.

Modify a data source

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ModifyDataSource (3)

To modify a data source, select the data source from the list of data sources. Then, select Edit from the Actions dropdown. Edit the data source as desired.

Delete a data source

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

DeleteDataSource (4)

To delete a data source, select the data source you want to delete. Then, select Delete from the Actions dropdown. Confirm or cancel the delete operation in the dialog.

Share a data source

Administrative access to the tenant

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ViewUsers (14)

CreateDataSource (1)

Note: Any user with the Administrator (12) permission can share a data source he or she owns with any tenant across the system.

To share the data source:

  1. Select the data source from the list of data sources.
  2. Select Share from the Actions dropdown.
  3. Select the user or tenant with which you want to share the data source.
  4. Select the permissions you want to grant the user or tenant.
  5. Click Save.

To stop sharing the data source:

  1. Select the data source from the list of data sources.
  2. Select Share from the Actions dropdown.
  3. Select the user or tenant with which you want to stop sharing the data source.
  4. Click Remove.

Test a data source

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

SQLEditorWebUI (10)

At least one of the following query permissions:

  • UseDataSourceWithJDBC (5)
  • UseDataSourceWithODBC (6)
  • UseDataSourceWithOData (7)

To run queries against a data source through the Web UI, select the data source. Then, select SQL Testing from the Actions dropdown. You are directed to the SQL Editor view where you review schema and execute a SQL statement against the data source.

Sync OData Schema

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ModifyDataSource (3)

OData enabled data sources maintain an OData model. The OData model should be refreshed whenever the schema of the data source has been changed. To refresh the OData model, click the sync icon . For details, see Configuring data sources for OData connectivity and working with data source groups.

Obtain OData URI

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

To obtain the OData URI for an OData enabled data source, click the link icon to copy the link associated with the data source.

Configure data source logging

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

Logging (24)

To configure data source logging, click the settings icon . You are directed to the Logging Settings page. Set logging and privacy levels as desired.

Download the logs for a data source

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

At least one of the following query permissions:

  • UseDataSourceWithJDBC (5)
  • UseDataSourceWithODBC (6)
  • UseDataSourceWithOData (7)

To download the logs for a data source, click the download icon next to the data source. A zip file containing the data source logs will be downloaded to your browser's download directory. For details, see Data source logging.

Data Source Groups

The Data Source Groups page enables you to combine OData enabled data sources into a single data source group. You can create, edit, delete, and share data source groups from this page.

data source groups page

The following table provides permissions and descriptions for basic actions in the Data Source Groups page. For detailed information on creating OData enabled data sources and data source groups, see Configuring OData connectivity.

Action Permissions Description

Filter data source groups by tenant

Administrative access to multiple tenants

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ViewUsers (14)

Note: Any user with the Administrator (12) permission can view the data source groups of any user across all tenants.

An administrator with administrative access to multiple tenants will have the option of filtering by tenants to view data source groups owned by a given user. Select the tenant in which the user resides from the Select Tenant dropdown.

Filter data source groups by user

Administrative access to the tenant

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ViewUsers (14)

Note: Any user with the Administrator (12) permission can view the data source groups of any user across all tenants.

To filter data source groups by user, select the user whose data source groups you want to view from the Select User dropdown.

Search for a data source group

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

Use the search field in the upper right to filter data source groups by name, data store, and description.

Create a new data source group

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

CreateDataSource (1)

To create a new data source group, click + New Group. See Creating a data source group for details.

Modify a data source group

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ModifyDataSource (3)

To modify a data source group, select the group. Then, select Edit from the Actions dropdown. Edit the group as desired.

Delete a data source group

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

DeleteDataSource (4)

To delete a data source group, select the group you want to delete. Then, select Delete from the Actions dropdown. Confirm or cancel the delete operation in the dialog.

Share a data source group

Administrative access to the tenant

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

ViewUsers (14)

CreateDataSource (1)

Note: Any user with the Administrator (12) permission can share a data source group he or she owns with any tenant across the system.

Note: Sharing a data source group requires that the member data sources of the group also be shared.

To share the data source group:

  1. Select the data source group from the list of data sources.
  2. Select Share from the Actions dropdown.
  3. Select the user or tenant with which you want to share the data source group.
  4. Select the permissions you want to grant the user or tenant.
  5. Click Save.

To stop sharing the data source group:

  1. Select the data source group from the list of data sources.
  2. Select Share from the Actions dropdown.
  3. Select the user or tenant with which you want to stop sharing the data source group.
  4. Click Remove.

Obtain OData URI

WebUI (8)

MgmtAPI (11)

ViewDataSource (2)

To obtain the OData URI of a data source group, click the link icon to copy the link associated with the data source group.