{
"job": {
"setting": {
"speed": {
"channel": 3,
"byte": 1048576
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [
{
"reader": {
"name": "oraclereader",
"parameter": {
"username": "oracle数据库账号",
"password": "oracle数据库密码",
"connection": [
{
"querySql": [
"select id,name from 数据库表名"
],
"jdbcUrl": [
"jdbc:oracle:thin:@//127.0.0.1:1521/orcl"
]
}
]
}
},
"writer": {
"name": "elasticsearchwriter",
"parameter": {
"endpoint": "http://127.0.0.1:9200",
"accessId": "elastic",
"accessKey": "XXXXXX",
"index": "test_index",
"type": "_doc",
"cleanup": false,
"settings": {
"index": {
"number_of_shards": 1,
"number_of_replicas": 0
}
},
"discovery": false,
"batchSize": 10000,
"splitter": ",",
"column": [
{
"name": "id",
"type": "long"
},
{
"name": "name",
"type": "text"
}
]
}
}
}
]
}
}