kettle60使用手册.docx
《kettle60使用手册.docx》由会员分享,可在线阅读,更多相关《kettle60使用手册.docx(64页珍藏版)》请在冰豆网上搜索。
kettle60使用手册
kettle/kettle
建立数据交换数据库连接
wrx_dc/wrx_dc
wrx_jw/wrx_jw
wrx_xg/wrx_xg
--Repositorycreation/upgradeDDL:
--
--Nothingwascreatednormodifiedinthetargetrepositorydatabase.
--HittheOKbuttontoexecutethegeneratedSQLorClosetorejectthechanges.
--Pleasenotethatitispossibletochange/editthegeneratedSQLbeforeexecution.
--
CREATETABLER_REPOSITORY_LOG
(
ID_REPOSITORY_LOGINTEGER
REP_VERSIONVARCHAR2(255)
LOG_DATEDATE
LOG_USERVARCHAR2(255)
OPERATION_DESCCLOB
PRIMARYKEY(ID_REPOSITORY_LOG)
)
;
ALTERTABLER_VERSIONADD(UPGRADE_DATE_KTLDATE);
UPDATER_VERSIONSETUPGRADE_DATE_KTL=UPGRADE_DATE;
ALTERTABLER_VERSIONDROP(UPGRADE_DATE)
;
ALTERTABLER_VERSIONADD(UPGRADE_DATEDATE);
UPDATER_VERSIONSETUPGRADE_DATE=UPGRADE_DATE_KTL;
ALTERTABLER_VERSIONDROP(UPGRADE_DATE_KTL)
;
;
INSERTINTOR_VERSION(ID_VERSION,MAJOR_VERSION,MINOR_VERSION,UPGRADE_DATE,IS_UPGRADE)VALUES(1,5,0,TO_DATE('2016/08/2010:
16:
49','YYYY/MM/DDHH24:
MI:
SS'),'N');
CREATETABLER_DATABASE_TYPE
(
ID_DATABASE_TYPEINTEGER
CODEVARCHAR2(255)
DESCRIPTIONVARCHAR2(255)
PRIMARYKEY(ID_DATABASE_TYPE)
)
;
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(1,'ORACLERDB','OracleRDB');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(2,'INFINIDB','CalpontInfiniDB');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(3,'INFOBRIGHT','Infobright');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(4,'PALO','PaloMOLAPServer');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(5,'GENERIC','Genericdatabase');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(6,'AS/400','AS/400');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(7,'SYBASEIQ','SybaseIQ');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(8,'HIVE2','HadoopHive2');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(9,'SQLITE','SQLite');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(10,'DERBY','ApacheDerby');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(11,'INFORMIX','Informix');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(12,'INGRES','Ingres');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(13,'HIVE','HadoopHive');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(14,'IMPALASIMBA','ClouderaImpala');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(15,'REMEDY-AR-SYSTEM','RemedyActionRequestSystem');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(16,'POSTGRESQL','PostgreSQL');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(17,'SAPR3','SAPERPSystem');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(18,'REDSHIFT','Redshift');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(19,'CACHE','IntersystemsCache');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(20,'MSSQL','MSSQLServer');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(21,'TERADATA','Teradata');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(22,'DB2','IBMDB2');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(23,'SQLBASE','GuptaSQLBase');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(24,'MYSQL','MySQL');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(25,'FIREBIRD','FirebirdSQL');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(26,'HYPERSONIC','Hypersonic');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(27,'MSACCESS','MSAccess');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(28,'KINGBASEES','KingbaseES');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(29,'INTERBASE','BorlandInterbase');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(30,'VERTICA5','Vertica5+');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(31,'MSSQLNATIVE','MSSQLServer(Native)');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(32,'EXASOL4','Exasol4');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(33,'EXTENDB','ExtenDB');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(34,'KettleThin','PentahoDataServices');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(35,'OpenERPDatabaseMeta','OpenERPServer');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(36,'UNIVERSE','UniVersedatabase');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(37,'NEOVIEW','Neoview');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(38,'LucidDB','LucidDB');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(39,'SAPDB','MaxDB(SAPDB)');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(40,'VERTICA','Vertica');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(41,'DBASE','dBaseIII,IVor5');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(42,'H2','H2');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(43,'VECTORWISE','IngresVectorWise');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(44,'SYBASE','Sybase');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(45,'ORACLE','Oracle');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(46,'MONDRIAN','NativeMondrian');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(47,'NETEZZA','Netezza');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(48,'IMPALA','Impala');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(49,'GREENPLUM','Greenplum');
INSERTINTOR_DATABASE_TYPE(ID_DATABASE_TYPE,CODE,DESCRIPTION)VALUES(50,'MONETDB','MonetDB');
CREATETABLER_DATABASE_CONTYPE
(
ID_DATABASE_CONTYPEINTEGER
CODEVARCHAR2(255)
DESCRIPTIONVARCHAR2(255)
PRIMARYKEY(ID_DATABASE_CONTYPE)
)
;
INSERTINTOR_DATABASE_CONTYPE(ID_DATABASE_CONTYPE,CODE,DESCRIPTION)VALUES(1,'Native','Native(JDBC)');
INSERTINTOR_DATABASE_CONTYPE(ID_DATABASE_CONTYPE,CODE,DESCRIPTION)VALUES(2,'ODBC','ODBC');
INSERTINTOR_DATABASE_CONTYPE(ID_DATABASE_CONTYPE,CODE,DESCRIPTION)VALUES(3,'OCI','OCI');
INSERTINTOR_DATABASE_CONTYPE(ID_DATABASE_CONTYPE,CODE,DESCRIPTION)VALUES(4,'Plugin','Pluginspecificaccessmethod');
INSERTINTOR_DATABASE_CONTYPE(ID_DATABASE_CONTYPE,CODE,DESCRIPTION)VALUES(5,'JNDI','JNDI');
INSERTINTOR_DATABASE_CONTYPE(ID_DATABASE_CONTYPE,CODE,DESCRIPTION)VALUES(6,',','Custom');
CREATETABLER_NOTE
(
ID_NOTEINTEGER
VALUE_STRCLOB
GUI_LOCATION_XINTEGER
GUI_LOCATION_YINTEGER
GUI_LOCATION_WIDTHINTEGER
GUI_LOCATION_HEIGHTINTEGER
FONT_NAMECLOB
FONT_SIZEINTEGER
FONT_BOLDCHAR
(1)
FONT_ITALICCHAR
(1)
FONT_COLOR_REDINTEGER
FONT_COLOR_GREENINTEGER
FONT_COLOR_BLUEINTEGER
FONT_BACK_GROUND_COLOR_REDINTEGER
FONT_BACK_GROUND_COLOR_GREENINTEGER
FONT_BACK_GROUND_COLOR_BLUEINTEGER
FONT_BORDER_COLOR_REDINTEGER
FONT_BORDER_COLOR_GREENINTEGER
FONT_BORDER_COLOR_BLUEINTEGER
DRAW_SHADOWCHAR
(1)
PRIMARYKEY(ID_NOTE)
)
;
CREATETABLER_DATABASE
(
ID_DATABASEINTEGER
NAMEVARCHAR2(255)
ID_DATABASE_TYPEINTEGER
ID_DATABASE_CONTYPEINTEGER
HOST_NAMEVARCHAR2(255)
DATABASE_NAMECLOB
PORTINTEGER
USERNAMEVARCHAR2(255)
PASSWORDVARCHAR2(255)
SERVERNAMEVARCHAR2(255)
DATA_TBSVARCHAR2(255)
INDEX_TBSVARCHAR2(255)
PRIMARYKEY(ID_DATABASE)
)
;
CREATETABLER_DATABASE_ATTRIBUTE
(
ID_DATABASE_ATTRIBUTEINTEGER
ID_DATABASEINTEGER
CODEVARCHAR2(255)
VALUE_STRCLOB
PRIMARYKEY(ID_DATABASE_ATTRIBUTE)
)
;
CREATEUNIQUEINDEXIDX_RDATONR_DATABASE_ATTRIBUTE(ID_DATABASE,CODE)
;
CREATETABLER_DIRECTORY
(
ID_DIRECTORYINTEGER
ID_DIRECTORY_PARENTINTEGER
DIRECTORY_NAMEVARCHAR2(255)
PRIMARYKEY(ID_DIRECTORY)
)
;
CREATEUNIQUEINDEXIDX_RDIRONR_DIRECTORY(ID_DIRECTORY_PARENT,DIRECTORY_NAME)
;
CREATETABLER_TRANSFORMATION
(
ID_TRANSFORMATIONINTEGER
ID_DIRECTORYINTEGER
NAMEVARCHAR2(255)
DESCRIPTIONCLOB
EXTENDED_DESCRIPTIONCLOB
TRANS_VERSIONVARCHAR2(255)
TRANS_STATUSINTEGER
ID_STEP_READINTEGER
ID_STEP_WRITEINTEGER
ID_STEP_INPUTINTEGER
ID_STEP_OUTPUTINTEGER
ID_STEP_UPDATEINTEGER
ID_DATABASE_LOGINTEGER
TABLE_NAME_LOGVARCHAR2(255)
USE_BATCHIDCHAR
(1)
USE_LOGFIELDCHAR
(1)
ID_DATABASE_MAXDATEINTEGER
TABLE_NAME_MAXDATEVARCHAR2(255)
FIELD_NAME_MAXDATEVARCHAR2(255)
OFFSET_MAXDATENUMBER(12,2)
DIFF_MAXDATENUMBER(12,2)
CREATED_USERVARCHAR2(255)
CREATED_DATEDATE
MODIFIED_USERVARCHAR2(255)
MODIFIED_DATEDATE
SIZE_ROWSETINTEGER
PRIMARYKEY(ID_TRANSFORMATION)
)
;
CREATETABLER_TRANS_ATTRIBUTE
(
ID_TRANS_ATTRIBUTEINTEGER
ID_TRANSFORMATIONINTEGER
NRINTEGER
CODEVARCHAR2(255)
VALUE_NUMINTEGER
VALUE_STRCLOB
PRIMARYKEY(ID_TRANS_ATTRIBUTE)
)
;
CREATEUNIQUEINDEXIDX_TATTONR_TRANS_ATTRIBUTE(ID_TRANSFORMATION,CODE,NR)
;
CREATETABLER_JOB_ATTRIBUTE
(
ID_JOB_ATTRIBUTEINTEGER
ID_JOBINTEGER
NRINTEGER
CODEVARCHAR2(255)
VALUE_NUMINTEGER
VALUE_STRCLOB
PRIMARYKEY(ID_JOB_ATTRIBUTE)
)
;
CREATEUNIQUEINDEXIDX_JATTONR_JOB_ATTRIBUTE(ID_JOB,CODE,NR)