Teradata supplies several table operators to import and export data to and from remote systems:
Teradata also provides the QGExecuteForeignQuery table operator to enable DDL and DCL actions on a remote system, such as the following:
These table operators are activated from DIP.
ExecuteForeignSQL is a stored procedure that provides a simple interface for the users to run basic SQL queries. ExecuteForeignSQL and an install script are provided as part of the Teradata QueryGrid connector package.