kettle6.0使用手册

kettle/kettle建立数据交换数据库连接wrx_dc/wrx_dcwrx_jw/wrx_jwwrx_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');INSER