Wiki Admin

Teradata as Source - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Teradata as Source - DSS 6 | Data Source Solutions Documentation

Teradata as Source

Capture is not supported from Teradata location.

Compare and Refresh from Teradata

Data Source Solutions DSS 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 DSS database User must be granted the <b>select</b> privilege.
    grant select on <em>targetdb</em> to <em>username</em>;

Requirements for Selecting Views

Since DSS 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, DSS requires QVCI to be enabled for selecting views on Teradata. When QVCI is disabled, DSS 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. DSS returns the following error when you try to add views to a channel: F_JD22A1 DBMS error [(-9719)QVCI feature is disabled].