The Data Sources tool is accessed from the More dropdown menu found in the top navigation bar and provides a way to add, remove, and update the data sources that you wish to have access to within the application. Data sources provide access to your data from various applications and tools. Data sources can consist of a simple database connection string and provider name, and/or a service URL that points to a map service that is published with the specified connection string. A data source does not have to have both a database connection and a service URL, but if both are provided the two must point to the same database.
Note: Data Sources are mainly managed in the Application Manager, but administrators can add and edit them in the Road Analyzer application as well.
- Click the magnifying glass to open the Search box.
- Start typing the name of the data source in the Search box to bring up the matching data sources.
- Select the data source from the search list.
- Click Filter to open the filter options at the top of the table.
- In the column you want to filer, start typing what you want the table to be filtered against.
- The view will update to show only the matching result(s).
- Click Refresh to refresh the table.
- Click Filter again to close the fields and show all the data sources in the table.
To add a new data source:
- Click + Add New to expand the new Data Source form.
- Fill in the Name, Description, and Database Type.
- Enter the Connection String. Use the Test Connection button to verify the string.
- Enter the Associated Service URL.
Note: This step is optional, but very helpful to have your database and map service in sync. Please contact your database and map service administrator for help in setting these up.
- Click the Save button.
Locate the row for the Data Source you wish to test and click the test icon.
To update an existing data source:
- Locate the row for the Data Source you wish to edit and click the pencil icon.
- Make desired changes to the form input, and then click the Test Connection button to verify the string still connects.
Heads Up! This does not test the Associated Service URL, so if the Data Source does not have a Connection String then this test will fail even if the Associated Service URL is correct.
- Click Save.
To delete an existing data source:
- Locate the row for the Data Source you wish to delete and click the trashcan icon.
- Click Delete in the confirmation popup.
Heads Up! A data source must be "cleaned" prior to deleting. Meaning - the data source should not be in active use by any Transcend application. Also, any LRS metadata associated with the data source, should be deleted.