{"id":41726,"date":"2022-11-28T02:58:23","date_gmt":"2023-12-20T08:15:25","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/"},"modified":"2024-04-29T02:47:42","modified_gmt":"2024-04-28T18:47:42","slug":"%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/","title":{"rendered":"\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b"},"content":{"rendered":"<h2>\u521b\u5efa\u8fd9\u7bc7\u6587\u7ae0\u7684\u80cc\u666f<\/h2>\n<p>\u4f60\u597d\u3002\u6211\u662f\u67d0\u516c\u53f8\u6570\u636e\u5229\u7528\u90e8\u95e8\u7684\u5de5\u4f5c\u4eba\u5458masahiro54\u3002<br \/>\n\u7531\u4e8e\u6700\u8fd1\u5f00\u59cb\u6d89\u8db3\u4e0e\u6570\u636e\u67b6\u6784\u76f8\u5173\u7684\u5de5\u4f5c\uff0c\u6240\u4ee5\u6211\u51b3\u5b9a\u5199\u4e00\u7bc7\u6587\u7ae0\u6765\u5b66\u4e60\u3002<br \/>\n\u6211\u89c9\u5f97\u5c06\u5176\u8f93\u51fa\u4e5f\u4f1a\u66f4\u52a0\u6709\u6210\u6548\u3002<\/p>\n<p>\u7136\u540e\uff0c\u6211\u8003\u8651\u5728\u672c\u5730\u73af\u5883\u4e2d\u5c1d\u8bd5\u4f7f\u7528\u6d41\u884c\u7684\u5de5\u5177&#8221;embulk&#8221;\u548c&#8221;digdag&#8221;\u3002<\/p>\n<h2>\u8fd9\u6b21\u7684\u76ee\u6807<\/h2>\n<p>\u6309\u7167\u4e0b\u56fe\u6240\u793a\uff0c\u4f7f\u7528Embulk\u8fdb\u884c\u4ee5\u4e0b\u6570\u636e\u534f\u8c03\u3002<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>csv\u6587\u4ef6\u8f6c\u4e3a\u5206\u6790\u6570\u636e\u5e93<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u5176\u4ed6\u6570\u636e\u5e93\u8f6c\u4e3a\u5206\u6790\u6570\u636e\u5e93<\/ol>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d484337434c4406cab065\/6-0.png\" alt=\"\u8a18\u4e8b\u75281.png\" \/><\/div>\n<p>\u672c\u6b21\u7684\u76ee\u6807\u662f\u5728DigDag\u4e2d\u6267\u884cEmbulk\u3002<\/p>\n<h2>\u5728\u505a\u4f5c\u4e1a\u4e4b\u524d\u7684\u72b6\u6001<\/h2>\n<h3>\u73af\u5883\uff08\u5c31\u662f\u8fd9\u6837\uff09\u3002<\/h3>\n<p>\u5c3d\u7ba1\u6574\u4f53\u73af\u5883\u6709\u70b9\u9648\u65e7\uff0c\u4f46\u7531\u4e8e\u8fd9\u8fb9\u66f4\u52a0\u65b9\u4fbf\uff0c\u6240\u4ee5\u6ca1\u6709\u5347\u7ea7\u5230\u6700\u65b0\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">windows11<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">java 1.8.0_371<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">PostgreSQL13<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">digdag 0.9.42<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">embulk 0.10.0<\/ul>\n<h3>\u4f5c\u4e1a\u5f00\u59cb\u524d\u7684\u72b6\u6001<\/h3>\n<p>\u4ee5\u4e0b\u662f\u5982\u4e0b\u6240\u793a\u7684\u60c5\u51b5\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d484337434c4406cab065\/14-0.png\" alt=\"input_csv.png\" \/><\/div>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d484337434c4406cab065\/15-0.png\" alt=\"input_DB.png\" \/><\/div>\n<ul class=\"post-ul\">\u5206\u6790DB<\/ul>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d484337434c4406cab065\/17-0.png\" alt=\"\u3082\u3068\u3082\u3068\u306eDB.png\" \/><\/div>\n<h2>\u5c1d\u8bd5\u8fc7\u7684\u4e8b\u60c5<\/h2>\n<h3>\u8f6c\u6362<\/h3>\n<h4>\u51c6\u5907\u597d<\/h4>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u5b89\u88c5embulk\uff08\u7248\u672c0.10.0\uff09\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>\u5c06&#8221;embulk-0.10.0.jar&#8221;\u66f4\u540d\u4e3a&#8221;embulk-latest.jar&#8221;\u5373\u53ef\u4f7f\u7528\u6700\u65b0\u7248\u672c\u3002<br \/>\n\uff08\u53ef\u80fd\u4e0b\u9762\u7684\u547d\u4ee4\u662f\u6b63\u786e\u7684\uff0c\u4f46\u53ea\u662f\u4ece\u4ee5\u524d\u7684\u5907\u5fd8\u5f55\u4e2d\u590d\u5236\u7c98\u8d34\u7684\uff0c\u5982\u679c\u6709\u9519\u8bef\uff0c\u8bf7\u8c05\u89e3\u3002\uff09<\/p>\n<pre class=\"post-pre\"><code>PowerShell -Command \"&amp; {Invoke-WebRequest http:\/\/dl.embulk.org\/embulk-0.10.0.jar -OutFile embulk.bat}\"\r\n<\/code><\/pre>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u4e3a\u4e86\u64cd\u4f5cPostgreSQL\uff0c\u9700\u8981\u5b89\u88c5\u4ee5\u4e0b\u4e24\u4e2a\u63d2\u4ef6\u3002\u547d\u4ee4\u5982\u4e0b\uff1a<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u203bCSV\u63d2\u4ef6\u5df2\u7ecf\u9ed8\u8ba4\u5b89\u88c5\u4e86\u3002<\/ol>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">embulk-input-postgresql<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">embulk-output-postgresql<\/ul>\n<p>\u4ee5\u4e0b\u662f\u547d\u4ee4\u7684\u5217\u8868\u3002<\/p>\n<pre class=\"post-pre\"><code>embulk gem install embulk-input-postgresql\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>embulk gem install embulk-output-postgresql\r\n<\/code><\/pre>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u66f4\u65b0JDBC\u9a45\u52d5\u7a0b\u5e8f<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u6253\u958b\u4ee5\u4e0b\u76ee\u9304\u4e2d\u76f8\u61c9\u63d2\u4ef6\u7684\u6587\u4ef6\u593e\uff0c\u5c07JDBC\u9a45\u52d5\u7a0b\u5e8f\u5728&#8221;default_jdbc_driver&#8221;\u6587\u4ef6\u593e\u4e2d\u66ff\u63db\u70ba\u6700\u65b0\u7248\u672c\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\uff08\u6211\u5c07&#8221;postgresql-9.4-1205-jdbc41.jar&#8221;\u66ff\u63db\u70ba&#8221;postgresql-42.6.0.jar&#8221;\u3002\uff09<\/ol>\n<pre class=\"post-pre\"><code>.embulk\\lib\\gems\\gems\r\n<\/code><\/pre>\n<p>\u987a\u4fbf\u63d0\u4e00\u4e0b\uff0c\u6211\u662f\u4ece\u8fd9\u91cc\u4e0b\u8f7d\u7684PostgreSQL\u7684JDBC\u9a71\u52a8\u7a0b\u5e8f\u3002(https:\/\/jdbc.postgresql.org\/)<\/p>\n<h4>\u521b\u5efayml\u6587\u4ef6<\/h4>\n<p>\u8fd9\u6b21\u6211\u4eec\u5b8c\u6210\u4e86\u4ee5\u4e0b\u4e24\u70b9\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">csv\u304b\u3089DB\u306b\u30c7\u30fc\u30bf\u3092\u9001\u308b\u305f\u3081\u306eyml\u30d5\u30a1\u30a4\u30eb<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">DB\u304b\u3089\u5225\u306eDB\u306b\u30c7\u30fc\u30bf\u3092\u9001\u308b\u305f\u3081\u306eyml\u30d5\u30a1\u30a4\u30eb<\/ul>\n<h5>\u7528\u4e8e\u5c06csv\u6570\u636e\u53d1\u9001\u5230\u6570\u636e\u5e93\u7684yml\u6587\u4ef6<\/h5>\n<p>\u8bf7\u5c06\u81ea\u5df1\u73af\u5883\u7684\u5bc6\u7801\u8f93\u5165\u4e3a\u9002\u5f53\u7684\u5b57\u7b26\u5e8f\u5217\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"na\">in<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">type<\/span><span class=\"pi\">:<\/span> <span class=\"s\">file<\/span>\r\n  <span class=\"na\">path_prefix<\/span><span class=\"pi\">:<\/span> <span class=\"s\">C:aaa\\\\bbb\\\\ccc\\\\sample_2_csv_pipeline_test.csv<\/span> <span class=\"c1\"># \u5165\u529b\u30d5\u30a1\u30a4\u30eb\u306e\u30d1\u30b9\u3092\u8a18\u8f09\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/span>\r\n  <span class=\"na\">parser<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">charset<\/span><span class=\"pi\">:<\/span> <span class=\"s\">UTF-8<\/span>\r\n    <span class=\"na\">newline<\/span><span class=\"pi\">:<\/span> <span class=\"s\">CRLF<\/span>\r\n    <span class=\"na\">type<\/span><span class=\"pi\">:<\/span> <span class=\"s\">csv<\/span>\r\n    <span class=\"na\">delimiter<\/span><span class=\"pi\">:<\/span> <span class=\"s1\">'<\/span><span class=\"s\">,'<\/span>\r\n    <span class=\"na\">skip_header_lines<\/span><span class=\"pi\">:<\/span> <span class=\"m\">1<\/span>\r\n    <span class=\"na\">columns<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"pi\">-<\/span> <span class=\"pi\">{<\/span><span class=\"nv\">name<\/span><span class=\"pi\">:<\/span> <span class=\"nv\">id<\/span><span class=\"pi\">,<\/span> <span class=\"nv\">type<\/span><span class=\"pi\">:<\/span> <span class=\"nv\">string<\/span><span class=\"pi\">}<\/span>\r\n    <span class=\"pi\">-<\/span> <span class=\"pi\">{<\/span><span class=\"nv\">name<\/span><span class=\"pi\">:<\/span> <span class=\"nv\">value<\/span><span class=\"pi\">,<\/span> <span class=\"nv\">type<\/span><span class=\"pi\">:<\/span> <span class=\"nv\">string<\/span><span class=\"pi\">}<\/span>\r\n<span class=\"na\">out<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">type<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgresql<\/span>\r\n  <span class=\"na\">host<\/span><span class=\"pi\">:<\/span> <span class=\"s\">localhost<\/span>\r\n  <span class=\"na\">user<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgres<\/span>\r\n  <span class=\"na\">password<\/span><span class=\"pi\">:<\/span> <span class=\"s\">poiuytrewq<\/span>\r\n  <span class=\"na\">database<\/span><span class=\"pi\">:<\/span> <span class=\"s\">data_pipeline_test_B<\/span> <span class=\"c1\">#\u5206\u6790\u7528DB<\/span>\r\n  <span class=\"na\">table<\/span><span class=\"pi\">:<\/span> <span class=\"s\">service_dummy<\/span>\r\n  <span class=\"na\">mode<\/span><span class=\"pi\">:<\/span> <span class=\"s\">insert<\/span>\r\n<\/code><\/pre>\n<h5>\u5c06\u6570\u636e\u4ece\u4e00\u4e2a\u6570\u636e\u5e93\u53d1\u9001\u5230\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u6240\u9700\u7684yml\u6587\u4ef6\u3002<\/h5>\n<pre class=\"post-pre\"><code><span class=\"na\">in<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">type<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgresql<\/span>\r\n  <span class=\"na\">host<\/span><span class=\"pi\">:<\/span> <span class=\"s\">localhost<\/span>\r\n  <span class=\"na\">user<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgres<\/span>\r\n  <span class=\"na\">password<\/span><span class=\"pi\">:<\/span> <span class=\"s\">poiuytrewq<\/span>\r\n  <span class=\"na\">database<\/span><span class=\"pi\">:<\/span> <span class=\"s\">data_pipeline_test_A<\/span> <span class=\"c1\">#\u5206\u6790\u4ee5\u5916\u306e\u7528\u9014\u306eDB<\/span>\r\n  <span class=\"na\">query<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"s\">select *<\/span>\r\n    <span class=\"s\">FROM service_dummy<\/span> <span class=\"c1\">#\u5165\u529b\u5143\u306e\u30c7\u30fc\u30bf\u3092\u5f15\u3063\u5f35\u308bSQL<\/span>\r\n<span class=\"na\">out<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">type<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgresql<\/span>\r\n  <span class=\"na\">host<\/span><span class=\"pi\">:<\/span> <span class=\"s\">localhost<\/span>\r\n  <span class=\"na\">user<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgres<\/span>\r\n  <span class=\"na\">password<\/span><span class=\"pi\">:<\/span> <span class=\"s\">poiuytrewq<\/span>\r\n  <span class=\"na\">database<\/span><span class=\"pi\">:<\/span> <span class=\"s\">data_pipeline_test_B<\/span> <span class=\"c1\">#\u5206\u6790\u7528DB<\/span>\r\n  <span class=\"na\">table<\/span><span class=\"pi\">:<\/span> <span class=\"s\">service_dummy<\/span> \r\n  <span class=\"na\">mode<\/span><span class=\"pi\">:<\/span> <span class=\"s\">insert<\/span>\r\n<\/code><\/pre>\n<h3>\u6316\u6398\u79d8\u5bc6<\/h3>\n<h4>\u51c6\u5907\u597d<\/h4>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u7528\u4ee5\u4e0b\u547d\u4ee4\u5b89\u88c5digdag\uff08\u7248\u672c0.9.42\uff09\uff1a<\/ol>\n<\/li>\n<\/ol>\n<p>\u5c06\u201cdigdag-0.9.42.jar\u201d\u66f4\u540d\u4e3a\u201cdigdag-latest.jar\u201d\uff0c\u5373\u53ef\u66f4\u65b0\u81f3\u6700\u65b0\u7248\u3002<br \/>\n(\u867d\u7136\u4e0eembulk\u547d\u4ee4\u7565\u6709\u4e0d\u540c\uff0c\u8bf7\u4e0d\u5fc5\u62c5\u5fc3\u3002\u6211\u8ba4\u4e3a\u5b83\u4eec\u5e94\u8be5\u51e0\u4e4e\u76f8\u540c\u3002\u987a\u4fbf\u8bf4\u4e00\u4e0b\uff0c\u5f53\u65f6\u6211\u662f\u6309\u7167digdag \u2192 embulk\u7684\u987a\u5e8f\u8fdb\u884c\u51c6\u5907\u7684\u3002)<\/p>\n<pre class=\"post-pre\"><code>PowerShell -Command \"&amp; {[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::TLS12; mkdir -Force $env:USERPROFILE\\bin; Invoke-WebRequest http:\/\/dl.digdag.io\/digdag-0.9.42.jar -OutFile $env:USERPROFILE\\bin\\digdag.bat}\"\r\n<\/code><\/pre>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u521b\u5efadig\u6587\u4ef6<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\u5df2\u521b\u5efa\u4ee5\u4e0bdig\u6587\u4ef6\u3002<\/ol>\n<pre class=\"post-pre\"><code><span class=\"na\">timezone<\/span><span class=\"pi\">:<\/span> <span class=\"s2\">\"<\/span><span class=\"s\">Asia\/Tokyo\"<\/span>\r\n\r\n<span class=\"na\">_export<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">sh<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">shell<\/span><span class=\"pi\">:<\/span> <span class=\"pi\">[<\/span><span class=\"s2\">\"<\/span><span class=\"s\">powershell.exe\"<\/span><span class=\"pi\">]<\/span>\r\n\r\n<span class=\"c1\"># schedule:<\/span>\r\n<span class=\"c1\">#   daily&gt;: 10:00:00<\/span>\r\n\r\n<span class=\"na\">+step1<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">sh&gt;<\/span><span class=\"pi\">:<\/span> <span class=\"s\">embulk run csv_to_db.yml<\/span>\r\n\r\n<span class=\"na\">+step2<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">sh&gt;<\/span><span class=\"pi\">:<\/span> <span class=\"s\">embulk run db_to_db.yml<\/span>\r\n\r\n<span class=\"na\">+step3<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">echo&gt;<\/span><span class=\"pi\">:<\/span> <span class=\"s\">Fin.<\/span>\r\n<\/code><\/pre>\n<h2>\u7ed3\u679c<\/h2>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d484337434c4406cab065\/46-0.png\" alt=\"\u51e6\u7406\u5f8coutput_DB.png\" \/><\/div>\n<h2>\u603b\u7ed3<\/h2>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u3068\u308a\u3042\u3048\u305a\u3001embulk\u3068digdag\u306e\u7c21\u5358\u306a\u4f7f\u3044\u65b9\u306f\u308f\u304b\u308a\u307e\u3057\u305f\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u5fdc\u7528\u3059\u308c\u3070\u3001\u4f1a\u793e\u306e\u30c7\u30fc\u30bf\u57fa\u76e4\u3067\u3082\u4f7f\u3048\u305d\u3046\u3067\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u3068\u306f\u3044\u3048\u3053\u308c\u3060\u3051\u3060\u3068\u304b\u306a\u308a\u30b7\u30f3\u30d7\u30eb\u306a\u52d5\u304d\u3057\u304b\u3067\u304d\u306a\u3055\u305d\u3046\u306a\u306e\u3067\u3001\u3055\u3089\u306b\u5de5\u592b\u3092\u51dd\u3089\u3057\u305f\u4ed5\u7d44\u307f\u3092\u69cb\u7bc9\u3057\u3066\u307f\u305f\u3044\u3067\u3059\u3002\u3002\u3002<\/ul>\n<h3>\u6211\u60f3\u8981\u5c1d\u8bd5\u7684\u5c06\u6765\u4e8b\u9879\u3002<\/h3>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">embulk\u306b\u30af\u30e9\u30a6\u30c9\u74b0\u5883\u3078\u306e\u30c7\u30fc\u30bf\u9023\u643a<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304b\u3089DWH\u306b\u683c\u7d0d\u3057\u3001BI\u3067\u53ef\u8996\u5316\u3059\u308b\u307e\u3067\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u5206\u6790\u7528DB\u306b\u304a\u3051\u308b\u30c7\u30fc\u30bf\u306e\u6d17\u3044\u66ff\u3048\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u5b9f\u9a13\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>Update<br \/>\nDelete \u2192 Insert<br \/>\nDrop \u2192 Create<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u521b\u5efa\u8fd9\u7bc7\u6587\u7ae0\u7684\u80cc\u666f \u4f60\u597d\u3002\u6211\u662f\u67d0\u516c\u53f8\u6570\u636e\u5229\u7528\u90e8\u95e8\u7684\u5de5\u4f5c\u4eba\u5458masahiro54\u3002 \u7531\u4e8e\u6700\u8fd1\u5f00\u59cb\u6d89\u8db3\u4e0e\u6570\u636e\u67b6\u6784\u76f8 [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41726","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u8bd5\u56fe\u5728windows\u73af\u5883\u4e0b\u4f7f\u7528embulk\u548cdigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b\" \/>\n<meta property=\"og:description\" content=\"\u521b\u5efa\u8fd9\u7bc7\u6587\u7ae0\u7684\u80cc\u666f \u4f60\u597d\u3002\u6211\u662f\u67d0\u516c\u53f8\u6570\u636e\u5229\u7528\u90e8\u95e8\u7684\u5de5\u4f5c\u4eba\u5458masahiro54\u3002 \u7531\u4e8e\u6700\u8fd1\u5f00\u59cb\u6d89\u8db3\u4e0e\u6570\u636e\u67b6\u6784\u76f8 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u8bd5\u56fe\u5728windows\u73af\u5883\u4e0b\u4f7f\u7528embulk\u548cdigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-20T08:15:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-28T18:47:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d484337434c4406cab065\/6-0.png\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/\",\"name\":\"\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-12-20T08:15:25+00:00\",\"dateModified\":\"2024-04-28T18:47:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u8bd5\u56fe\u5728windows\u73af\u5883\u4e0b\u4f7f\u7528embulk\u548cdigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\/","og_locale":"zh_CN","og_type":"article","og_title":"\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b","og_description":"\u521b\u5efa\u8fd9\u7bc7\u6587\u7ae0\u7684\u80cc\u666f \u4f60\u597d\u3002\u6211\u662f\u67d0\u516c\u53f8\u6570\u636e\u5229\u7528\u90e8\u95e8\u7684\u5de5\u4f5c\u4eba\u5458masahiro54\u3002 \u7531\u4e8e\u6700\u8fd1\u5f00\u59cb\u6d89\u8db3\u4e0e\u6570\u636e\u67b6\u6784\u76f8 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u8bd5\u56fe\u5728windows\u73af\u5883\u4e0b\u4f7f\u7528embulk\u548cdigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-12-20T08:15:25+00:00","article_modified_time":"2024-04-28T18:47:42+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d484337434c4406cab065\/6-0.png"}],"author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/","name":"\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-12-20T08:15:25+00:00","dateModified":"2024-04-28T18:47:42+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u8bd5\u56fe\u5728Windows\u73af\u5883\u4e0b\u4f7f\u7528Embulk\u548cDigdag\u6784\u5efa\u6570\u636e\u5206\u6790\u57fa\u7840\u8bbe\u65bd\u7684\u6545\u4e8b"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e8%af%95%e5%9b%be%e5%9c%a8windows%e7%8e%af%e5%a2%83%e4%b8%8b%e4%bd%bf%e7%94%a8embulk%e5%92%8cdigdag%e6%9e%84%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%88%86%e6%9e%90%e5%9f%ba%e7%a1%80%e8%ae%be%e6%96%bd%e7%9a%84\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41726"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41726\/revisions"}],"predecessor-version":[{"id":76137,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41726\/revisions\/76137"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}