Edit a data source

With applicable permissions, you can update an existing data source configuration when connection details, credentials, storage settings, or governance-related metadata change. You can edit a data source to update connection details such as the host, port, URI, user name, password, or affinity. You can also update descriptive information, physical location, storage optimization settings, and usage data collection settings for supported database data sources.

Prerequisites

• Make sure that you have the required permission to update data sources in Data Catalog.
• If you plan to enable usage data collection for a supported database data source, ensure the source-specific requirements are met. For Microsoft SQL Server and Oracle, source-side auditing must be enabled. For Microsoft SQL Server, you must also provide the required log path.

Perform the following steps to edit a data source:

Procedure

1. Click Management in the left navigation menu and on the Resources card, click Data Sources.

   The Manage Data Sources & Data Centers page opens.
2. Locate the data source you want to edit, then click View at the right end of the row.

   The Edit Data source page opens.
3. You can edit the following additional connection information.

   The fields may vary based on the type of data source you have selected.

   • Data Source Description
   • Affinity
   • Configuration details like User Name, Password, URI, Host, Port, and so on.
   • Physical Location
   • Storage optimization options
   • Note
4. (Optional) For Microsoft SQL Server, Oracle, and Snowflake data sources, to enable or disable usage data collection for a supported database data source, turn Enable Usage Data Collection on or off.

   For Microsoft SQL Server, verify that the Log Path is specified before you save the data source.
5. Click Test Connection to verify the updated configuration.
6. Click Save Data Source.

Result

The data source configuration is updated. If you enable or disable the usage data collection, Data Catalog starts or stops collecting usage activity for the data source, respectively.