Set Up Event Table | Teradata Data Mover - Setting Up the Event Table - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
  1. Run the create_event_table command in the command-line interface using parameters in the table below:
    Parameter Example Value Description
    event_table_name event1 Label that uniquely identifies the installation of the Event table.
    system tdsys1 Name of the Teradata system where the Event table will be installed. This can be the IP address or system alias.
    user_name dmuser1 Existing Teradata user for the Teradata system. User creates the Event table and inserts the events. Data Mover stores the user information. User must have CREATE and INSERT permissions on the specified event_database.
    user_password dmuser1pass Password for the Teradata user associated with the user_name.
    event_database db1 Name of the database on the Teradata server where the Event table is created.
    use_existing_event_table false If an Event table already exists and this is set to true, Data Mover re-uses the existing table rather than create a new one.
    Example:
    datamove create_event_table -event_table_name event1 -system dmdev
    -user_name user1 -user_password user1Pass -event_database db1

    In the example above, Data Mover creates table db1.TMSMEvent on the Teradata database system dmdev using Teradata user user1. This installation is referred to as event1.

    The create_event_table command creates a table called TMSMEvent in the specified event_database. If the table already exists in the specified database and its schema is current, Data Mover re-uses the table. If no table exists, Data Mover creates a new one.