Source and Target Requirements

Fivetran Local Data Processing can replicate between databases, directories (file locations), as well as between databases and directories that Local Data Processing calls 'locations'. Local Data Processing connects to these locations directly (from hub machine) or indirectly (via its High-Volume Agent connections). If Local Data Processing must access a source or target database directly, then the database connectivity (e.g. ODBC drivers) must be installed on the hub machine.

Additionally the account that Local Data Processing uses must have sufficient access to capture changes from a source database or integrate changes into a target database.

Topics

The following sections describe the pre-requisites, access privileges, and other configuration required for using Local Data Processing to capture or integrate changes into sources and targets locations (also called as the location types), listed below.