skip to main content
Using Hybrid Data Pipeline : Using the Web UI : Data Sources view
  

Try Now

Data Sources view

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) and ViewDataSource (2) permissions
The Data Sources view consists of the following pages.
*Data Sources
*Data Source Groups

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 pagedata 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)
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)
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)
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)
CreateDataSource (1)
ViewDataSource (2)
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)
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)
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
MgmtAPI (11)
WebUI (8)
ViewUsers (14)
CreateDataSource (1)
ViewDataSource (2)
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)
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)
ViewDataSource (2)
ModifyDataSource (3)
MgmtAPI (11)
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)
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)
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.

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 pagedata 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 data sources for OData connectivity and working with data source groups.
Action
Permissions
Description
Filter data source groups by tenant
Administrative access to multiple tenants
WebUI (8)
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)
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)
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)
CreateDataSource (1)
ViewDataSource (2)
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)
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)
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
MgmtAPI (11)
WebUI (8)
ViewUsers (14)
CreateDataSource (1)
ViewDataSource (2)
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)
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.