Teradata Data Mover Portlet: Create your first job

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

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>

Empty Saved Jobs screen

Image 1.

Data Mover Setup Portlet

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 viewpoint preference wrenchon the top-right of the TDM Portlet.

TDM Portlet wrench

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

TDM Preference

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.

TDM Preferences user input

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.

TDM Portlet saved jobs new job

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.

TDM Portlet object browser

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

TDM Portlet object browser source_target 

Click on the TDM Portlet object browser tree expand 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.

TDM Portlet object browser filtered user

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 TDM Portlet object browser obj selector is located next to filter. Clicking on TDM Portlet object browser obj selector will display the following screen.

TDM Portlet object browser obj selected

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).

TDM Portlet object browser tables expanded

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

TDM Portlet object browser table selected

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

TDM Portlet job summary

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.

TDM Portlet save settings

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.

TDM Portlet saved jobs 1 job

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 TDM Portlet context menu appear next to devx_portlet

TDM Portlet saved jobs context menu display

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

TDM Portlet context menu

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.

Tags (2)
3 REPLIES
Teradata Employee

Re: Teradata Data Mover Portlet: Create your first job

We have a problem because the Preferences "Wrench" icon is not present so we cannot enter the logon information that we need to identify the systems. Without that, we cannot begin the job definition step. What ViewPoint role/privilege do we need to get access to the Preferences.
N/A

Re: Teradata Data Mover Portlet: Create your first job

Thanks for the thorough description.

After creating connection systems / credentials initially, I went back to add a couple of different users, but they don't show up in the dropdown.  Is there a step I'm missing to get the new ones added to the list?

Re: Teradata Data Mover Portlet: Create your first job

Hello,

I have few questions and also need solutions for performing below process.

a. While doing full table copy..whether all objects asscoiated with the table also copied?

b. I would like to perform partial table copy (after full table copy), which only copy the data that has recent changes in the source system. How to perform this.

Any suggestions are highly appreciated.