The Data Sources tool is located in the Configuration section of the System Administration tab. This article outlines how the Data Sources interface, which changes based on the chosen Data Source type (File, Oracle, SQL Server, or Map Service), can be utilized for various configuration purposes. 

File Data Source

Load Files

To load files into the data source, follow these steps:

1. Select "File" in the Data Source Type dropdown.
2. Click the “Show/Add Files” button to open up the “Files Found” interface. If the desired files already exist in the file share, skip steps 3-5.
3. Click the “Choose Files” button. A file manager will open prompting the user to add files from the local computer. 
4. Select one or more files to add. Hold down the control (Ctrl) key while clicking on a file to select multiple files. 
5. After selecting all of the desired files, click the “Open” button. Inventory Manager will then add the selected files to the application’s file share.
6. To finish uploading the files to the data source, check the checkbox to the left of the file and click the “Add Files to Source” button.
7. For files that require separating characters, such as CSV files or pipe delimited files, edit the Separating Characters column in the main table by clicking into the cell to change the value to ensure proper file parsing and loading. Skip this step if the file does not require a separating character.
8. Select which files to load/reload into the data source by selecting the checkbox located in the “Load/Reload” column.
9. After selecting the desired file(s), click the “Save Changes” button to load/reload files.

Delete Files

To delete a file from the data source, follow these steps:

1. Select which files to delete by checking the checkbox in the “Delete” column in the table. If you would like to delete all files in the data source, click the “Select All to Delete” link instead.
2. After selecting the desired files, click the “Save Changes” button.

Database and Map Server Data Sources

Create 

To create a SQL Server, Oracle, or Map Service data source, follow these steps:

1. Fill out the connection parameter fields.
   • The Server, User Name, Password, Database, and Shortcut parameters are required for managing a Database source type (Oracle and SQL Server).
   • The Service Directory, Service, Service Type, Include in Map Legend, and Shortcut parameters are required when managing a Map Service data source type.
2. After all parameters have a value, click the “Verify Source” button in the lower left corner of the interface to verify the connection to the specified database or map service.
3. If the connection is valid, click the “Save Changes” button.