列出作业定义 (RESTful API) - Teradata Data Mover

Teradata® Data Mover 用户指南

Product
Teradata Data Mover
Release Number
16.20
Published
2021 年 11 月
Language
中文 (简体)
Last Update
2021-12-02
dita:mapPath
zh-CN/wph1512683331242.ditamap
dita:ditavalPath
zh-CN/mpm1591127278842.ditaval
dita:id
B035-4101
Product Category
Analytical Ecosystem

用途

使用以下 URL 和方法显示作业定义︰
说明
URL /datamover/jobs/job-name
方法 GET

请求参数

没有必需的请求参数。

响应参数

jobName
说明︰作业名称
JSON 数据类型︰字符串
uowid
说明:工作单元 ID
JSON 数据类型︰字符串
sourceLogin
说明︰源系统属性
JSON 数据类型︰对象 (LoginType)
targetLogin
说明︰目标系统属性
JSON 数据类型︰对象 (LoginType)
settings
说明︰作业配置属性
JSON 数据类型︰对象 (SettingsType)
objects
说明︰要复制的对象
JSON 数据类型︰对象 (DbObjectType)
jobSecurity 详细信息不会显示在 list job definition 中,即使创建或编辑作业时提供了 jobSecurity 详细信息也是如此。

响应示例(Teradata 到 Teradata 用户池)

