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 (e.g., every night or every hour) from a backup of another database.

Restoring the source database from a backup causes Fivetran to perform a complete resync, which may never complete if you perform a restore every day. For more information, please visit our Documentation.