datax oracle mysql_使用dataX将数据从Mysql数据库同步到Oracle数据

最近有需求将数据从mysql同步到oracle，之前有使用kettle将表从oracle同步到mysql，这里使用的插件依然是阿里的dataX

这里也是根据阿里云的一篇帖子来进行验证

https://yq.aliyun.com/articles/715393?spm=a2c4e.11155472.0.0.3aef4dc1IWo28F

1 环境需要

JDK(1.8以上，推荐1.8)

Python(推荐Python2.6.X)

Apache Maven 3.x (Compile DataX)

2 #服务器配置

[[email protected] ~]#yum search java|grep jdk

[[email protected] ~]#yum install java-1.8.0-openjdk.x86_64 -y

[[email protected] ~]#java -version

openjdk version "1.8.0_242"OpenJDK Runtime Environment (build1.8.0_242-b07)

OpenJDK64-Bit Server VM (build 25.242-b07, mixed mode)

[root@yhq ~]#python --version

Python 2.6.6下载地址：https://maven.apache.org/download.cgi

[root@yhq soft]#ls apache-maven-3.6.3-bin.tar.gz

apache-maven-3.6.3-bin.tar.gz

[root@yhq soft]#tar -zxvf apache-maven-3.6.3-bin.tar.gz

[[email protected] soft]#mkdir /opt/maven

[[email protected] soft]#mv apache-maven-3.6.3/* /opt/maven/

[[email protected] soft]#ln -s /opt/maven/b

bin/ boot/[root@yhq soft]#ln -s /opt/maven/bin/mvn /usr/bin/mvn

[[email protected] soft]#vim /etc/profile.d/maven.sh

export M2_HOME=/opt/maven

export PATH=${M2_HOME}/bin:${PATH}[root@yhq soft]#mvn -v

Apache Maven 3.6.3(cecedd343002696d0abb50b32b541b8a6ba2883f)

Maven home:/opt/maven

Java