1 前言
目前GitHub上的DataX3.0开源版本,rdbms里面默认是达梦7的驱动,因此,如果像链接达梦8需要替换驱动。
2 驱动替换
1、下载Dm8JdbcDriver18-xxxx.jar,放到libs下面
2、修改maven依赖,注释dm7的驱动,改成达梦8
<dependency>
<groupId>com.dameng</groupId>
<artifactId>Dm8JdbcDriver18</artifactId>
<version>8.1.1.49</version>
<scope>system</scope>
<systemPath>${basedir}/src/main/libs/Dm8JdbcDriver18-8.1.1.49.jar</systemPath>
</dependency>
<!-- <dependency>-->
<!-- <groupId>com.dm</groupId>-->
<!-- <artifactId>dm</artifactId>-->
<!-- <scope>system</scope>-->
<!-- <systemPath>${basedir}/src/main/libs/Dm7JdbcDriver16.jar</systemPath>-->
<!-- </dependency>-->
<dependencyManagement>
<dependencies>
<dependency>
<groupId>com.dameng</groupId>
<artifactId>Dm8JdbcDriver18</artifactId>
<version>8.1.1.49</version>
</dependency>
</dependencies>
</dependencyManagement>
3、重新打包编译
mvn -U clean package assembly:assembly -Dmaven.test.skip=true
3 读写达梦8的任务模板json
1、从达梦8读取写入到MySQL5.7模板
{
"job": {
"setting": {
"speed": {
"channel": 3
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [
{
"reader": {
"name": "rdbmsreader",
"parameter": {
"column": ["ID","USERNAME","PASSWORD"],
"connection": [
{
"jdbcUrl": ["jdbc:dm://10.252.xx.xxx:15236?schema=SYSDBA"],
"table": ["TEST_DATAX"]
}
],
"password": "SYSDBA001",
"username": "SYSDBA"
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"print":true,
"column": [
"id",
"username",
"password"
],
"connection": [
{
"jdbcUrl": "jdbc:mysql://10.252.xxx.xx:30006/test_datax_dm?useSSL=false&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai",
"table": ["test_datax"]
}
],
"password": "root",
"username": "root"
}
}
}
]
}
}
2、从MySQL5.7读取写入到达梦8模板
{
"job": {
"setting": {
"speed": {
"channel": 3
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "root",
"column": [
"id",
"username",
"password"
],
"connection": [
{
"table": [
"test_datax"
],
"jdbcUrl": [
"jdbc:mysql://10.252.xxx.xx:30006/test_datax_dm?useSSL=false&allowPublicKeyRetrieval=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai"
]
}
]
}
},
"writer": {
"name": "rdbmswriter",
"parameter": {
"column": ["ID","USERNAME","PASSWORD"],
"connection": [
{
"jdbcUrl": "jdbc:dm://10.252.xx.xxx:15236?schema=SYSDBA",
"table": ["TEST_DATAX"]
}
],
"password": "SYSDBA001",
"username": "SYSDBA",
"preSql": [],
"session": []
}
}
}
]
}
}
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。
文章由极客之音整理,本文链接:https://www.bmabk.com/index.php/post/71328.html