The following example shows the structure for creating a job, Teradata to Aster:
{
"jobName": "tdToAsterJob",
"sourceLogin":
{
"teradata":
{
"tdpid": "dmdev",
"username": "dbc",
"password": "dbc",
"sessionCharset": "UTF8",
"passwordEncrypted": "false"
}
},
"targetLogin":
{
"aster":
{
"systemName": "asterSystem",
"port": 2406,
"username": "aster",
"password": "aster",
"passwordEncrypted": "false"
}
},
"setting":
{
"priority": "MEDIUM",
"overwriteExistingObjects": "true",
"freezeJobSteps": "false",
"compareDDL": "true",
"tdAsterSettings":
{
"dataStreams": 0,
"sessions": 0,
"queryTimeout": 300,
"preserveColumnCase": "true",
"skipErrorRecords": "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",
"targetName": "tgtaAsterTableA",
"compareDDL": "false",
"useExistingTargetTable": "false",
"selection": "included",
"exportWithoutSpool": "false",
"asterParameters":
{
"targetSchemaName": "asterSchema",
"targetTableType": "Dimension",
"targetTableDistributionType": "distribute_by_hash",
"targetTableDistributionKeyColumn": "columnA"
}
},
{
"name": "srcTableB",
"compareDDL": "true",
"useExistingTargetTable": "true",
"selection": "included",
"exportWithoutSpool": "true"
}
]
}
]
}