Teradata as Source

Capture is not supported from Teradata location.

Compare and Refresh from Teradata

Fivetran HVR allows you to perform only Compare and Refresh from Teradata location. This section describes the configuration requirements for performing only Compare and Refresh from Teradata location.

Grants for Compare and Refresh from Teradata

This section lists the grants required for performing only Compare and Refresh from Teradata location.

To read from Teradata location, the HVR database User must be granted the select privilege.
```
grant select on targetdb to username;
```

Requirements for Selecting Views

Since HVR version 6.3.0 onward, QVCI (Queryable View Column Index) is no longer required for selecting views on Teradata.

On versions earlier than 6.3.0, HVR requires QVCI to be enabled for selecting views on Teradata. When QVCI is disabled, HVR cannot query the Teradata system metadata for views, the views do not appear in the table list, and you cannot add them to the channel. HVR returns the following error when you try to add views to a channel: F_JD22A1 DBMS error [(-9719)QVCI feature is disabled].