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
- event_table_host
- Description: Name of the external Teradata host to place the event table
- event_table_parent_database
- Description: Name of the parent database where the TMSMEvent table is to be created
- 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.
- host_user_password
- Description: Password for host_user_name
- use_existing_event_table
- Description: Name of the existing TMSMEvent on host in parent database to use to create a new event table.
Response Parameters
- event_table_id
- Description: The same event table ID provided in the request body
- message
- Description: Message explaining success or failure
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.) "
}