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:
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.
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.
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.
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.
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?
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.