一、Developer Environment:
JDK1.6
MyEclipse6.5
Kettle4.0
二、Code List
1、创建Step日志表kettle_step_log_table(Oracle建表sql)
create table KETTLE_STEP_LOG_TABLE
(
ID_BATCH INTEGER,
CHANNEL_ID VARCHAR2(255),
LOG_DATE DATE,
TRANSNAME VARCHAR2(255),
STEPNAME VARCHAR2(255),
STEP_COPY INTEGER,
LINES_READ INTEGER,
LINES_WRITTEN INTEGER,
LINES_UPDATED INTEGER,
LINES_INPUT INTEGER,
LINES_OUTPUT INTEGER,
LINES_REJECTED INTEGER,
ERRORS INTEGER,
LOG_FIELD CLOB
)
2、配置step日志数据库连接
kettle_step_log_table
10.10.3.52
ORACLE
Native
DGWSJ
1521
bsoft
Encrypted 2be98afc86aa7f2e4cb79ce72cd9da9ce
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N