Edit External Data Sources
If you have LiveCompare Editor or Administrator permissions, you can edit the details for an External Data Source by carrying out the following steps:
- Select an External Data Source from the Data > External Data Sources folder in the LiveCompare hierarchy, and click Edit Details in the Details pane. The Edit External Data Source screen is displayed for the selected External Data Source.
- Make the appropriate changes. The following details may be modified for each type of External Data Source.
| External Data Source | Modifiable details |
|---|---|
| Access | Name, Description, REST API, MDB file, Table name, Standard security info (optional). |
| CSV | Name, Description, REST API, CSV file. |
| Custom | Name, Description, REST API, Connection String, Authentication (if needed), Table name. |
| DB2 | Name, Description, REST API, Server name, Port, Database name, Table name, Username, Password. |
| Excel | Name, Description, REST API, Excel file, Worksheet. |
| HANA Database | Name, Description, REST API, Server, Port, Encrypt, Validate SSL Certificate, Username, Password. |
| SQLite | Name, Description, REST API or private, DB file, Table name. |
| SQL Server | Name, Description, REST API or private, Server name, Port, Database name, Table name, authentication details. |
| Performance History Data | Name, Description. |
| XML | Name, Description. |
- For SQL Server, DB2 and Access External Data Sources, enter any authentication details required to access the database.
- Click Save to save your changes.
An External Data Source may be renamed by selecting it in from the Data > External Data Sources folder and choosing Rename from the context menu. Alternatively, select an External Data Source in the hierarchy and select F2 to perform in-line editing.
If an External Data Source is renamed, any External Data Source parameters that refer to the old name will need to be updated to refer to the new External Data Source name.