seatunnel各类型数据库同步配置

有戏说戏

已于 2025-01-21 13:28:07 修改

阅读量533

点赞数 13

分类专栏：大数据文章标签：数据库大数据

于 2025-01-21 09:46:26 首次发布

本文链接：https://blog.youkuaiyun.com/qq_26875961/article/details/145276503

版权

我是在dolphinscheduler调度器中使用seatunnel，在资源中心中创建对应的同步配置文件。

一、DB2同步数据到MySQL

env {
  execution.parallelism = 2
  job.mode = "BATCH"
}
source{
    Jdbc {
        url = "jdbc:db2://127.0.0.18:50000/db"
		driver = "com.ibm.db2.jcc.DB2Driver"
        connection_check_timeout_sec = 100
        user = "user"
        password = "password"
        query = "select * from table"
    }
}

transform {
    
}

sink {
    jdbc {
        url = "jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&useSSL=false"
        driver = "com.mysql.cj.jdbc.Driver"
        user = "user"
        password &