Manage datasources and connections - Precisely Data Integrity Suite

Data Integrity Suite

Product
Spatial_Analytics
dis_mcp
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
platform_spatial_analytics
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Precisely MCP
Data Integration
Data Enrichment
Data Governance
Geo Addressing
Data Observability
Data Quality
Core Foundation
ft:title
Data Integrity Suite
ft:locale
en-US
PublicationType
pt_product_guide
copyrightfirst
2000
copyrightlast
2026

Once a datasource has been added, you can view its details, edit its name and description, or remove it. You can also manage its connections by finding, testing, editing, duplicating, removing connections, and configuring insights and schedules.

Go to Configuration > Datasources in the main navigation menu. To manage connections for a specific datasource, select the datasource from the list.

Datasource and connection permissions

Preview: This feature is currently in Preview for select workspaces and might be subject to change before general availability.

The actions available for datasources and connections depend on your assigned permissions. These permissions are action-based, so view access does not automatically include create, update, delete, or operate access.

Permission Allows
View View or list datasource and connection information.
Create Create datasources and connections.
Update Modify datasource and connection configuration.
Delete Remove datasources and connections.
Operate Run operational functions for datasource and connection functionality, including connection testing and discovery operations.

View details for a datasource

Required permission: View.

  1. Open the context menu next to a datasource name and select Details.
  2. The datasource details page opens and shows:
    • Datasource type: The type of database the datasource connects to, such as MSSQL or Oracle.
    • Description: A brief summary of the datasource's purpose or data type.
    • Connections, Datasets, Fields: Counts of associated connections, datasets, and fields.
    • A list of all connections associated with the datasource, including each connection's catalog status, dataset and field counts, host or URL, and schedule.

Edit a datasource

Required permission: Update.

  1. Select the datasource name to open its connections page.
  2. Select Edit Details to edit the name and description.
    What's changed: In the new user experience, Edit Details appears as Edit. For more information on the new experience, see About the new user experience.
  3. Select Save.

Remove a datasource

Required permission: Delete.

  1. Open the context menu next to the datasource name and select Remove.
  2. In the confirmation dialog, select the checkbox to confirm and choose Remove, or choose Cancel to exit.
Note:
  • Removal cannot be undone. All in-progress data discovery will stop.
  • Removing a datasource connection does not delete related assets or data quality pipelines. Associated assets remain in the catalog; pipelines are unaffected.
  • To remove all associated assets, delete the datasource. Data quality pipelines are not automatically deleted and must be removed manually if no longer needed.

Manage connections

The actions below allows you to handle your connections to various datasources effectively.

Find a connection

Required permission: View.

  1. Select the datasource whose connections you want to search.
  2. Type the connection name in the Search bar above the Connections list, or scroll through the list to locate it.

Test a connection

During connection creation:

  1. In the Add Datasource wizard, complete all required connection fields.
  2. Select Test . A Success message appears if the connection is valid.
    What's changed: In the new user experience, Test appears as Test Connection. For more information on the new experience, see About the new user experience.
  3. Select Next to continue.

For an existing connection:

  1. Find the connection you want to test.
  2. Open the context menu next to the connection name and select Test .
    What's changed: In the new user experience, Test appears as Test Connection. For more information on the new experience, see About the new user experience.
  3. A Success message appears if the test passes.

You can save a connection without testing it, or save one that fails a test and resolve issues later.

Common reasons for test failure:

  • The connection does not have access to the server or database due to network security rules.
  • Data Integrity Suite is unable to reach the datasource host machine.
  • Credentials are invalid or do not provide the necessary access permissions.
  • The database or data warehouse is offline.

View connection details

Required permission: View.

  1. Find the connection you want to view.
  2. Select the connection name. A side panel opens on the right displaying the following details:
Field Description
Description Details about the datasource.
Catalog Summary Overall discovery status for the connection.
Last Completed Timestamp of when discovery last completed.
Datasets Number of datasets associated with the connection.
Fields Number of fields associated with the connection.
Options Fields configured when the connection was added.

View or add data assets

View data assets

Required permission: View.

  1. Find the connection you want to manage data assets for.
  2. Open the connection, then select the Data assets page to view the selected datasets.

Add or change data assets

Required permission: Update.

  1. Find the connection whose configured data assets you want to change.
  2. Open the connection, then select the Data assets page.
  3. To add more datasets, select Edit, choose the checkboxes for the datasets you want to add, then select Save. Discovery starts automatically for the newly selected assets.

Edit a connection

Required permission: Update.

  1. Find the connection you want to edit.
  2. Open the connection, then select Edit Details.
  3. Modify the connection properties on the Edit connection page.
  4. Optionally, select Test to verify the connection.
  5. Select Next to save your changes.

Duplicate a connection

Required permission: Create.

Duplicate an existing connection to reuse its configuration. After duplicating, you can edit any settings.

  1. Find the connection you want to duplicate.
  2. Open the context menu next to the connection name and select Duplicate.
  3. On the Duplicate Connection page, provide a new name.
    Note: You must enter authentication credentials for the duplicate connection to test or save it.
  4. Optionally, select Test to verify the connection.
  5. Select Next to save the duplicate.

Remove a connection

Required permission: Delete.

Warning:
  • Deletion cannot be undone.
  • Connection information remains in the catalog after removal but will no longer be updated during discovery. Update any configuration that depends on the removed connection.
  1. Find the connection you want to remove.
  2. Open the context menu next to the connection name and select Remove.
  3. In the confirmation dialog, select the checkbox to confirm and choose Remove, or choose Cancel to exit.

If the connection is in use by one or more replication pipelines, an error message indicates it cannot be removed.

View insights

Required permissions: You need View permission to view connection insights. You need Update permission to modify insight settings.

  1. Find the connection you want to view insights for.
  2. Open the connection, then select the Insights page. The page displays:
    • Pipeline Engine: The engine used for the selected connection.
    • Profile datasets: Toggle on to profile your data, capturing statistics, distributions, and semantic types. Update permission is required to change this setting.
Note: For on-premises datasources, ensure sufficient executor memory for default rules to run successfully. The recommended minimum is 1.5 GB for a dataset with 50 columns. Increase executor memory as the number of columns grows.
Table 1. Executor memory guidelines
Number of columns Executor memory
50 2 GB
100 3 GB
150 5 GB

View and edit schedule

Required permissions: You need View permission to view a connection schedule and Update permission to modify an existing schedule.

  1. Find the connection whose schedule you want to view or edit.
  2. Open the connection, then select the Schedule page. The page shows:
    • Occurrence: The scheduler frequency (daily, weekly, or monthly).
    • Schedule Summary: A summary of the configured schedule.
  3. If you have Update permission, select Edit Schedule to open the side panel, adjust the settings, then select Save.