Kettle8.2æ å°ç»ä»¶
-
- ä¸ãç¸å ³è¯´æ
- äºã设计转æ¢
- ä¸ã转æ¢é ç½®
- åãè¿è¡è½¬æ¢
- äºãç»ææ¥ç
ä¸ãç¸å ³è¯´æ
-
æ å°ç»ä»¶è¯´æï¼
æ å°æ¯ç¨æ¥å®ä¹å转æ¢ï¼ä¾¿äºå°è£ åéç¨ã主è¦ç»ä»¶ææ å°ï¼å转æ¢ï¼ãæ å°è¾å ¥è§åãæ å°è¾åºè§åçã
-
æ å°ï¼å转æ¢ï¼ç»ä»¶è¯´æï¼
æ å°ï¼å转æ¢ï¼æ¯ç¨æ¥é ç½®å转æ¢ï¼å¯¹å转æ¢è¿è¡è°ç¨çä¸ä¸ªæ¥éª¤ã
-
æ å°è¾å ¥è§åç»ä»¶è¯´æï¼
æ å°è¾å ¥è§èæ¯
ï¼ç±è°ç¨çè¾å ¥å段
è¾å ¥ã转æ¢
-
æ å°è¾åºè§åç»ä»¶è¯´æï¼
æ å°è¾åºè§èæ¯åè°ç¨ç转æ¢è¾åºææåï¼ä¸åä»»ä½å¤çã
-
éæ±è¯´æï¼
ä»æ°æ®åºä¸çedu_course表读åæ°æ®ï¼æ ¹æ®teacher_idæ¥è¯¢edu_teacher表ï¼è·åç¨æ·ä¿¡æ¯ï¼æç»æä¿åå°Excelã
- æµè¯æ°æ®æºå¦ä¸ï¼éè¦è¯»è
å¨MySQLä¸æ§è¡å¦ä¸SQLè¯å¥åå§åæ°æ®
DROP TABLE IF EXISTS `edu_course`; CREATE TABLE `edu_course` ( `id` char(19) NOT NULL COMMENT '课ç¨ID', `teacher_id` char(19) NOT NULL COMMENT '课ç¨è®²å¸ID', `subject_id` char(19) NOT NULL COMMENT '课ç¨ä¸ä¸ID', `subject_parent_id` char(19) NOT NULL COMMENT '课ç¨ä¸ä¸ç¶çº§ID', `title` varchar(50) NOT NULL COMMENT '课ç¨æ é¢', `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '课ç¨éå®ä»·æ ¼ï¼è®¾ç½®ä¸º0åå¯å è´¹è§ç', `lesson_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'æ»è¯¾æ¶', `cover` varchar(255) NOT NULL COMMENT '课ç¨å°é¢å¾çè·¯å¾', `buy_count` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT 'éå®æ°é', `view_count` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT 'æµè§æ°é', `version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT 'ä¹è§é', `status` varchar(10) NOT NULL DEFAULT 'Draft' COMMENT '课ç¨ç¶æ Draftæªåå¸ Normalå·²åå¸', `is_deleted` tinyint(3) DEFAULT NULL COMMENT 'é»è¾å é¤ 1ï¼trueï¼å·²å é¤ï¼ 0ï¼falseï¼æªå é¤', `gmt_create` datetime NOT NULL COMMENT 'å建æ¶é´', `gmt_modified` datetime NOT NULL COMMENT 'æ´æ°æ¶é´', PRIMARY KEY (`id`), KEY `idx_title` (`title`), KEY `idx_subject_id` (`subject_id`), KEY `idx_teacher_id` (`teacher_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课ç¨'; /*Data for the table `edu_course` */ insert into `edu_course`(`id`,`teacher_id`,`subject_id`,`subject_parent_id`,`title`,`price`,`lesson_num`,`cover`,`buy_count`,`view_count`,`version`,`status`,`is_deleted`,`gmt_create`,`gmt_modified`) values ('1330124425118449666','1323301279040057345','1178214681504444418','1178214681483472898','Hadoopä»å ¥é¨å°ç²¾é','120.00',80,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/11/21/fe9e2b556bca4fc4a07f2d46a5a0e914Hadoop.jpg',0,4,1,'Normal',NULL,'2020-11-21 20:22:30','2020-12-07 03:35:36'),('1330128144329441282','1323301279040057345','1178214681529610242','1178214681483472898','Sparkå ¥é¨å°ç²¾é','110.00',80,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/11/21/08260d45cce6422cabbbe22d8ffcd424spark.jpg',0,24,1,'Normal',NULL,'2020-11-21 20:37:17','2020-12-07 18:03:44'),('1335870900815859714','1335868673288114178','1178214681139539969','1178214681118568449','计ç®æºä¸ä¸è±è¯åºæ¬','900.00',70,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/12/07/8e3292d0b0c34f87bf5c4a5d3f65b6fcCè¯è¨.jpg',0,8,1,'Draft',NULL,'2020-12-07 16:56:57','2020-12-07 21:37:27'),('1335886692483665921','1323301279040057345','1178214681428946945','1178214681399586817','é«çæ°å¦ä¸','100.00',80,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/12/07/0ab8c396d71e427d8a04d39a940dcb00ä¸è½½.jpg',0,2,1,'Normal',NULL,'2020-12-07 17:59:42','2020-12-07 21:31:30'),('1335915817915191297','1323301279040057345','1335914886087643138','1335914886049894402','ã大å¦è±è¯Bã','100.00',60,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/12/07/331363e28a154c148a8ec8490d28e094大å¦è±è¯B.jpg',0,0,1,'Normal',NULL,'2020-12-07 19:55:26','2020-12-07 19:59:39'),('1335917543426691074','1323301279040057345','1335914886087643138','1335914886049894402','ã计ç®æºåºç¨åºç¡ã','70.00',80,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/12/07/54daea0ca6d0427692fd234c2783fb4d计ç®æºåºç¨åºç¡.jpg',0,3,1,'Normal',NULL,'2020-12-07 20:02:17','2020-12-07 22:08:32'),('1335918198325317633','1323301279040057345','1335914886087643138','1335914886049894402','è¯æ','120.00',80,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/12/07/e50d849fca644d4aafacc38ce75f5008è¯æ.jpg',0,0,1,'Normal',NULL,'2020-12-07 20:04:53','2020-12-07 20:08:41'),('1335965309869260801','1189390295668469762','1178214681210843137','1178214681181483010','线æ§ä»£æ°','10.00',40,'/static/1.jpg',0,0,1,'Draft',NULL,'2020-12-07 23:12:06','2020-12-07 23:12:06'); /*Table structure for table `edu_teacher` */ DROP TABLE IF EXISTS `edu_teacher`; CREATE TABLE `edu_teacher` ( `id` char(19) NOT NULL COMMENT '讲å¸ID', `name` varchar(20) NOT NULL COMMENT '讲å¸å§å', `intro` varchar(500) NOT NULL DEFAULT '' COMMENT '讲å¸ç®ä»', `career` varchar(500) DEFAULT NULL COMMENT '讲å¸èµå,ä¸å¥è¯è¯´æ讲å¸', `level` int(10) unsigned NOT NULL COMMENT 'å¤´è¡ 1é«çº§è®²å¸ 2é¦å¸è®²å¸', `avatar` varchar(255) DEFAULT NULL COMMENT '讲å¸å¤´å', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'æåº', `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'é»è¾å é¤ 1ï¼trueï¼å·²å é¤ï¼ 0ï¼falseï¼æªå é¤', `gmt_create` datetime NOT NULL COMMENT 'å建æ¶é´', `gmt_modified` datetime NOT NULL COMMENT 'æ´æ°æ¶é´', PRIMARY KEY (`id`), UNIQUE KEY `uk_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='讲å¸'; /*Data for the table `edu_teacher` */ insert into `edu_teacher`(`id`,`name`,`intro`,`career`,`level`,`avatar`,`sort`,`is_deleted`,`gmt_create`,`gmt_modified`) values ('1','å¼ ä¸','è¿å¹´ä¸»æå½å®¶èªç¶ç§å¦åºéï¼6项ï¼ãæ±èçé大ç§æææ转å项ç®ï¼5项ï¼ãæ±èç产å¦ç åç»æ§èåç 究项ç®ï¼3项ï¼ãçå·¥ä¸ç§ææ¯æãçé«ææ¯ãçèªç¶ç§å¦åºéççé¨çº§åå ¶ä¼ä¸ç主è¦ç§ç 项ç®40å¤ä¸ªï¼å¤ä¸ªé¡¹ç®å¨ä¼ä¸æå转åï¼äº§çäºè¾å¥½çç»æµã社ä¼åç¯å¢æçã积æå¼å±äº§å¦ç ç§æåä½ï¼å¹¶ä¸çå 16家ä¼ä¸å»ºç«äºæ±èçç 究çå·¥ä½ç«ï¼å ¶ä¸6家为æ±èçä¼ç§ç 究çå·¥ä½ç«','é«çº§',1,'https://guli-file-190513.oss-cn-beijing.aliyuncs.com/avatar/default.jpg',0,0,'2019-10-30 14:18:46','2019-11-12 13:36:36'),('1189389726308478977','æ´å¤©','é«çº§è®²å¸ç®ä»','é«çº§è®²å¸èµå',2,'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/10/30/de47ee9b-7fec-43c5-8173-13c5f7f689b2.png',1,0,'2019-10-30 11:53:03','2019-10-30 11:53:03'),('1189390295668469762','æå','é«çº§è®²å¸ç®ä»','é«çº§è®²å¸',2,'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/10/30/b8aa36a2-db50-4eca-a6e3-cc6e608355e0.png',2,0,'2019-10-30 11:55:19','2019-11-12 13:37:52'),('1189426437876985857','çäº','é«çº§è®²å¸ç®ä»','é«çº§è®²å¸',1,'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/11/08/e44a2e92-2421-4ea3-bb49-46f2ec96ef88.png',0,0,'2019-10-30 14:18:56','2019-11-12 13:37:35'),('1189426464967995393','çäº','é«çº§è®²å¸ç®ä»','é«çº§è®²å¸',1,'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/10/30/65423f14-49a9-4092-baf5-6d0ef9686a85.png',0,1,'2019-10-30 14:19:02','2019-11-12 13:37:18'),('1192249914833055746','æå','é«çº§è®²å¸ç®ä»','é«çº§è®²å¸',1,'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/11/07/91871e25-fd83-4af6-845f-ea8d471d825d.png',0,0,'2019-11-07 09:18:25','2019-11-12 13:37:01'),('1192327476087115778','1222-12-12','1111','11',1,'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/11/08/5805c6cd-c8ad-4a77-aafd-d2e083bfd8a4.png',0,1,'2019-11-07 14:26:37','2019-11-11 16:26:26'),('1195337453429129218','test','sdfsdf','sdfdf',1,'https://guli-file-190513.oss-cn-beijing.aliyuncs.com/avatar/default.jpg',0,1,'2019-11-15 21:47:12','2019-11-15 21:47:27'),('1323301279040057345','èæ±æ','大æ°æ®é«çº§è®²å¸','大æ°æ®é«çº§è®²å¸',2,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/11/03/2326f645cccb45a28c62aa26f1f687d5file.png',1,0,'2020-11-03 00:29:45','2020-11-03 00:29:45'),('1323302269290065922','æ¢æ±æ','大æ°æ®é¦å¸è®²å¸','大æ°æ®é¦å¸è®²å¸',2,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/11/03/101477ccd8ed42b8b359eba4cc7c2169file.png',1,0,'2020-11-03 00:33:41','2020-11-03 00:33:41'),('1330094056755269633','èµµå¡è¤','é«çº§è®²å¸','é«çº§è®²å¸',1,'https://suben-user-avatar.oss-cn-shenzhen.aliyuncs.com/2020/11/21/10a83aba03c54e659a044b1c9d6b3e8efile.png',1,0,'2020-11-21 18:21:50','2020-11-21 18:21:50'),('1335567949326569474','èæ±æ2','çç±æè²ï¼çç±ææ¯ï¼çç±ç§æï¼çç±çæ´»','é¦å¸å¤§æ°æ®è®²å¸',2,NULL,1,0,'2020-12-06 20:53:07','2020-12-06 20:53:07');
äºã设计转æ¢
æ¬æ¬¡å®éªéè¦ä½¿ç¨ä¸¤ä¸ªè½¬æ¢æ¥é åå®æï¼ä¸ä¸ªä½ä¸ºå转æ¢ï¼ä¸ä¸ªä½ä¸ºå转æ¢çè°ç¨è ï¼ç¶è½¬æ¢ï¼ï¼å ·ä½å¦ä¸ï¼
å转æ¢è®¾è®¡
- æ å°ï¼æ å°è¾å ¥è§è
- æ¥è¯¢ï¼æ°æ®åºæ¥è¯¢
- æ å°ï¼æ å°è¾åºè§è
è°ç¨è ï¼ç¶è½¬æ¢ï¼è®¾è®¡
- è¾å ¥ï¼è¡¨æ°æ®
- æ å°ï¼æ å°ï¼å转æ¢ï¼
- è¾åºï¼Excelè¾åº
ä¸ã转æ¢é ç½®
- å转æ¢é
ç½®æ¥éª¤å¦ä¸
- Step1ï¼æ å°è¾å ¥è§èç»ä»¶é ç½®
- åå»ç»ä»¶ï¼åä¸æ¥éª¤å称ç
- ç¸å ³é ç½®å¦ä¸æ示ï¼
- Step2ï¼æ°æ®åºæ¥è¯¢ç»ä»¶é ç½®
- åå»æå¼ï¼è®¾ç½®æ¥éª¤å称
- é 置信æ¯ï¼å¦ä¸
- Step3ï¼è¾åºæ å°è§åç»ä»¶é ç½®
- åå»æå¼ï¼è®¾ç½®æ¥éª¤å称
- é 置信æ¯ï¼å¦ä¸ï¼
-
Step4ï¼ä¿åå转æ¢ï¼å¦åå为sub-tran
ä¸è¿°é 置好åï¼ç¹å»ç¡®å®å³å¯ï¼
- è°ç¨è
ï¼ç¶è½¬æ¢ï¼é
ç½®æ¥éª¤å¦ä¸
- Step1ï¼è¡¨è¾å ¥ç»ä»¶é ç½®
- åå»ç»ä»¶ï¼åä¸æ¥éª¤å称ç
- ç¸å ³é ç½®å¦ä¸æ示ï¼
- Step2ï¼æ å° (å转æ¢)ç»ä»¶é ç½®
- åå»ç»ä»¶ï¼åä¸æ¥éª¤å称ï¼éæ©å转æ¢æå¨ä½ç½®
- ç¸å ³é ç½®å¦ä¸æ示ï¼
- Step3ï¼Microsoft Excelç»ä»¶é ç½®
- åå»ç»ä»¶ï¼åä¸æ¥éª¤å称ç
- ç¸å ³é ç½®å¦ä¸æ示ï¼
-
Step4ï¼ä¿åå转æ¢ï¼å¦åå为mapping-trans
ä¸è¿°é 置好åï¼ç¹å»ç¡®å®å³å¯ï¼
åãè¿è¡è½¬æ¢
è¿éè¿è¡çæ¶åï¼åªéè¦è¿è¡è°ç¨è ï¼ç¶è½¬æ¢ï¼å³å¯
- ç¹å»è¿è¡æé®ï¼æåè¿è¡å¦ä¸ï¼
äºãç»ææ¥ç
- å¨æ件ä¸æ¥çç»æ
- Preview data ä¸æ¥çç»æ
-
ç»æåæ
该转æ¢å®æçåè½çä»·äºå¦ä¸SQLè¯å¥ï¼å³å·¦å¤è¿æ¥