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 |
For External Data Sources that use a REST API, this field contains the URLs required to access the External Data Source. The first URL points to the External Data Source's schema, and the second URL points to the External Data Source's data. By default, REST API External Data Sources return a maximum of 1000 table rows. API tokens provide a level of authentication for External Data Source REST APIs, and are valid for either 30, 60 or 90 days. If you have Administrator permissions, click Make API Token to create an API token for the corresponding External Data Source REST API. |
| 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. |
| Trust Server Certificate | Indicates whether LiveCompare should trust the connection to SQL Server without checking for a certificate. |
| 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. |
| Server | For HANA Database External Data Sources, the SAP HANA database hostname. |
| Port | For HANA Database External Data Sources, the port number of the HANA database server. |
| 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.