Objective
Keep a Data Source usable without deleting and recreating it. For example, edit a Data Source when an external database password rotates. Edit it when the host changes after an infrastructure migration. Edit it when a new schema must be visible, or when SSL settings change.
When to use
Use this task when:
- credentials changed.
- host, port, or database name changed.
- schema access changed.
- SSL mode or connection options changed.
- metadata needs better operator context.
Before you start
Confirm what changed:
- credentials: update Username or Password.
- database location: update Host, Port, or Database Name.
- schema visibility: update the schema list.
- security: update SSL Mode.
A Data Source update affects future Report generation. Reports already generated stay unchanged.
Step by step
1
Open Data Sources
Go to Data Sources.
2
Find the connection
Locate the card for the Data Source you need to edit.
3
Open the edit form
Click the three vertical dots () on the card and select Edit.
4
Update the fields
In Edit Data Source, change the fields that need correction.
5
Save changes
Click Save Changes. The Console saves the changes and tests the connection.
6
Read the test result
When the test succeeds, the dialog closes. When it fails, the changes stay saved and the dialog shows the reason. Click Edit connection to fix it, or Keep anyway. When the test cannot run, the dialog closes and a message says that the connection could not be checked.
The Password field appears empty for security reasons. Leaving it blank keeps the current password, unless you change Database Type, Host, Port, Database Name, Username, SSL Mode, or Connection Options. Then re-enter the password, even when it did not change.
Field guide
Expected result
The Data Source keeps the updated configuration. After a successful test, operators can rely on it for Templates and Reports.
Common errors and care points
Leaving password blank unintentionally
Leaving password blank unintentionally
Leaving Password blank keeps the existing password only when no connection setting changes. When one changes, re-enter the password.
Changing host without testing
Changing host without testing
Host and port changes can point Reporter to a different database. Read the test result that the Console shows after saving.
Removing a schema that Templates use
Removing a schema that Templates use
If a Template or filter depends on fields from a schema, removing that schema can break future generation.
Editing when the connection should be retired
Editing when the connection should be retired
If no reporting process uses the database, delete the Data Source instead of editing it.
Next steps
- Use Test a Data Source Connection to test the connection again later.
- Use Generate a Report only after the connection is healthy.
- Use Delete a Data Source when the connection is retired.