Repository Database in Azure SQL Managed Instance

Fivetran HVR allows you to create repository database in Azure SQL Managed Instance.

It is recommended to create a new database (schema) for HVR repository. If an existing database is to be used for HVR repository, then the HVR repository tables can be separated by creating a new database schema and associating it with HVR's user as follows:

create schema schemaname;

Grants for Repository Database

The following grants are required for the repository database user in Azure SQL Managed Instance:

grant create table to username;
grant create procedure to username;
grant select, insert, delete, update on schema::schemaname to username;
grant control on schema::schemaname to username;
alter user username with default_schema=schemaname;

Repository Database Connection

This section describes the details required for connecting to the repository database in Azure SQL Managed Instance:

Advanced Settings