引用以备用:
1. 在data-integration\simple-jndi\jdbc.properties中介入jdbc的连结信息。
比如 :
############ ORACLE ################
ORA/type=javax.sql.DataSource
ORA/driver=oracle.jdbc.driver.OracleDriver
ORA/url=jdbc:oracle:thin:@127.0.0.1:1521:ORCL
ORA/user=system
ORA/password=system
############ MSSQL ################
MSSQL/type=javax.sql.DataSource
MSSQL/driver=net.sourceforge.jtds.jdbc.Driver
MSSQL/url=jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=test;SelectMethod=Cursor
MSSQL/user=test
MSSQL/password=test
留意 ,kettle应用 的MSSQL的驱动是:driver=net.sourceforge.jtds.jdbc.Driver
2.假如 kettle必需应用service_name连接oracle(平凡 毗连 必要 SID),添加以下内容.
ORA/type=javax.sql.DataSourceORA/driver=oracle.jdbc.driver.OracleDriverORA/url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST
=(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT =
1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =
test)))
ORA/user=username
ORA/password=password
======================应用资料=================================