In Geovonic Connect, data sources provide connectivity to third-party business systems. The FTP File data source allows you to fetch information from a CSV file hosted on an FTP server.
As an example of the user of this data source, you might have an ERP system that runs a scheduled job to output property information to a CSV file every 60 minutes and host that data on an FTP server. This data source can connect to the FTP server and retrieve the data for display in your ArcGIS web mapping application.
TechnologyOne’s asset management system supports this method of exporting data to an FTP file server.
Data Source Configuration
The FTP File data source configuration requires a few fields to provide the file location and authentication credentials.
- Host – The URL to your FTP file server.
For example,ftp://myserver.gov.au
- Username – The username to be used for authentication.
- Password – The user’s password.
- File – The pull path to the file.
For example,data/export/my-file.csv
- File Type – Currently only supports CSV file type.
- Refresh Interval – How long in minutes should Geovonic Connect cache the file before fetching a new copy.
It is important when configuring any integration service to follow the Principle of Least Privilege. Any credentials used for the FTP file server should only be able to access the minimum amount of information to meet the needs of your Geovonic Connect application. For example, do not provide the admin credentials for your server as Geovonic Connect only needs to read the specified file. Best practice is to create a new user with the least required privileges.
Layer Link Configuration
The Authority Altitude layer link configuration has several fields which determine the information to be returned.
- Index Attribute – a column name in your FTP file that will be matched with the feature attribute.
- Feature Attribute – an attribute on the feature layer that will be matched against the index attribute.