进入rdbmsreader对应目录,如下所示:
在rdbmsreader插件目录下有plugin.json配置文件,在此文件中注册vertica的数据库驱动
{
"name": "rdbmsreader",
"class": "com.alibaba.datax.plugin.reader.rdbmsreader.RdbmsReader",
"description": "useScene: prod. mechanism: Jdbc connection using the database, execute select sql, retrieve data from the ResultSet. warn: The more you know about the database, the less problems you encounter.",
"developer": "alibaba",
"drivers":["dm.jdbc.driver.DmDriver", "com.sybase.jdbc3.jdbc.SybDriver", "com.edb.Driver", "**com.vertica.jdbc.Driver**"]
}
进入libs目录,将vertica驱动放进去,具体路径如下:
本次测试用vertica驱动为 vertica-jdbc-9.2.0-0.jar
下载链接: https://www.vertica.com/download/vertica/client-drivers/
以上配置在rdbmswriter目录下再配置一次
修改plugin.json文件,加入vertica驱动
按照datax给出的writer驱动放置到响应libs目录中,测试有问题,会提示 No suitable driver found for jdbc:vertica
,找不到驱动
后将驱动放在 datax根目录下的lib目录内,解决该问题
完成
参考链接:
https://github.com/alibaba/DataX/blob/master/rdbmsreader/doc/rdbmsreader.md
https://ask.csdn.net/questions/686214?sort=id