# Edit Data Source

This section walks users through the process of editing an existing data source to either modify its name, description, or database credentials.  To edit an existing Data Source, follow the process below.

### **Expand on Data Source**

On the Data Source page, expand on the Data Source you wish to edit.

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2Fr3hFirVHaKXV659pzHhN%2Fds%20page%20expand%20outlined.jpg?alt=media&#x26;token=f1bcf2a1-9c4f-4a8c-9e3d-a5d9238053e4" alt="On the Data Sources page, the &#x27;Demo Data 2024&#x27; item includes a highlighted &#x27;plus&#x27; icon to expand on."><figcaption><p>Data Source Expand Control</p></figcaption></figure></div>

### **Select Edit**

Select the **Edit** button to open the Data Source in edit mode. This will open the Data Source Wizard in edit mode to guide you through the 4-step process of editing a Data Source.&#x20;

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FDv1OpdCGAfO9e3YEw78R%2Fexpanded%20ds%20with%20data%20views%20and%20reports.jpg?alt=media&#x26;token=baf6dbba-c256-4f5d-bee8-38ea321810c5" alt="Data Sources page with &#x27;Demo Data 2024&#x27; expanded. The &#x27;Edit&#x27; button is highlighted."><figcaption><p>Data Source Edit Button</p></figcaption></figure></div>

## **Step 1. Define Your Data Source**

You will be brought to Step 1 in the wizard. Here you can modify the following fields:

1. **Data source name**
2. **Description**

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FbdT97zeC7sXpvPwBzfdy%2Fedit%20ds%20step%201%20fields.jpg?alt=media&#x26;token=b5bd3310-acbb-4a32-957d-55061546e6e1" alt="Step 1 of 4: Define your data source. Editable fields, highlighted in edit mode, include Data Source Name and Description. "><figcaption><p>Step 1: Data Source Editable Fields</p></figcaption></figure></div>

{% hint style="info" %}
**Note:** These fields are optional to edit.
{% endhint %}

Select **Next: Connect** to procced to Step 2.

* Select "**Cancel**" or "**Close**" to exit the wizard, which will discard any information entered or progress made up to that point.

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FYV5wfE8bCo1IXdabJnsw%2Fedit%20ds%20next%20connect%20button.jpg?alt=media&#x26;token=4c65730d-33f6-4469-a4f0-e4d159034e2a" alt="Step 1 of 4: Define data source. The &#x27;Next: Connect&#x27; button at the bottom is highlighted."><figcaption><p>Next: Connect Button</p></figcaption></figure></div>

## **Step 2. Connect to Your Database**

On Step 2, you can modify the database connection credentials. If any changes are made to these fields, you must select the **Test Connection** button to validate the connection.

1. Select the **Edit Password** button to reveal the **Password** field and **Test Connection** button.
2. Optional fields to modify include:
   1. Server Address
   2. Port number
   3. Database name
   4. Username
   5. Password

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FsDfbayTREfxcWMbCtMyl%2Fedit%20ds%20step%202%20fields.jpg?alt=media&#x26;token=adca85eb-1c34-410d-9c45-ac1879546117" alt="Step 2 of 4: Define source connection. The highlighted fields—Server Address, Port Number, Database Name, Username, and Password—are editable in edit mode. Buttons include &#x27;Edit Password,&#x27; &#x27;Test Connection,&#x27; &#x27;Back,&#x27; &#x27;Next: Review,&#x27; and &#x27;Cancel.&#x27;"><figcaption><p>Step 2: Data Source Editable Fields</p></figcaption></figure></div>

{% hint style="warning" %}
**Note:** Changes to the **Server Address**, **Port number**, **Database name**, or **Username** require the connection to be tested before moving forward.

If changes were **not** made to the connection fields, and only the name or description of the Data Source was changed in Step 1, testing the connection is not required.
{% endhint %}

After testing the connection or if no changes were made, select **Next: Review** to proceed to Step 3.

* Select "**Back**" if you need to revise any previous steps.
* Select "**Cancel**" or "**Close**" to exit the wizard, which will discard any information entered or progress made up to that point.

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FjkjhpczwGXCDCwsb4ixc%2Fedit%20ds%20step%202%20next%20review%20button.jpg?alt=media&#x26;token=8ea45912-1911-48de-bfef-fce6dd5f084c" alt="Step 2 of 4: Define source connection. The &#x27;Next: Review&#x27; button is highlighted, allowing users to proceed after entering the required database connection details."><figcaption><p>Next: Review Button</p></figcaption></figure></div>

## **Step 3. Review Impact Analysis**

On Step 3, you can view the Impact analysis, showing how your changes may affect existing data views or reports created with the Data Source. &#x20;

