Adding Database or File System Targets

Adding Database or File System Targets - Teradata Listener

Teradata® Listener™ User Guide

Product

Teradata Listener

Release Number

2.06

Published

August 2019

Language

English (United States)

Last Update

2019-08-30

dita:mapPath

yng1555531055816.ditamap

dita:ditavalPath

boe1555608925945.ditaval

dita:id

B035-2910

Product Category

Analytical Ecosystem

Source Owner, Administrator, Super User

You can add multiple targets for a single source.

Listener does not support insert of JSON data beyond 64000 bytes.

Complete system and target configuration with the following considerations:

Target Setting	Consideration
QueryGrid	Provide the Foreign Server. If you save the System Connection information, you cannot remove the QueryGrid option. You must create a new target without the QueryGrid option. QueryGrid targets cannot be changed to a JDBC target. You must create a new target. Each target must be mapped to a new table (a table that is not currently mapped to any target).
Shred Column, Custom Mapping	In From Source, enter valid JSON elements from your payload for each column. Listener does not support insert of JSON data beyond 64000 bytes. Delete unneeded columns. Add additional mapping using ADD MAPPING. For time series sequenced table, you must provide mapping for the 'td_seqno' column. If you do not provide mapping, the following error occurs: Data validation error: Column 'td_seqno' mapping should be provided For time series data, you can write to PTI tables in Teradata NewSQL Engine systems. When creating a target, you can either map to the TD_TIMECODE PTI table column or allow Listener to insert the TD_TIMECODE column value as the timestamp when the record is inserted in the Teradata NewSQL Engine system.

Target Setting

Consideration

QueryGrid

Provide the Foreign Server.
If you save the System Connection information, you cannot remove the QueryGrid option. You must create a new target without the QueryGrid option.
QueryGrid targets cannot be changed to a JDBC target. You must create a new target.
Each target must be mapped to a new table (a table that is not currently mapped to any target).

Shred Column, Custom Mapping

In From Source, enter valid JSON elements from your payload for each column.
Listener does not support insert of JSON data beyond 64000 bytes.
Delete unneeded columns.
Add additional mapping using ADD MAPPING.
For time series sequenced table, you must provide mapping for the 'td_seqno' column. If you do not provide mapping, the following error occurs:
Data validation error: Column 'td_seqno' mapping should be provided
For time series data, you can write to PTI tables in Teradata NewSQL Engine systems. When creating a target, you can either map to the TD_TIMECODE PTI table column or allow Listener to insert the TD_TIMECODE column value as the timestamp when the record is inserted in the Teradata NewSQL Engine system.