How to connect to SQL Server?
Acho allows you to connect to any SQL Server database (Self-hosted, GCP Cloud SQL, AWS PostgreSQL, AWS Aurora...). You can follow the steps below to set up the connection.
Go to the Resources page and click the Add Resource button.
In the "Select a data source" step, select SQL Server under the Database tab.
In the "Configure the data source" step, enter your database login credentials.
In the "Select the tables", choose tables that you want to import.
Click Finish Setup. You will see a "syncing" label next to your SQL Server 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.
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.
How to add Acho's IP into your whitelist?
You should whitelist our service IP address 188.8.131.52 . This way we can make a connection to your database and import the tables to Acho Studio. Here is how you can whitelist Acho's service IP address for your database instance.
For more info, please visit Connect to SQL Server