External Data Source Details
If an External Data Source is selected in the LiveCompare hierarchy or External Data Sources screen, the following details are shown. Note that if a workflow or user interface action is currently accessing an External Data Source, it may not be able to be displayed until the workflow or user interface action has released it.
| Field | Description |
|---|---|
| Name: | The name of the External Data Source. |
| Description: | The description for the External Data Source. |
| REST API: | Indicates whether the External Data Source is public or private. Private External Data sources are accessible to LiveCompare only. Public External Data Sources may be accessed by Web Services clients using a REST API. By default, REST API External Data Sources return a maximum of 1000 table rows. |
| Type: | The type of the External Data Source. |
| Connection String: | The connection string used to access the External Data Source. |
| Table Name: | The table name, Excel spreadsheet or CSV file used by the External Data Source. This field is set to ‘App Stats’ for Performance History Data External Data Sources. |
| Link to Data: | For Access, Excel and CSV External Data Sources, click this link to open the data source on the LiveCompare server using Access, Excel, or your default editor for CSV files. |
| Public API: |
For Public External Data Sources, this section displays the URLs through which a Web Services client may access the External Data Source. URLs with the ?schema qualifier return the metadata for the External Data Source’s table in the JSON Table Schema format. URLs without the ?schema qualifier return the External Data Source’s table content in JSON format. Click a link in this section to display the External Data Source’s metadata or table content in your browser. Note that this feature may not be available in Internet Explorer. |
- Click ‘Show Sample Data’ to display a sample of up to 20 rows of data read from the External Data Source. It may take a few seconds to retrieve the data if the External Data Source connects to an external database server.
- Click ‘Edit Details’ to edit the details for the selected External Data Source.
- Click ‘Replace Data File’ to replace the data file associated with the selected Excel, Access or CSV External Data Source.