dataX linux环境部署:
1 参考文章: https://blog.csdn.net/Titanium_LL/article/details/100859499
2 环境参数:centos7
3 crontab定时任务参考https://www.pianshen.com/article/8309173488/
crontab不执行报错解决:
解决 sh: java: command not found 问题
在执行脚本上加入如下配置即可
#!/bin/bash
JAVA_HOME=/usr/java/jdk1.8.0_152
export PATH=$PATH:$JAVA_HOME/bin
示例:
1 test_datax.json里面内容:
{
"job": {
"setting": {
"speed": {
"channel": 1
}
},
"content": [
{
"reader": {
"name": "oraclereader",
"parameter": {
"username": "mobile_inoculate_in",
"password": "123",
"where": "",
"connection": [
{
"querySql": [
"select id,name,remark from TEST_DATAX where id>=1"
],
"jdbcUrl": [
"jdbc:oracle:thin:@192.168.200.16:1521/dev"
]
}
]
}
},
"writer": {
"name": "oraclewriter",
"parameter": {
"username": "declare_inoculate_in",
"password": "123",
"column": [
"id",
"name",
"remark"
],
"preSql": [
"delete from TEST_DATAX where id >=1"
],
"connection": [
{
"jdbcUrl": "jdbc:oracle:thin:@192.168.200.16:1521/dev",
"table": [
"TEST_DATAX"
]
}
]
}
}
}
]
}
}
2 cron_test_datax.sh创建内容:
#!/bin/sh
. /etc/profile
python /usr/local/datax/bin/datax.py /usr/local/datax/job/test_datax.json >> /usr/local/crontab/log/test_datax.`date +\%Y\%m\%d\%H\%M\%S`.log 2>&1