Teradata supplies several table operators to import and export data to and from remote systems:
- QGRemoteImport
- QGRemoteExport
- QGInitiatorImport
- QGInitiatorExport
Teradata also provides the QGExecuteForeignQuery table operator to enable DDL and DCL actions on a remote system, such as the following:
- CREATE
- ALTER
- DROP
- GRANT
- REVOKE
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 QueryGrid connector package.