Overview
You need a valid cloud staging area for creating a cloud staging copy Job. To create a cloud staging copy Job add a cloudStagingArea object inside the settings object of the request JSON. Make sure that the object specifies a valid cloud staging area for the job.
Create a cloud staging copy job using the following URL and method:
| Item | Description | ||
|---|---|---|---|
| URL | /datamover/jobs | ||
| Method | POST | ||
Request Parameters
- jobName
- Description: Name of the job
- uowind
- Description: Unit of work id
- sourceLogin
- Description: Properties of the source system
- targetLogin
- Description: Properties of the target system
- settings
- Description: Properties of the job configuration
- jobSecurity
- Description: Job security details
- objects
- Description: Objects to be copied
Response Parameters
No response parameters required.
Response Example
{
"error":"job creation failed, table does not exist in source database"
}
Request Example
{
"jobName": "DMCSJob",
"sourceLogin": {
"teradata": {
"username": "user",
"password": "password",
"tdpid": "sourceSystem",
"sessionCharset": "UTF8",
"passwordEncrypted": "false"
}
},
"targetLogin": {
"teradata": {
"username": "user",
"password": "password",
"tdpid": "targetSystem"
},
"useTargetUserIdPool": false
},
"settings": {
"priority": "MEDIUM",
"overwriteExistingObjects": "true",
"freezeJobSteps": "false",
"targetDatabase": "targetDatabaseJobLevel",
"compareDDL": "true",
"logLevel": "99",
"tdTdSettings":
{
"forceUtility": "DSA",
"dataStreams": 5,
"sourceSessions": 10,
"targetSessions": 10,
"onlineArchive": "false"
},
"enableTraceLog": {
"cliTraceLog": {
"netrace": -1,
"netraceBufLen": -1
},
"tptTraceLog": {
"tptapiDebug": -1
}
},
"cloudStagingArea": {
"name": "CSArea"
},
"enableIncrementalRestore": "FALSE"
},
"objects": {
"database": [{
"name": "dm19948",
"selection": "UNSELECTED",
"table": [{
"name": "testtable",
"ownerName": "devuser",
"useSourceStagingTable": false,
"forceTargetStagingTable": false,
"targetDatabase": "test",
"targetName": "test",
"validateRowCount": "NONE",
"selection": "INCLUDED",
"teradataParameters": {
"allowTPTLoadMultiset": false,
"overrideLockAccess": false
}
}]
}]
}
}