Resumen
La API RESTful move mueve el trabajo especificado mediante la URL y el método siguientes:
| Elemento | Descripción | ||
|---|---|---|---|
| URL | /datamover/executingJobs | ||
| Método | POST | ||
Parámetros de solicitud
- jobName
- Descripción: Nombre del trabajo
- sync
- Descripción: especificación de uso de la sincronización Si la sincronización es false (predeterminada), el comando start devolverá el estado una vez se haya generado el nombre de ejecución del trabajo. Si la sincronización es true, el comando start devolverá el estado cuando se complete el trabajo.
- uowid
- Descripción: ID de unidad de trabajo
- saveChanges
- Descripción: actualiza la definición del trabajo original con los parámetros especificados.
- sourceLogin
- Descripción: Propiedades del sistema de origen
- targetLogin
- Descripción: Propiedades del sistema de destino
- settings
- Descripción: Propiedades de configuración del trabajo
- jobSecurity
- Descripción: Detalles de seguridad del trabajo
- objects
- Descripción: Objetos que se van a copiar
Ejemplos de solicitud
{
"jobName": "tdToTdJob",
"sourceLogin":
{
"teradata":
{
"tdpid": "sourceSystem",
"username": "user",
"password": "password",
"sessionCharset": "UTF8",
"passwordEncrypted": "false"
}
},
"targetLogin":
{
"userPool": "poolA"
},
"settings":
{
"priority": "MEDIUM",
"overwriteExistingObjects": "true",
"freezeJobSteps": "false",
"targetDatabase": "targetDatabaseJobLevel",
"compareDDL": "true",
"logLevel": "99",
"tdTdSettings":
{
"forceUtility": "DSA",
"dataStreams": 5,
"sourceSessions": 10,
"targetSessions": 10,
"onlineArchive": "false"
}
},
"jobSecurity":
{
"ownerName": "user10",
"readPermission": {
"users" : [ "user1", "user2", "user3" ],
"roles" : [ "role1", "role2", "role3" ]
},
"writePermission": {
"users" : [ "user1", "user2", "user3" ],
"roles" : [ ]
},
"executePermission": {
"users" : [ "user1", "user3" ],
"roles" : [ "role1"]
}
},
"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",
"forceTargetStagingTable": "true",
"selection": "included",
"exportWithoutSpool": "false",
"stagingToTarget":"DELETE_INSERT"
},
{
"name": "srcTableB",
"compareDDL": "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"
}
]
"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"
}
],
"journal":
[
{
"name": "journal",
"database": "journalDB",
"selection": "included"
}
],
"macro":
[
{
"name": "macroA",
"database": "macroDB",
"selection": "included"
},
{
"name": "macroB",
"database": "macroDB",
"selection": "included"
}
],
"storedProcedure":
[
{
"name": "storedProcedureA",
"database": "storedProcedureDB",
"selection": "included"
},
{
"name": "storedProcedureB",
"database": "storedProcedureDB",
"selection": "included"
}
]
}
]
}