Below is an example of a Data Source that has data views and reports created with it.&#x20;

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FItpnvObPpmWJ8M0cY30N%2Fedit%20ds%20step%203%20imapct.png?alt=media&#x26;token=e24ca300-0760-477e-89aa-fcd058656167" alt="Step 3 of 4: Impact analysis page highlights the &#x27;Impact analysis&#x27; section. It shows 2 data views and 1 report linked to the data source. Includes details of a report named &#x27;IDEA Child Count and Educational Environments&#x27; with status &#x27;Draft&#x27; and audience &#x27;Internal.&#x27; Below, another data view with no linked reports is listed. Navigation buttons for &#x27;Back,&#x27; &#x27;Next: Save,&#x27; and &#x27;Cancel&#x27; are visible at the bottom."><figcaption><p>Step 3: Data Source Impact Analysis </p></figcaption></figure></div>

Select **Next: Save** to proceed to Step 4.

* Select "**Back**" if you need to revise any previous steps.
* Select "**Cancel**" or "**Close**" to exit the wizard, which will discard any information entered or progress made up to that point.

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FssCXxNBWkHCrvERCzp2m%2Fedit%20ds%20step%203%20next%20save.png?alt=media&#x26;token=78fe84de-e634-46ef-8d0d-1c592e2ce998" alt="Step 3 of 4: Impact analysis page highlights the &#x27;Next: Save&#x27; button at the bottom."><figcaption><p>Next: Save Button</p></figcaption></figure></div>

## **Step 4. Data Source Summary**

On Step 4, review the summary details of your Data Source and select **Save**.

* Select "**Back**" if you need to revise any previous steps.
* Select "**Cancel**" or "**Close**" to exit the wizard, which will discard any information entered or progress made up to that point.

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2Fd9wvNZ59Q5ioHhG7YOro%2Fedit%20ds%20step%204%20save%20button.png?alt=media&#x26;token=d4d766e0-2083-4518-8662-70f51e29b5b6" alt="Step 4 of 4: Define source summary. The &#x27;Save&#x27; button is highlighted, allowing users to proceed to save."><figcaption><p>Save Button</p></figcaption></figure></div>

Once you have selected **Save** a modal will display, prompting you to provide a reason for editing the Data Source.&#x20;

1. Select the dropdown arrow on the **Reason** field and select one of the following options:
   1. Data Quality&#x20;
   2. Data/File is corrupted&#x20;
   3. Data needs to be updated
   4. System is down / cannot collect for certain period of time
   5. Other **(Requires an additional comment)**
2. &#x20;Fill out additional information in the **Additional comment** field **(if required).** &#x20;

{% hint style="info" %}
If the reason "**Other"** is selected from the list, you will be required to provide additional comments in the "**Additional comment**" field.
{% endhint %}

<div align="center"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FVtfrUTvwkSzXOulhHcGo%2Fprovide%20a%20reason%20fields.png?alt=media&#x26;token=e8925b4b-8497-4b3e-b2d0-6423ec50bf00" alt="Please provide a reason&#x27; modal. The &#x27;Reason&#x27; dropdown field is highlighted as a required input. Highlighted below it is an optional &#x27;Additional comment&#x27; text box, with &#x27;Confirm&#x27; and &#x27;Cancel&#x27; buttons at the bottom."><figcaption><p>Data Source Reason Modal </p></figcaption></figure></div>

<div align="center"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2FntFZogaaqqk2yBK2v24U%2Fprovide%20a%20reason%203.PNG?alt=media&#x26;token=21c58d70-edce-4968-8139-a5016b3bfc88" alt="A dropdown menu labeled &#x27;Reason: (Required)&#x27; with multiple selectable options. The visible options in the list include &#x27;Data Quality,&#x27; &#x27;Data/File is corrupted,&#x27; &#x27;Data needs to be updated,&#x27; &#x27;System is down / cannot collect for a certain period of time,&#x27; and &#x27;Other.&#x27; Users must select one reason before confirming their changes."><figcaption><p>Reason Dropdown Field</p></figcaption></figure></div>

Once you have provided a reason for your edits, select **Confirm**. You will be redirected to the Data Sources page and a success message will display, confirming your edits were saved.

<div align="left"><figure><img src="https://1447747760-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FarC4MaJejPFvYsqImiyY%2Fuploads%2F01Mhe0C3NZMZJqlSkIMT%2Fedit%20ds%20confirm%20reason%20prompt%20.jpg?alt=media&#x26;token=e66aaec8-a7b4-45ca-a7c7-1b408ac25f43" alt="Please provide a reason&#x27; modal with the &#x27;Confirm&#x27; button highlighted. The &#x27;Reason&#x27; field is set to &#x27;Other,&#x27; and the &#x27;Additional comment&#x27; field contains the text &#x27;Edit data source demo."><figcaption><p>Confirm Button</p></figcaption></figure></div>