{
    "jobName": "tdToTdJob",
    "sourceLogin":
    {
        "teradata":
        {
            "tdpid": "sourceSystem",
            "username": "user",
            "password": "",
            "sessionCharset": "UTF8",
            "passwordEncrypted": "false"
        }
    },
    "targetLogin":
    {
        "userPool": "poolA"
    },
    "settings":
    {
        "priority": "MEDIUM",
        "overwriteExistingObjects": "true",
        "freezeJobSteps": "false",
        "targetDatabase": "targetDatabaseJobLevel",
        "compareDDL": "true",
        "logLevel": "99",
        "tdTdSettings":
        {
            "forceUtility": "ARC",
            "dataStreams": 5,
            "sourceSessions": 10,
            "targetSessions": 10,
            "onlineArchive": "false"
        }
    },
    "objects":
        {
            "database":
            [
                {
                    "name": "sourceDb",
                    "compareDDL": "false",
                    "journaling": "false",
                    "replaceDatabase": "false",
                    "selection": "unselected",
                    "table":
                    [
                        {
                            "name": "srcTableA",
                            "stagingDatabase": "stagingDBA",
                            "stagingDatabaseForTable": "stagingDBAB",
                            "targetDatabase": "targetDBA",
                            "targetName": "tgtTableA",
                            "validateRowCount": "ALL",
                            "compareDDL": "false",
                            "useExistingTargetTable": "false",
                            "forceTargetStagingTable": "true",
                            "selection": "included",
                            "exportWithoutSpool": "false"
                        },
                        {
                            "name": "srcTableB",
                            "compareDDL": "true",
                            "useExistingTargetTable": "true",
                            "selection": "included",
                            "exportWithoutSpool": "true",
                            "partialTableParameters":
                            {
                                "sqlWhereClause": "where columnA < 100",
                                "keyColumns":
                                [
                                    "columnA"
                                ]
                            },
                            "teradataParameters":
                            {
                                "copyStats": "false",
                                "allowTPTLoadMultiset": "true",
                                "journaling": "false",
                                "overrideLockAccess": "false"
                            }
                        }
                    ]
                }
            ],
            "trigger":
            [
                {
                    "database": "databaseA",
                    "subjectTableDatabase": "subjectDatabaseA",
                    "table": "tableA",
                    "name": "triggerA",
                    "actionTime":
                    {
                        "action": "AFTER",
                        "enabled": "NO"
                    },
                    "selection": "included"
                },
                {
                    "database": "databaseB",
                    "subjectTableDatabase": "subjectDatabaseB",
                    "table": "tableB",
                    "name": "triggerB",
                    "actionTime":
                    {
                        "action": "AFTER",
                        "enabled": "YES"
                    },
                    "selection": "included"
                }
            ],
            "view":
            [
                {
                    "name": "ViewA",
                    "database": "ViewDatabase",
                    "viewDataTable":
                    {
                        "targetTable": "tableA",
                        "targetDatabase": "dbA"
                    },
                    "compareDDL": "false",
                    "selection": "included",
                    "copyData": "false"
                },
                {
                    "name": "ViewB",
                    "database": "ViewDatabaseB",
                    "viewDataTable":
                    {
                        "targetTable": "tableA",
                        "targetDatabase": "dbA"
                    },
                    "compareDDL": "false",
                    "forceTargetStagingTable": "true",
                    "selection": "included",
                    "copyData": "false"
                }
            ],
            "foreignServer":
            [
                {
                    "name": "foreignServer1",
                    "selection": "included"
                },
                {
                    "name": "foreignServer2",
                    "selection": "included"
                }
            ],
            "functionAliases":
            [
                {    
                   "name": "faObj",
                   "database": "dmguest",
                   "selection": "included"
                },
                {
                   "name": "FAObjForForeignSer",
                   "database": "myDB",
                   "selection": "included"
                }
            ]
            "journal":
            [
                {
                    "name": "journal",
                    "database": "journalDB",
                    "selection": "included"
                }
            ],
            "macro":
            [
                {
                    "name": "macroA",
                    "database": "macroDB",
                    "selection": "included"
                },
                {
                    "name": "macroB",
                    "database": "macroDB",
                    "selection": "included"
                }
            ],
            "indices":
            [
                {
                    "name": "OrdersHI",
                    "indexDatabase": "indexDB",
                    "indexType": "hash_index",
                    "selection": "included"
                },
                {
                    "name": "sji",
                    "indexDatabase": "indexDB",
                    "indexType": "join_index",as
                    "copyStats": true,
                    "selection": "included"
                }
            ],
            "schema":
            [
                {
                    "name": "avroRecordSchema",
                    "compareDDL": true,
                    "selection": "included"
                }
            ],
            "storedProcedure":
            [
                {
                    "name": "storedProcedureA",
                    "database": "storedProcedureDB",
                    "selection": "included"
                },
                {
                    "name": "storedProcedureB",
                    "database": "storedProcedureDB",
                    "selection": "included"
                }
            ]
        }

响应示例(Teradata 到 Hadoop)

{  
   "jobName":"tdToHadoopJob",
   "sourceLogin":{  
      "userPool": "poolA"
   },
   "targetLogin":{  
      "hadoop":{  
         "webhcatURL":"http://zircon1.labs.teradata.com:50111",
         "fileSystemURL":"http://zircon1.labs.teradata.com:50070",
         "oozieURL":"http://zircon1.labs.teradata.com:11000",
         "username":"hive",
         "passwordEncrypted":"false"
      }
   },
   "setting":{  
      "priority":"MEDIUM",
      "overwriteExistingObjects":"true",
      "freezeJobSteps":"false",
      "compareDDL":"true",
      "tdHadoopSettings":{  
         "forceUtility":"SQLH",
		 "foreignServer" : "ForeginServerForSQLH",
         "fileOptions":"text",
         "columnDelimiter":"|",
         "batchInsertSize":0,
         "mappers":10
      }
   },
   "objects":{  
      "database":[  
         {  
            "name":"sourceDb",
            "compareDDL":"false",
            "journaling":"false",
            "replaceDatabase":"false",
            "selection":"unselected",
            "table":[  
               {  
                  "name":"srcTableA",
                  "targetName":"tgtHadoopTableA",
                  "compareDDL":"false",
                  "useExistingTargetTable":"false",
                  "selection":"included",
                  "exportWithoutSpool":"false",
                  "column":[  
                     {  
                        "name":"lastName",
                        "targetName":"surname",
                        "targetType":"String",
                        "allowNull":"false",
                        "allowDuplicate":"false",
                        "primaryIndex":"false"
                     },
                     {  
                        "name":"Street number",
                        "targetType":"int",
                        "allowNull":"false",
                        "allowDuplicate":"false",
                        "primaryIndex":"false"
                     }
                  ],
				  "partialTableParameters":{  
                     "sqlWhereClause":"WHERE id > 4"
                  }
               }
            ]
         }
      ],
      "view":[  
         {  
            "name":"sourceViewA",
            "database":"sourceDB",
            "viewDataTable":{  
               "targetTable":"targetTableToStoreViewData",
               "targetDatabase":"targetDB"
            },
            "validateRowCount":"PARTIAL",
            "useSourceStagingTable":false,
            "forceTargetStagingTable":false,
            "partialTable":{  
               "sqlWhereClause":"WHERE id>1"
            },
            "selection":"unselected",
            "copyData":true
         }
      ]
   }
 }