Remote File

1. How to connect to your data?

1. Go to the Resources page and click the Add Resource button.

2. In the "Select a data source" step, select Remote File.

3. In the "Configure the data source" step, enter the credentials:

Note: remember to add Acho's IP address, 35.239.14.244, to your whitelist before starting the connection.

This is an example of SFTP:

• Resource Name: the displayed name of the data file on Acho.

• Dataset Name: the dataset name in your SFTP server.

• File Format: Acho only supports CSV files for now.

• Host: the host of the SFTP server.

• Port: the port of the SFTP server.

• User: the user name of the SFTP server.

• Password: the password of the SFTP server.

• URL (Path): the URL to access the file in the SFTP server.

4. In the "Select the tables", choose tables that you want to import.

5. Click Finish Setup. You will see a icon next to your resource. It may take a few minutes to several hours depending on the data size and the number of your tables. Once your APP's data is ready, you will receive a notification email.

2. How to set up Data Sync?

Acho supports creating schedulers to retrieve the latest data from your database at a certain time interval. To see more details, you can visit here.