一、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"”
]
}
]
}
}
}
]
}
}