To use Teradata sources in database ingestion and replication tasks, first prepare the source database and review the usage considerations.
Source preparation
•To deploy and run a database ingestion and replication task that includes a Teradata source, the source connection must specify a database user who has the privileges that are required to perform an initial load operation. Use the following SQL statements to grant these privileges to the user:
GRANT SELECT ON database_name TO user_name/user_role;
Usage considerations
•Database ingestion and replication jobs that have a Teradata source can have any target type except for PostgreSQL and SQL Server.
•Database Ingestion and Replication does not support the following Teradata data types:
- ARRAY
- BLOB
- CLOB
- JSON
- ST_GEOMETRY
- XML
For information about the default mappings of supported source data types to target data types, see Default data-type mappings.