Administration UI

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Administration UI

Once the EAR or WAR has been successfully deployed and configured on your Application Server you are now ready to use the TERAJMSA Administration UI. This tool can be used to accomplish various administrative tasks for TERAJMSA. These tasks include 1) Managing services and properties and 2) Managing the Environment Variables

Starting the Administration UI

  • To start the Administration UI , navigate to the following Root URL: http://HOST_NAME:PORT/terajmsa/Admin
    • HOST_NAME: The host name of your Application Server.
    • PORT: The port number for your Application Server.
  • You should see the following web page:

Figure 28: Logon page

  • At the logon page, enter a Teradata User name and password.
  • You should see the following web page:

Figure 29: Home page

Loader Management

Create Service

  • On the left navigation under [Loader] click on [Create Services].
  • Enter a unique Service ID.
  • Enter the JNDI name for the Source JMS queue or topic. For example: jmsqueues/default/MyQueue
  • Enter the Source JMS Connection Factory name. For example: jmsfactory/default/MyQCF
  • Select the source type: Queue, Durable Topic, or Non-Durable Topic
  • Enter the Target Teradata Table name. For example: MYTABLE
  • Enter the Target Connection Datasource name. For example: jdbc/MyDataSource
  • Click on the [Create] button

Figure 30: Create Service

Starting and Stopping a Service

  • On the left navigation under [Loader] click on [Display Services].
  • You should see a list of services along with the status (started or stopped)
  • To start a service, click on [Start] under [Action]

Figure 31: Display Services

Copy Service

  • On the left navigation under [Loader] click on [Copy Service].
  • Select a service from the [Copy From] list.
  • Enter a new Service ID in [Copy To] edit box.
  • Click on [Copy] button.

Figure 32: Copy Service

Manage Properties

  • On the left navigation under [Loader] click on [Manage Properties].
  • You should see a list of services.
  • To edit the properties for a service, click on [Edit] for the service.

Figure 33: Display Properties

  • Select [Rollback invalid format message to Queue/Topic] from the drop down list. Possible value is false, true.
  • Select [Format] from the drop down list. Possible Format types are VARIABLE, FIXED, XML.
  • Select [Action] from the drop down list. Possible Action is INSERT, UPDATE, DELETE, and UPSERT.
  • Enter a [Delimiter]. The Delimiter is only applicable for Format type XML.
  • Select the columns JMS Universal Connector will insert data into.
  • Click on the [->] button.
  • Click on the [Modify] button to save changes.

Figure 34: Manage Properties

Extractor Management

Create Service

  • On the left navigation under [Extractor] click on [Create Services].
  • Enter a unique Service ID.
  • Enter the Source Teradata Queue Table name. For example, MYQUEUETABLE.
  • Enter the Source Connection Datasource name. For example, jdbc/MyDataSource.
  • Enter the JNDI name for the Target JMS queue or topic. For example, jmsqueues/default/MyQueue.
  • Enter the Target JMS Connection Factory name. For example, jmsfactory/default/MyQCF.
  • Select the Target Type: Queue, or Topic.
  • Click on the [Create] button

Figure 35: Create Service

Starting and Stopping a Service

  • On the left navigation under [Extractor] click on [Display Services].
  • You should see a list of services along with the status (started or stopped)
  • To start a service, click on [Start] under [Action]

Figure 36: Display Services

Copy Service

  • On the left navigation under [Extractor] click on [Copy Service].
  • Select a service from the [Copy From] list.
  • Enter a new Service ID in [Copy To] edit box.
  • Click on [Copy] button.

Figure 37: Copy Service

Manage Properties

  • On the left navigation under [Extractor] click on [Manage Properties].
  • You should see a list of services.
  • To edit the properties for a service, click on [Edit] for the service.

Figure 38: Display Properties

  • Select the columns JMS Universal Connector will query data from for the message payload.
  • Select [Column contains XML] = [true or false] to make the Extractor treat the column value as xml or not.
  • Enter a [Name Space]. If the value is specified, the value of the default namespace will be set in the XML message.
  • Enter a [Delivery Mode]. The delivery mode in the JMS. ‘1’ represents non persistent and ‘2’ represents persistent.
  • Enter a [Priority]. The JMS defines ten levels of priority value, with 0 as the lowest priority and 9 as the highest. In addition, clients should consider priorities 0-4 as gradations of normal priority and priorities 5-9 as gradations of expedited priority.
  • Enter a [Time to Live]. Specify how long the message will last in the queue. The value ‘0’ represents unlimited.
  • Enter [Rows per Message]. The number of table rows used to construct one JMS message payload. (NOTE – only 1 Row per Message is allowed – See page 7)
  • If applicable, add message properties using [Add Property].
  • Click on the [Modify] button to save changes.

Figure 39: Create Properties

Error Log View

  • On the left navigation under [Loader] or [Extractor] click on [Display Services].
  • Click on [View] link in the right pane.
  • If ErrorFile displayed with “empty”, the message or record was rolled back to their source(jms queue/topic or TD queue table)
  • If ErrorFile displayed with “number”, the message is moved to the error file with displayed “number” with named number.xml – This is only for the Loader, the Extractor will not create the error file (it will always roll back)

Figure 40: Error Log View