Create Event Table | RESTful API | Teradata Data Mover - 17.11 - Create Event Table (RESTful API) - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)

Overview

Create a new event table using the following URL and method:
Item Description
URL /datamover/event-tables
Method POST

Request Parameters

event_table_id
Description: Unique ID for the event table
JSON Data Type: String
Required: Yes
event_table_host
Description: Name of the external Teradata host to place the event table
JSON Data Type: String
Required: Yes
event_table_parent_database
Description: Name of the parent database where the TMSMEvent table is to be created
JSON Data Type: String
Required: Yes
host_user_name
Description: Teradata user name used to access event_table_host and create the TMSMEvent table. This user name is also used to access the event table when inserting events.
JSON Data Type: String
Required: Yes
host_user_password
Description: Password for host_user_name
JSON Data Type: String
Required: Yes
use_existing_event_table
Description: Name of the existing TMSMEvent on host in parent database to use to create a new event table.
JSON Data Type: String
Required: No

Response Parameters

event_table_id
Description: The same event table ID provided in the request body
JSON Data Type: String
message
Description: Message explaining success or failure
JSON Data Type: String

Response Examples

{
"event_table_id" : "test1",
"message" : "Created Table st_stg_dm_user.TMSMEVENT on system td1 "
}
{
"message" : "Must provide event_table_id in JSON Body Request."
}
{
"event_table_id" : "event1",
"message" : "Error: problem querying system td1 for existing tmsmEvent in database DM1 Cause: Error creating data source for td1/event1. Cause: Error while creating data source for td1/event1/Cannot create PoolableConnectionFactory ([Teradata Database] [TeraJDBC 16.20.00.10] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.) "
}