DataX将Oracle数据库数据同步到达梦数据库
1.DataX3.0开源版本,rdbms里面默认是达梦7的驱动,因此,如果像链接达梦8需要替换驱动。需要将达梦8的驱动放在D:\datax\lib、D:\datax\plugin\reader\rdbmsreader\lib和D:\datax\plugin\reader\rdbmswriter\lib下
D:\datax\plugin\reader\rdbmsreader\plugin.json和D:\datax\plugin\reader\rdbmswriter\plugin.json 确保达梦驱动名在列表中
{ "job": { "setting": { "speed": { "channel": 5 } }, "content": [ { "reader": { "name": "oraclereader", "parameter": { "username": "yonghuming", "password": "mima", "column": [ "*" ], "connection": [ { "table": [ "table1" ], "jdbcUrl": [ "jdbc:oracle:thin:@127.0.0.1:1521:oracledb" ] } ] } }, "writer": { "name": "rdbmswriter", "parameter": { "column": [ "*" ], "connection": [ { "jdbcUrl": "jdbc:dm://127.0.0.1:5236?schema=dmdb", //没有schema默认用相同用户名的schema "table": [ "table1" ] } ], "username": "yonghuming" "password": "mima" } } } ] } }