Hub Repository Database Requirements

Fivetran HVR uses its repository database to store the replication definitions (which tables must be replicated between which 'locations') as well as run-time status (which jobs are currently running).

In the repository database, the information is stored in the repository tables. HVR supports the creation of repository database on certain DBMSs only. For the list of supported DBMSs, see section Repository Database in Capabilities.

Topics

The following sections describe the pre-requisites, access privileges, and other configuration required for using the supported DBMS as repository database.

• Repository Database in Aurora MySQL
• Repository Database in Aurora PostgreSQL
• Repository Database in Azure SQL Database
• Repository Database in Azure SQL Managed Instance
• Repository Database in Db2 for Linux, Unix and Windows
• Repository Database in MariaDB
• Repository Database in MySQL
• Repository Database in Oracle
• Repository Database in PostgreSQL
• Repository Database in SQL Server
• Repository Database in Sybase ASE