datax实现mysql数据同步到oracle

一、mysql数据同步到oracle

注意：mysql不区分大小写，但是oracle严格区分大小写，并且oracle的库名、表名和字段名要用大写，如果用的小写需要添加双引号说明。

{

“job”: {

“setting”: {

“speed”: {“byte”: 1048576}

},

“content”: [

{

“reader”: {

“name”: “mysqlreader”,

“parameter”: {

“column”: [

“sjh” ,

“xm” ,

“sfzh”

],

“connection”: [

{

“jdbcUrl”: [“jdbc:mysql://127.0.0.1:3306/test”],

“table”: [“test1”]

}

],

“password”: “111111”,

“username”: “root”

}

},

“writer”: {

“name”: “oraclewriter”,

“parameter”: {

“username”: “test”,

“password”: “111111”,

“column”: [

““sjh”” ,

““xm”” ,

““sfzh””

],

“connection”: [

{

“jdbcUrl”: “jdbc:oracle:thin:@[192...*]:1521:ORCL”,

“table”: [

"“test1"”

]

}

]

}

}

}

]

}

}