1 下载
http://datax-opensource.oss-cn-hangzhou.aliyuncs.com/datax.tar.gz
2 直接解压使用
tar zxvf datax.tar.gz -C /opt/
3 配置各种json
oracle到mysql的o2m.json
{
"setting": {},
"job": {
"setting": {
"speed": {
"channel": 2
}
},
"content": [
{
"reader": {
"name": "oraclereader",
"parameter": {
"column": ["*"],
"connection": [
{
"jdbcUrl": ["jdbc:oracle:thin:@192.168.x.x:1521:orcl"],
"table": ["hello.a_info"]
}
],
"password": "hello",
"username": "hello"
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"column": ["*"],
"connection": [
{
"jdbcUrl": "jdbc:mysql://192.168.x.x:3306/oracle_x?useUnicode=true",
"table": ["a_info"]
}
],
"writeMode": "insert",
"password": "hellomysql",
"username": "hellomysql"
}
}
}
]
}
}
4 运行
python datax.py o2m.json
等执行完毕检查数据是否一致。
注:
1 mysql版本号
5.7 与8 需要修改对应的
/plugin/writer/mysqlwriter/libs/mysql-connector-java-5.1.34.jar
其余不需要修改。
而mysql需要建库建表。
select dbms_metadata.get_ddl('TABLE','') from dual
5 类似配置oracle2hdfs.json, oracle2txt.json等