《手摸手带你学ClickHouse》之Oracle同步数据到Clickhouse

小灰灰 2023-09-28 07:22 174阅读 0赞

> 本文同步发表于我的微信公众号，扫一扫文章底部的二维码或在微信搜索 chaodev 即可关注。

#### 文章目录 ####

前文回顾：  
[《手摸手带你学ClickHouse》之安装部署][ClickHouse]  
[《手摸手带你学ClickHouse》之访问接口][ClickHouse 1]  
[《手摸手带你学ClickHouse》之导入导出数据][ClickHouse 2]  
[《手摸手带你学ClickHouse》之MergeTree系列表引擎][ClickHouse_MergeTree]  
[《手摸手带你学ClickHouse》之ReplacingMergeTree表引擎][ClickHouse_ReplacingMergeTree]  
[《手摸手带你学ClickHouse》之CollapsingMergeTree表引擎][ClickHouse_CollapsingMergeTree]  
[《手摸手带你学ClickHouse》之VersionedCollapsingMergeTree表引擎][ClickHouse_VersionedCollapsingMergeTree]  
[《手摸手带你学ClickHouse》之SummingMergeTree表引擎][ClickHouse_SummingMergeTree]  
[《手摸手带你学ClickHouse》之AggregatingMergeTree表引擎][ClickHouse_AggregatingMergeTree]  
[《手摸手带你学ClickHouse》之MySQL表引擎][ClickHouse_MySQL]  
[《手摸手带你学ClickHouse》之分布式集群][ClickHouse 3]

--------------------

下载kettle：[https://sourceforge.net/projects/pentaho/files/Data%20Integration/][https_sourceforge.net_projects_pentaho_files_Data_20Integration]

pdi-ce-9.2.0.0-290.zip

要连接clickhouse还需要自定义插件连接

![在这里插入图片描述][dd00aedfe857448581beeb278af199ad.png]

![在这里插入图片描述][386f9082e1dc46af983f2d61b04d128b.png]

参考 [https://blog.csdn.net/xch\_yang/article/details/120223023][https_blog.csdn.net_xch_yang_article_details_120223023]

导入：  
建立oracle连接及clickhouse连接

![在这里插入图片描述][4e0d687ed4264219aa11b60b41f604cd.png]

![在这里插入图片描述][05f7cc40586448fdbcd113bcea27114c.png]

![在这里插入图片描述][df7d284e2d2e4d1db83e6a89b9fb9868.png]

![在这里插入图片描述][a5c9a2e5d4604237b5191808589b036f.png]

![在这里插入图片描述][299a1aef782f469aaeb27292c15a939a.png]

![在这里插入图片描述][ac0b28470742456a9d0dc49276330360.png]  
![在这里插入图片描述][7f192bae596842999a2473327e4ac6a2.png]

![在这里插入图片描述][63bc3ef350824236808edabdc9ee397f.png]

> 后续将继续更新该系列，大佬超手摸手带你学ClickHouse，敬请关注！！！

--------------------

原创不易，转载请注明出处。

[ClickHouse]: https://blog.csdn.net/xch_yang/article/details/122309471
[ClickHouse 1]: https://blog.csdn.net/xch_yang/article/details/122370442
[ClickHouse 2]: https://blog.csdn.net/xch_yang/article/details/122817778
[ClickHouse_MergeTree]: https://blog.csdn.net/xch_yang/article/details/122855242
[ClickHouse_ReplacingMergeTree]: https://blog.csdn.net/xch_yang/article/details/123047197
[ClickHouse_CollapsingMergeTree]: https://blog.csdn.net/xch_yang/article/details/123125210
[ClickHouse_VersionedCollapsingMergeTree]: https://blog.csdn.net/xch_yang/article/details/123137895
[ClickHouse_SummingMergeTree]: https://blog.csdn.net/xch_yang/article/details/123591740
[ClickHouse_AggregatingMergeTree]: https://blog.csdn.net/xch_yang/article/details/123610328
[ClickHouse_MySQL]: https://blog.csdn.net/xch_yang/article/details/123608253
[ClickHouse 3]: https://blog.csdn.net/xch_yang/article/details/124280916
[https_sourceforge.net_projects_pentaho_files_Data_20Integration]: https://sourceforge.net/projects/pentaho/files/Data%20Integration/
[dd00aedfe857448581beeb278af199ad.png]: https://img-blog.csdnimg.cn/dd00aedfe857448581beeb278af199ad.png
[386f9082e1dc46af983f2d61b04d128b.png]: https://img-blog.csdnimg.cn/386f9082e1dc46af983f2d61b04d128b.png
[https_blog.csdn.net_xch_yang_article_details_120223023]: https://blog.csdn.net/xch_yang/article/details/120223023
[4e0d687ed4264219aa11b60b41f604cd.png]: https://img-blog.csdnimg.cn/4e0d687ed4264219aa11b60b41f604cd.png
[05f7cc40586448fdbcd113bcea27114c.png]: https://img-blog.csdnimg.cn/05f7cc40586448fdbcd113bcea27114c.png
[df7d284e2d2e4d1db83e6a89b9fb9868.png]: https://img-blog.csdnimg.cn/df7d284e2d2e4d1db83e6a89b9fb9868.png
[a5c9a2e5d4604237b5191808589b036f.png]: https://img-blog.csdnimg.cn/a5c9a2e5d4604237b5191808589b036f.png
[299a1aef782f469aaeb27292c15a939a.png]: https://img-blog.csdnimg.cn/299a1aef782f469aaeb27292c15a939a.png
[ac0b28470742456a9d0dc49276330360.png]: https://img-blog.csdnimg.cn/ac0b28470742456a9d0dc49276330360.png
[7f192bae596842999a2473327e4ac6a2.png]: https://img-blog.csdnimg.cn/7f192bae596842999a2473327e4ac6a2.png
[63bc3ef350824236808edabdc9ee397f.png]: https://img-blog.csdnimg.cn/63bc3ef350824236808edabdc9ee397f.png