Can I Connect Fivetran to a Database Source That Is Restored Periodically From a Backup of Another Database?

Question

Is it possible to connect Fivetran to a database source that is restored periodically from a backup of another database?

Environment

Database connectors

Answer

No, it's not possible to connect Fivetran to a database source that is restored periodically (for example, every night or every hour) from a backup of another database.

Restoring the source database from a backup causes Fivetran to perform a complete re-sync, which may never complete if you perform a restore every day. For more information, see our documentation.