分享程序员开发的那些事...
更新时间：2022-09-29 23:27:09
kettle与各数据库建立链接的链接字符串
Sybase：
|
1
2
3
4
5
6
|
TO_DB_URL = jdbc:sybase:Tds:192.168.168.163:5000/testdb?charset=eucgb&jconnect_version=6
TO_DB_DRIVER = com.sybase.jdbc3.jdbc.SybDataSource#com.sybase.jdbc3.jdbc.SybDriver驱动下表输入组件不支持别名。#net.sourceforge.jtds.jdbc.Driver驱动下表输入组件支持别名。TO_DB_USER = testTO_DB_PWD = test |
Oracle：
|
1
2
3
4
|
DEST_DB_URL=jdbc:oracle:thin:@192.168.168.162:1521:orcl
DEST_DB_DRIVER=oracle.jdbc.driver.OracleDriverDEST_DB_USER=testDEST_DB_PWD=test |
MySQL:
|
1
2
3
4
|
DEST_DB_URL=jdbc:mysql://127.0.0.1:3306/test?defaultFetchSize=500&useCursorFetch=true
DEST_DB_DRIVER=com.mysql.jdbc.DriverDEST_DB_USER=rootDEST_DB_PWD=root |