Teradata Data Mover Portlet: Create your first job

Teradata Data Mover (version 13.10) introduced a graphical user interface component (Portlets) that allows users a more intuitive way to copy database objects from one Teradata database system to another. The Portlet component compliments and enhances the existing ‘command line’ component. It is deployed on Teradata Viewpoint Web portal & gives users an opportunity to manage Data Mover jobs from the convenience of a Web browser. 

Please refer to the following article for architecture on Teradata Data Mover

Two Data Mover Portlets are deployed to the Teradata Viewpoint portal during TDM Portlet installation. The two Portlets are:

1. Teradata Data Mover Portlet (TDM Portlet): Through this portlet, a user creates/manages Data Mover jobs. The first screen when logging on to the Viewpoint portal will be referred to as the ‘Saved Jobs’ screen <see Image 1>
2. Teradata Data Mover Setup Portlet (TDMS Portlet): Through this Portlet, a user can manage TDM Daemon configuration. <see Image 2>

Image 1.

Image 2.

Creating your first job via TDM Portlet

After the quick overview above, let’s go through the steps to create/execute a TDM job via the Portlet. 

We will be leveraging an existing article to create and populate a table for this exercise. In the Introduction to Data Mover article.  Scroll down to ‘Create your first TDM job’ section, and create/populate the ‘item1’ table.

Storing credentials in Preferences

Now that the ‘item1’ table is successfully created under user ‘jg185041’ on teradata system ‘dmdev’, click on the on the top-right of the TDM Portlet.

After clicking on the wrench, you should see the screen below

The preferences screen allows user to add/store teradata systems and its respective credentials for future use. In our case, we will add dmdev (source system) and dmsmp (target system) to the preferences list & click on ok.

Selecting Table in Object Browser

Once the credentials have been added, click on the ‘New Job’ link on the top right of the ‘Saved Jobs’ screen. A user will always start the process of creating a new job via the 'New Job' link.

Clicking on the ‘New Job’ takes us to the screen below. The user needs to select a system from the 'Source' drop down list for an object browser to appear.

Select dmdev as Source & dmsmp as Target.  It should display the 'DBC' database in tree format.

Click on the  right next to DBC.  This will expand the object tree. Find the user jg185041 either by scrolling or using the filter. Expand on the  right next to jg185041.  You should see the screen below.

Notice that there are no tables under jg185041. The objects shown to the user depends on the settings of the object selector. The object selector  is located next to filter. Clicking on will display the following screen.

Select Table (You should see a green checkmark similar to the one next to ‘User’) from the object selector list. Move the mouse pointer away from the object selector list after selection (this way the selector list will disappear and the selected object types will appear on the object tree).

To copy objects, users have to select the object by clicking on  next to the object. In our exercise, select items1 table by clicking on the next to it. It should have checkmark like this

Clicking on the ‘Job Summary’ Tab will display all the selected objects and its respective sizes for users.  In our exercise, we see 'items1' with approximate size 76K

Clicking on Save button on the bottom right of TDM Portlet will display another screen asking user to enter the job name. The job name we will enter for our exercise is devx_portlet.

Clicking on Save button on the bottom center will save the job. A user will see an error modal window if there are any errors when creating a job.  Otherwise, the job name will be populated in the ‘Saved Jobs’ screen.

You have successfully created a job via the TDM Portlet. Let’s continue and execute the job.

Running a Data Mover job

Hover your mouse on top of devx_portlet on the screen. You will see a context menu button  appear next to devx_portlet. 

Click on . You will see a context menu with options. These options are 'commands' that you can execute on a particular job.

Select & click on Run on the context menu.  You will see a ‘Job Status’ screen. The ‘Job Status’ screen updates itself in a timely manner until a job has executed completely.  The progress bar on the center of the screen will display the percent of bytes that have been transferred as compared to total number of bytes of the objects in the job (the total number of bytes is an estimate & might change after the end of job to reflect the actual size). 

This concludes an exercise of creating and executing a job successfully via Data Mover Portlet. You should now be able to see the jg185041.items1 table on your target system.