> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pdc-admin/ldc-manage-data-sources-cp/edit-a-data-source-ldc-manage-data-sources-ag.md).

# 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. <br>

   <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p>The fields may vary based on the type of data source you have selected.</p><ul><li>Data Source Description</li><li>Affinity</li><li>Configuration details like User Name, Password, URI, Host, Port, and so on.</li><li>Physical Location</li><li>Storage optimization options</li><li>Note </li></ul></div>
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.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.pentaho.com/pdc-admin/ldc-manage-data-sources-cp/edit-a-data-source-ldc-manage-data-sources-ag.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.