I have a client that needs a website that gets data from an external software. The data can be up to 1-day old. Is there any way to have the data from the external database synced every night to a Wix collection (so that the website itself only "talks" with an internal Wix Collection, but that wix collection is updated automatically from the external software)?
The external software stores its data on a Pervasive DB. Ideally, the sync would be done directly from there. The data is also synced to MSSQL daily, so the sync could also be done from the MSSQL DB.