{"id":24569,"date":"2018-12-17T19:01:16","date_gmt":"2018-12-17T10:01:16","guid":{"rendered":"https:\/\/www.creationline.com\/?p=24569"},"modified":"2018-12-18T13:50:48","modified_gmt":"2018-12-18T04:50:48","slug":"neo4j-etl%e3%82%b3%e3%83%9e%e3%83%b3%e3%83%89%e3%83%a9%e3%82%a4%e3%83%b3%e3%82%a4%e3%83%b3%e3%82%bf%e3%83%bc%e3%83%95%e3%82%a7%e3%83%bc%e3%82%b9cli%e3%81%ae%e7%b4%b9%e4%bb%8b-neo4j","status":"publish","type":"post","link":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569","title":{"rendered":"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j"},"content":{"rendered":"<\/p>\n<p>neo4j-etl\u306f\u3001\u3044\u308f\u3086\u308bCLI\u3067RDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u30c0\u30a4\u30ec\u30af\u30c8\u306bNeo4j\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5f0a\u793e\u306e\u6728\u5185\u304c<a href=\"\/lab\/neo4j\/24412\">Neo4j ETL DeskTop,Neo4j ETL\u306e\u7d39\u4ecb<\/a>\u306e\u3088\u3046\u306bGUI\u3067\u884c\u3046Neo4j ETL\u3092\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u4eca\u56de\u306f\u305d\u306e\u7d9a\u7de8\u3068\u3057\u3066CLI\u3067\u884c\u3046Neo4j ETL\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>Neo4j ETL\u306f\u3001GUI(Neo4j DeskTop)\u3067\u884c\u3046\u65b9\u6cd5\u3068\u3001CLI(neo4j-etl)\u3067\u884c\u30462\u3064\u306e\u65b9\u6cd5\u304c\u3042\u308b\u3002<\/li>\n<li>JDBC\u3092\u5229\u7528\u3057\u3001Oracle\u3001MS SQLServer\u3001MS SQLServer\u3001Derby\u3001Cassandra\u3001SAP Hana\u3001MySQL\u3001PostgreSQL\u306a\u3069\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u308b\u3002<\/li>\n<li>Neo4j ETL\u306f\u3001\u57fa\u672c\u7684\u306b\u6307\u5b9a\u3055\u308c\u305f\u30b9\u30ad\u30fc\u30de\u306e\u5168\u30c7\u30fc\u30bf\u3092\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u5bfe\u8c61\u306b\u3059\u308b\u3002<\/li>\n<li>\u305f\u3060\u3057\u3001\u30bd\u30fc\u30b9DB\u3068Neo4j\u3068\u306e\u9593\u306b\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u631f\u3093\u3067\u3001\u4e0d\u8981\u306a\u30c7\u30fc\u30bf\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u3084\u3001\u30b5\u30d6\u30b0\u30e9\u30d5\u306e\u7bc4\u56f2\u3001\u5c5e\u6027\u3001\u30e9\u30d9\u30eb\u540d\u3084\u30bf\u30a4\u30d7\u540d\u306e\u5909\u66f4\u306a\u3069\u304c\u3067\u304d\u308b\u3002<\/li>\n<\/ul>\n<p>\u3053\u308c\u304b\u3089\u3001\u7c21\u5358\u306a\u691c\u8a3c\u3092\u5b9f\u884c\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<p>[\u53c2\u7167\u30b5\u30a4\u30c8]<br \/>\n<a href=\"https:\/\/neo4j-contrib.github.io\/neo4j-etl\/\" rel=\"noopener\" target=\"_blank\">https:\/\/neo4j-contrib.github.io\/neo4j-etl\/<\/a><br \/>\n<a href=\"https:\/\/neo4j.com\/developer\/neo4j-etl\/\" rel=\"noopener\" target=\"_blank\">https:\/\/neo4j.com\/developer\/neo4j-etl\/<\/a><\/p>\n<h2>\u4e8b\u524d\u6e96\u5099<\/h2>\n<h3>\u691c\u8a3c\u74b0\u5883\u69cb\u6210<\/h3>\n<ul>\n<li>CentOS7.5<\/li>\n<li>JDK8<\/li>\n<li>MySQL5.7<\/li>\n<li>Neo4j3.4.10<\/li>\n<li>neo4j-etl-cli-1.2.1<\/li>\n<li>JDBC\u30c9\u30e9\u30a4\u30d0\u30fc(mysql-connecor-java-5.1.25-3)<\/li>\n<\/ul>\n<h3>Oracle JDK\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p>\u4eca\u56de\u306f\u3001Oracle JDK(jdk-8u191-linux-x64.rpm)\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>[\u53c2\u7167\u30b5\u30a4\u30c8]<br \/>\n<a href=\"https:\/\/www.oracle.com\/technetwork\/java\/javase\/downloads\/jdk8-downloads-2133151.html\" rel=\"noopener\" target=\"_blank\">https:\/\/www.oracle.com\/technetwork\/java\/javase\/downloads\/jdk8-downloads-2133151.html<\/a><\/p>\n<p>[\u30e1\u30e2]<\/p>\n<blockquote><p>\nOracle JDK\u5229\u7528\u306f\u7b46\u8005\u306e\u597d\u307f\u3067\u3059\u3002OpenJDK8\u304c\u65e2\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u3053\u306e\u624b\u9806\u306f\u30b9\u30ad\u30c3\u30d7\u3057\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002\n<\/p><\/blockquote>\n<p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"javascript\">\n$ sudo  rpm -qa |grep openjdk\njava-1.8.0-openjdk-headless-1.8.0.191.b12-0.el7_5.x86_64\njava-1.8.0-openjdk-1.8.0.191.b12-0.el7_5.x86_64\n$ sudo  yum remove java-1.8.0-openjdk-headless-1.8.0.191.b12-0.el7_5.x86_64 java-1.8.0-openjdk-1.8.0.191.b12-0.el7_5.x86_64\n$ sudo\u3000rpm -Uvh jdk-8u191-linux-x64.rpm\n<\/pre>\n<\/p>\n<h3>MySQL\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p>MySQL5.7\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<p>[\u53c2\u7167\u30b5\u30a4\u30c8]<br \/>\n<a href=\"https:\/\/dev.mysql.com\/doc\/mysql-yum-repo-quick-guide\/en\/\" rel=\"noopener\" target=\"_blank\">https:\/\/dev.mysql.com\/doc\/mysql-yum-repo-quick-guide\/en\/<\/a><\/p>\n<p><pre class=\"EnlighterJSRAW\">\n$ sudo  vi \/etc\/yum.repos.d\/mysql-community.repo\n[mysql57-community]\nname=MySQL 5.7 Community Server\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/$basearch\/\nenabled=1\ngpgcheck=0\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\n$ sudo yum install mysql-community-server mysql-community-devel mysql-utilities\n$ mysql --version\nmysql  Ver 14.14 Distrib 5.7.24, for Linux (x86_64) using  EditLine wrapper\n$ sudo systemctl start mysqld\n$ sudo systemctl status mysqld\n$ sudo grep &#039;temporary password&#039; \/var\/log\/mysqld.log\n2018-11-29T05:40:56.657776Z 1 [Note] A temporary password is generated for root@localhost: oGiCj+:py4&lt;em&gt;y\n$ mysql -uroot -p\nEnter password: oGiCj+:py4&lt;\/em&gt;y\nmysql&gt;\nmysql&gt;ALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;MyPassword&#039;;\nmysql&gt; CREATE DATABASE IF NOT EXISTS northwind;\nmysql&gt; CREATE user &#039;etluser&#039;@&#039;%&#039; IDENTIFIED BY &#039;MyPassword&#039;&#039;;\nmysql&gt; GRANT ALL ON northwind.* TO &#039;etluser&#039;@&#039;%&#039;;\n<\/pre>\n<\/p>\n<h3>MySQL\u3078\u30c7\u30e2DB\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb(northwind)<\/h3>\n<p>northwind\u306f\u3001RDB\u30e2\u30c7\u30eb\u304b\u3089GDB\u30e2\u30c7\u30eb\u3078\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u60f3\u5b9a\u3057\u305f\u30c7\u30e2\u7528\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3059\u3002<\/p>\n<p>[\u53c2\u7167\u30b5\u30a4\u30c8]<br \/>\n<a href=\"https:\/\/github.com\/pthom\/northwind_psql\/blob\/master\/northwind.sql\" rel=\"noopener\" target=\"_blank\">https:\/\/github.com\/pthom\/northwind_psql\/blob\/master\/northwind.sql<\/a><\/p>\n<p>\u3054\u89a7\u306e\u901a\u308a\u3001\u3053\u306e\u30c7\u30e2\u7528\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u3001PostgreSQL\u7248\u3057\u304b\u5b58\u5728\u3057\u307e\u305b\u3093\u3002\u3053\u3053\u3067\u7d39\u4ecb\u3057\u3066\u3044\u308bMySQL\u7248\u306f\u3001\u7b46\u8005\u304c\u30b3\u30f3\u30d0\u30fc\u30c8\u3057\u305f\u3082\u306e\u3067\u3059\u3002<\/p>\n<p>3\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3001MySQL\u3092\u5b9f\u884c\u3059\u308b\u30e6\u30fc\u30b6\u306e\u30db\u30fc\u30e0\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><a href=\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-ddl.sql_.txt\">northwind-ddl.sql.txt<\/a><br \/>\n<a href=\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-dml.sql_.txt\">northwind-dml.sql.txt<\/a><br \/>\n<a href=\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-foreign-key.sql_.txt\">northwind-foreign-key.sql.txt<\/a><\/p>\n<p>northwind\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"javascript\">\nmysql&gt; use northwind\nDatabase changed\nmysql&gt; source northwind-ddl.sql.txt\n\uff5e\nmysql&gt; source northwind-dml.sql.txt\n\uff5e\n--neo4j-etl\u3067\u306f\u3001\u5916\u90e8\u30ad\u30fc\u306b\u5f93\u3063\u3066GDB\u30e2\u30c7\u30eb\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\n--\u5916\u90e8\u30ad\u30fc\u304c\u5b58\u5728\u3057\u306a\u3044\u3068\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u304c\u5b58\u5728\u3057\u306a\u3044GDB\u30e2\u30c7\u30eb\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002\nmysql&gt; soruce northwind-foreign-key.sql.txt\n\uff5e\n--\u30c7\u30fc\u30bf\u4ef6\u6570\u3092\u30c1\u30a7\u30c3\u30af\u3057\u307e\u3059\u3002\n--customer_customer_demo\u3068customer_demographics\u306f\u3001\u305d\u3082\u305d\u3082\u30c7\u30fc\u30bf\u304c\u5b58\u5728\u3057\u306a\u3044\u306e\u30670\u4ef6\u3067\u9593\u9055\u3044\u3042\u308a\u307e\u305b\u3093\u3002\nmysql&gt; \nSELECT count(&lt;em&gt;) FROM customer_customer_demo\nUNION ALL\nSELECT count(&lt;\/em&gt;) FROM customer_demographics\nUNION ALL\nSELECT count(&lt;em&gt;) FROM employee_territories\nUNION ALL\nSELECT count(&lt;\/em&gt;) FROM order_details\nUNION ALL\nSELECT count(&lt;em&gt;) FROM orders\nUNION ALL\nSELECT count(&lt;\/em&gt;) FROM customers\nUNION ALL\nSELECT count(&lt;em&gt;) FROM products\nUNION ALL\nSELECT count(&lt;\/em&gt;) FROM shippers\nUNION ALL\nSELECT count(&lt;em&gt;) FROM suppliers\nUNION ALL\nSELECT count(&lt;\/em&gt;) FROM territories\nUNION ALL\nSELECT count(&lt;em&gt;) FROM us_states\nUNION ALL\nSELECT count(&lt;\/em&gt;) FROM categories\nUNION ALL\nSELECT count(&lt;em&gt;) FROM region;\n+----------+\n| count(&lt;\/em&gt;) |\n+----------+\n|        0 |\n|        0 |\n|       49 |\n|     2155 |\n|      830 |\n|       91 |\n|       77 |\n|        6 |\n|       29 |\n|       53 |\n|       51 |\n|        8 |\n|        4 |\n+----------+\n<\/pre>\n<\/p>\n<h3>Neo4j Server EE\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p>\u4eca\u56de\u306f\u30011\u30f5\u6708\u9650\u5b9a\u306eNeo4j Enterprise Edition\u3092\u5229\u7528\u3057\u307e\u3059\u3002<\/p>\n<p>[\u53c2\u7167\u30b5\u30a4\u30c8]<br \/>\n<a href=\"https:\/\/neo4j.com\/download-center\/#releases\" rel=\"noopener\" target=\"_blank\">https:\/\/neo4j.com\/download-center\/#releases<\/a><\/p>\n<p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"javascript\">\n$ tar zxvf neo4j-enterprise-3.4.10-unix.tar.gz\n$ sudo mv neo4j-enterprise-3.4.10 \/var\/lib\/neo4j\n$ sudo vi conf\/neo4j.conf\ndbms.connectors.default_listen_address=10.0.0.6\n$ sudo bin\/neo4j start\n<\/pre>\n<\/p>\n<h3>neo4j-etl\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p>\u6700\u65b0\u7248\u306eneo4j-etl\u3092\u30bf\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3001$NEOJ_HOME\u914d\u4e0b\u306b\u30c7\u30d7\u30ed\u30a4\u3057\u307e\u3059\u3002<\/p>\n<p>[\u53c2\u7167\u30b5\u30a4\u30c8]<br \/>\nhttps:\/\/github.com\/neo4j-contrib\/neo4j-etl<\/p>\n<p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"javascript\">\n$ wget https:\/\/github.com\/neo4j-contrib\/neo4j-etl\/releases\/download\/1.2.1\/neo4j-etl-cli-1.2.1-release.zip\n$ unzip neo4j-etl-cli-1.2.1-release.zip\n$ cd neo4j-etl-cli-1.2.1\n$ ls\nbin  docs  lib  LICENSE.txt  README.adoc  THIRD-PARTY.txt\n$ sudo cp bin\/* \/var\/lib\/neo4j\/bin\/\n$ sudo cp lib\/neo4j-etl.jar \/var\/lib\/neo4j\/lib\/\n<\/pre>\n<\/p>\n<h3>JDBC\u30c9\u30e9\u30a4\u30d0\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p>neo4j-etl\u306f\u3001JDBC\u30c9\u30e9\u30a4\u30d0\u2015\u3067RDB\u306b\u63a5\u7d9a\u3057\u307e\u3059\u3002<br \/>\n\u4eca\u56de\u306f\u3001MySQL\u306eJDBC\u30c9\u30e9\u30a4\u30d0\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<p>[\u53c2\u7167\u30b5\u30a4\u30c8]<br \/>\n<a href=\"http:\/\/dev.mysql.com\/downloads\/connector\/j\/\" rel=\"noopener\" target=\"_blank\">http:\/\/dev.mysql.com\/downloads\/connector\/j\/<\/a><br \/>\n<a href=\"https:\/\/centos.pkgs.org\/7\/centos-x86_64\/mysql-connector-java-5.1.25-3.el7.noarch.rpm.html\" rel=\"noopener\" target=\"_blank\">https:\/\/centos.pkgs.org\/7\/centos-x86_64\/mysql-connector-java-5.1.25-3.el7.noarch.rpm.html<\/a><\/p>\n<p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"javascript\">\n$ wget http:\/\/mirror.centos.org\/centos\/7\/os\/x86_64\/Packages\/mysql-connector-java-5.1.25-3.el7.noarch.rpm\n$ sudo rpm -Uvh mysql-connector-java-5.1.25-3.el7.noarch.rpm\n$ ls \/usr\/share\/java\/mysql-connector-java.jar\n$ sudo cp \/usr\/share\/java\/mysql-connector-java.jar \/var\/lib\/neo4j\/lib\/mysql-connector-java.jar\n<\/pre>\n<\/p>\n<h2>Neo4j ETL(CLI)\u306e\u5b9f\u884c<\/h2>\n<h3>\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u4f5c\u6210<\/h3>\n<p>\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u3068\u306f\u3001\u6587\u5b57\u901a\u308a\u3001RDB\u30e2\u30c7\u30eb\u3092GDB\u30e2\u30c7\u30eb\u306b\u7f6e\u304d\u63db\u3048\u308b\u305f\u3081\u306e\u30de\u30c3\u30d7\u3067\u3059\u3002<\/p>\n<p>\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u6307\u5b9a\u3057\u305fRDB\u306e\u30b9\u30ad\u30fc\u30de\u3068\u5916\u90e8\u30ad\u30fc\u3001\u4ed6\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306b\u5f93\u3063\u3066RDB\u304b\u3089GDB\u3078\u306e\u30de\u30c3\u30d7\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>GDB\u30e2\u30c7\u30eb\u306f\u3001\u3053\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u5b9a\u7fa9\u306b\u5f93\u3063\u3066\u69cb\u7bc9\u3055\u308c\u307e\u3059\u3002<\/li>\n<li>\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u306f\u3001\u4e9b\u304b\u8907\u96d1\u306fJSON\u578b\u5f0f\u306e\u5b9a\u7fa9\u3067\u3059\u304c\u3001\u898f\u5247\u6027\u3092\u6301\u3063\u3066\u3044\u308b\u306e\u3067\u51fa\u529b\u3057\u3066\u304b\u3089\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3067\u304d\u307e\u3059\u3002<\/li>\n<\/ul>\n<p>\u3067\u306f\u3001\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p><pre class=\"EnlighterJSRAW\">\n$ mkdir \/tmp\/northwind\n$ export NEO4J_HOME=\/var\/lib\/neo4j\n$ $NEO4J_HOME\/bin\/neo4j-etl help\n$ $NEO4J_HOME\/bin\/neo4j-etl help generate-metadata-mapping \n$ $NEO4J_HOME\/bin\/neo4j-etl generate-metadata-mapping \\\n  --rdbms:url jdbc:mysql:\/\/localhost:3306\/northwind?useSSL=false \\\n  --rdbms:user etluser --rdbms:password MyPassword \\\n  --rdbms:schema northwind \\\n  --output-mapping-file \/tmp\/northwind\/mapping.json\n<\/pre>\n<\/p>\n<p>\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u306f\u3001\u7279\u5225\u306a\u30d5\u30a3\u30eb\u30bf\u30fc\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u3066\u3044\u306a\u3044\u9650\u308a\u3001--rdbms:schema\u3067\u6307\u5b9a\u3057\u305fRDB\u306e\u30b9\u30ad\u30fc\u30de\u304c\u5168\u4f53\u304c\u5bfe\u8c61\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"javascript\">\n[ {\n  &quot;name&quot; : &quot;NODE_northwind.customers_d4778131-09bc-49d2-a8cf-a1b664c7ba52&quot;,\n  &quot;schema&quot; : &quot;northwind&quot;,\n  &quot;graph-object-type&quot; : &quot;Node&quot;,\n  &quot;sql&quot; : &quot;SELECT &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;customer_id&lt;\/code&gt; AS &lt;code&gt;customer_id&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;customer_id&lt;\/code&gt; AS &lt;code&gt;customer_id&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;fax&lt;\/code&gt; AS &lt;code&gt;fax&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;address&lt;\/code&gt; AS &lt;code&gt;address&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;postal_code&lt;\/code&gt; AS &lt;code&gt;postal_code&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;region&lt;\/code&gt; AS &lt;code&gt;region&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;contact_title&lt;\/code&gt; AS &lt;code&gt;contact_title&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;country&lt;\/code&gt; AS &lt;code&gt;country&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;contact_name&lt;\/code&gt; AS &lt;code&gt;contact_name&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;city&lt;\/code&gt; AS &lt;code&gt;city&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;phone&lt;\/code&gt; AS &lt;code&gt;phone&lt;\/code&gt;, &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;.&lt;code&gt;company_name&lt;\/code&gt; AS &lt;code&gt;company_name&lt;\/code&gt;, \\&quot;Customer\\&quot; AS &lt;code&gt;_NODE_LABEL_&lt;\/code&gt; FROM &lt;code&gt;northwind&lt;\/code&gt;.&lt;code&gt;customers&lt;\/code&gt;&quot;,\n  &quot;mappings&quot; : [ {\n    &quot;column&quot; : {\n      &quot;type&quot; : &quot;CompositeColumn&quot;,\n      &quot;table&quot; : &quot;customers&quot;,\n      &quot;schema&quot; : &quot;northwind&quot;,\n      &quot;role&quot; : &quot;PrimaryKey&quot;,\n      &quot;columns&quot; : [ {\n        &quot;type&quot; : &quot;SimpleColumn&quot;,\n        &quot;role&quot; : &quot;Data&quot;,\n        &quot;table&quot; : &quot;customers&quot;,\n        &quot;schema&quot; : &quot;northwind&quot;,\n        &quot;name&quot; : &quot;customer_id&quot;,\n        &quot;alias&quot; : &quot;customer_id&quot;,\n        &quot;sql-data-type&quot; : &quot;VARCHAR&quot;,\n        &quot;column-value-selection-strategy&quot; : &quot;SelectColumnValue&quot;\n      } ]\n    },\n    &quot;field&quot; : {\n      &quot;type&quot; : &quot;Id&quot;,\n      &quot;name&quot; : &quot;&quot;,\n      &quot;id-space&quot; : &quot;northwind.customers&quot;\n    }\n  },\n\uff5e\u4e2d\u7565\n]\n<\/pre>\n<\/p>\n<p><a href=\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/nortwind-mapping-all.json_..txt\">nortwind-mapping-all.json.<\/a><\/p>\n<h3>neo4j-etl\u306e\u5b9f\u884c<\/h3>\n<p>neo4j-etl\u306f\u3001\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u306b\u5f93\u3063\u3066RDB\u306e\u30c7\u30fc\u30bf\u3092CSV\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u3001GDB\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u6642\u306f\u3001neo4j-import\u3001neo4j-shell\u3001cypher-shell\u3001java bolt driver\u306a\u3069\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u9078\u3076\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u4eca\u56de\u306f\u3001cypher-shell\u3092\u5229\u7528\u3057\u307e\u3059\u3002\u3053\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3060\u3068\u3001Neo4j\u30b5\u30fc\u30d0\u306f\u8d77\u52d5\u4e2d\u3067\u3042\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"javascript\">\n$ echo &#039;{&quot;multiline-fields&quot;:&quot;true&quot;}&#039; &gt; \/tmp\/northwind\/options.json\n$ export NEO4J_HOME=\/var\/lib\/neo4j\n$ $NEO4J_HOME\/bin\/neo4j-etl export \\\n  --rdbms:url jdbc:mysql:\/\/localhost:3306\/northwind?autoReconnect=true  \\\n  --rdbms:user etluser --password MyPassword \\\n  --rdbms:schema northwind \\\n  --using cypher:direct \\\n  --neo4j:url bolt:\/\/10.0.0.10:7687 \\\n  --neo4j:user neo4j --neo4j:password MyPassword \\\n  --import-tool $NEO4J_HOME\/bin \\\n  --options-file \/tmp\/northwind\/options.json \\\n  --mapping-file \/tmp\/northwind\/mapping.json \\\n  --csv-directory $NEO4J_HOME\/import \\\n  --debug --force\n<\/pre>\n<\/p>\n<p>neo4j-etl\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304b\u3089\u3001Neo4j\u30d6\u30e9\u30a6\u30b6\u30fc\u3092\u958b\u304d\u3001\u30e1\u30bf\u30b0\u30e9\u30d5\u3092\u51fa\u529b\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<p><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"javascript\">\nCALL db.schema()\n<\/pre>\n<\/p>\n<p>\u6b21\u306e\u3088\u3046\u306a\u30e1\u30bf\u30b0\u30e9\u30d5\u304c\u8868\u793a\u3067\u304d\u308c\u3070ETL\u306f\u6210\u529f\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u3053\u306e\u30e1\u30bf\u30fc\u30b0\u30e9\u30d5\u306f\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u306b\u3088\u308bGDB\u30e2\u30c7\u30eb\u3067\u3059\u3002\u304a\u305d\u3089\u304f\u3001\u4e0d\u8981\u306a\u30b5\u30d6\u30b0\u30e9\u30d5\u306f\u53d6\u308a\u8fbc\u307f\u305f\u304f\u306a\u3044\u3068\u304b\u3001\u540d\u79f0\u3092\u5909\u3048\u305f\u3044\u5834\u5408\u304c\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png\" alt=\"\" width=\"476\" height=\"568\" class=\"alignnone size-full wp-image-24588\" srcset=\"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png 476w, https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph-302x360.png 302w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/p>\n<p>GDB\u30e2\u30c7\u30eb\u306e\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u306b\u306f\u30012\u3064\u306e\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li>\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3059\u308b\u30b3\u30de\u30f3\u30c9\u306b\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4e00\u676f\u4ed8\u3051\u3066\u3001\u3074\u3063\u305f\u308a\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3059\u308b\u3002<\/li>\n<li>\u307b\u307c\u30aa\u30d7\u30b7\u30e7\u30f3\u306a\u3057\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb(mapping.json)\u3092\u4f5c\u6210\u3057\u3001\u4e0d\u8981\u306a\u3082\u306e\u306f\u524a\u9664\u3057\u3001\u6c17\u306b\u8981\u3089\u306a\u3044\u540d\u79f0\u306f\u5909\u66f4\u3059\u308b\u3002<\/li>\n<\/ul>\n<p>\u6b21\u306eGDB\u30e2\u30c7\u30eb\u306f\u3001\u30de\u30c3\u30d4\u30f3\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u7de8\u96c6\u3057\u3066ETL\u3092\u5b9f\u884c\u3057\u305f\u3082\u306e\u3067\u3059\u3002\u5fc5\u8981\u306a\u30b5\u30d6\u30b0\u30e9\u30d5\u3060\u3051\u3092\u6b8b\u3057\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u540d\u79f0\u3092CATEGORIES\u304b\u3089PART_OF\u306b\u5909\u66f4\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph-customized-2.png\" alt=\"\" width=\"257\" height=\"221\" class=\"alignnone size-full wp-image-24592\" \/><br \/>\n<a href=\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-mapping-customized.json_.txt\">northwind-mapping-customized.json<\/a><\/p>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>1\u5ea6\u9650\u308a\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u5834\u5408\u306f\u3001Neo4j Desktop\u3067\u3082neo4j-etl\u3067\u3082\u5927\u5dee\u306a\u3044\u304b\u3082\u77e5\u308c\u307e\u305b\u3093\u304c\u3001\u591c\u9593\u30d0\u30c3\u30c1\u306a\u3069\u3067\u7e70\u308a\u66ff\u3048\u3057\u3066GDB\u3092\u5165\u308c\u66ff\u3048\u308b\u3088\u3046\u306a\u30b1\u30fc\u30b9\u3067\u306f\u3001CLI(neo4j-etl)\u3067\u306e\u5b9f\u88c5\u304c\u7d76\u5bfe\u5b09\u3057\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n<p>\n","protected":false},"excerpt":{"rendered":"<p>neo4j-etl\u306f\u3001\u3044\u308f\u3086\u308bCLI\u3067RDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u30c0\u30a4\u30ec\u30af\u30c8\u306bNeo4j\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5f0a\u793e\u306e\u6728\u5185\u304cNeo4j ETL DeskTop,Neo4j ETL\u306e\u7d39\u4ecb\u306e\u3088\u3046\u306bGUI\u3067\u884c\u3046N [&#8230;]<\/p>\n","protected":false},"author":13,"featured_media":24588,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[61,37,16],"tags":[46],"class_list":["post-24569","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lee","category-neo4j","category-author","tag-neo4j"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3<\/title>\n<meta name=\"description\" content=\"lee, Neo4j, \u8457\u8005\uff08Author\uff09 |neo4j-etl\u306f\u3001\u3044\u308f\u3086\u308bCLI\u3067RDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u30c0\u30a4\u30ec\u30af\u30c8\u306bNeo4j\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5f0a\u793e\u306e\u6728\u5185\u304cNeo4j ETL\" \/>\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.creationline.com\/tech-blog\/data-management\/neo4j\/24569\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\" \/>\n<meta property=\"og:description\" content=\"lee, Neo4j, \u8457\u8005\uff08Author\uff09 |neo4j-etl\u306f\u3001\u3044\u308f\u3086\u308bCLI\u3067RDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u30c0\u30a4\u30ec\u30af\u30c8\u306bNeo4j\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5f0a\u793e\u306e\u6728\u5185\u304cNeo4j ETL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569\" \/>\n<meta property=\"og:site_name\" content=\"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/creationline\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-17T10:01:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-18T04:50:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png\" \/>\n\t<meta property=\"og:image:width\" content=\"476\" \/>\n\t<meta property=\"og:image:height\" content=\"568\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"lee\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@awk256\" \/>\n<meta name=\"twitter:site\" content=\"@creationline\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"lee\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569\"},\"author\":{\"name\":\"lee\",\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616\"},\"headline\":\"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j\",\"datePublished\":\"2018-12-17T10:01:16+00:00\",\"dateModified\":\"2018-12-18T04:50:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569\"},\"wordCount\":893,\"image\":{\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png\",\"keywords\":[\"neo4j\"],\"articleSection\":[\"lee\",\"Neo4j\",\"\u8457\u8005\uff08Author\uff09\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569\",\"url\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569\",\"name\":\"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\",\"isPartOf\":{\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png\",\"datePublished\":\"2018-12-17T10:01:16+00:00\",\"dateModified\":\"2018-12-18T04:50:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616\"},\"description\":\"lee, Neo4j, \u8457\u8005\uff08Author\uff09 |neo4j-etl\u306f\u3001\u3044\u308f\u3086\u308bCLI\u3067RDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u30c0\u30a4\u30ec\u30af\u30c8\u306bNeo4j\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5f0a\u793e\u306e\u6728\u5185\u304cNeo4j ETL\",\"breadcrumb\":{\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#primaryimage\",\"url\":\"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png\",\"contentUrl\":\"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png\",\"width\":476,\"height\":568},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"HOME\",\"item\":\"https:\/\/www.creationline.com\/tech-blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u30c7\u30fc\u30bf\u200b\u200b\u30de\u30cd\u30b8\u30e1\u30f3\u30c8\",\"item\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Neo4j\",\"item\":\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/#website\",\"url\":\"https:\/\/www.creationline.com\/tech-blog\/\",\"name\":\"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\",\"description\":\"\u30a2\u30b8\u30e3\u30a4\u30eb\uff06DevOps\u3001\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u3001AI\uff06LLM\u306e\u5148\u7aef\u6280\u8853\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.creationline.com\/tech-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616\",\"name\":\"lee\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g\",\"caption\":\"lee\"},\"description\":\"\u30e2\u30c0\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc\u57fa\u76e4\u306e\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c8\u3068\u3057\u3066\u6d3b\u52d5\u3057\u3066\u3044\u307e\u3059\u3002 [\u8457\u66f8] \u30fbAmazon Cloud\u30c6\u30af\u30cb\u30ab\u30eb\u30ac\u30a4\u30c9\u2015EC2\/S3\u304b\u3089VPC\u307e\u3067\u5fb9\u5e95\u89e3\u6790 \u30fbAmazon Elastic MapReduce\u30c6\u30af\u30cb\u30ab\u30eb\u30ac\u30a4\u30c9 \u2015\u30af\u30e9\u30a6\u30c9\u578bHadoop\u3067\u5b9f\u73fe\u3059\u308b\u5927\u898f\u6a21\u5206\u6563\u51e6\u7406 \u30fbCypher\u30af\u30a8\u30ea\u30fc\u8a00\u8a9e\u306e\u4e8b\u4f8b\u3067\u5b66\u3076\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j \u30fbNeo4j\u3092\u4f7f\u3046\u30b0\u30e9\u30d5\u578b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5165\u9580(\u5171\u8457) \u30fbRDB\u6280\u8853\u8005\u306e\u305f\u3081\u306eNoSQL\u30ac\u30a4\u30c9(\u5171\u8457)\",\"sameAs\":[\"https:\/\/x.com\/@awk256\"],\"url\":\"https:\/\/www.creationline.com\/tech-blog\/author\/lee\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","description":"lee, Neo4j, \u8457\u8005\uff08Author\uff09 |neo4j-etl\u306f\u3001\u3044\u308f\u3086\u308bCLI\u3067RDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u30c0\u30a4\u30ec\u30af\u30c8\u306bNeo4j\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5f0a\u793e\u306e\u6728\u5185\u304cNeo4j ETL","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.creationline.com\/tech-blog\/data-management\/neo4j\/24569","og_locale":"ja_JP","og_type":"article","og_title":"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","og_description":"lee, Neo4j, \u8457\u8005\uff08Author\uff09 |neo4j-etl\u306f\u3001\u3044\u308f\u3086\u308bCLI\u3067RDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u30c0\u30a4\u30ec\u30af\u30c8\u306bNeo4j\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5f0a\u793e\u306e\u6728\u5185\u304cNeo4j ETL","og_url":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569","og_site_name":"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","article_publisher":"https:\/\/www.facebook.com\/creationline","article_published_time":"2018-12-17T10:01:16+00:00","article_modified_time":"2018-12-18T04:50:48+00:00","og_image":[{"width":476,"height":568,"url":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png","type":"image\/png"}],"author":"lee","twitter_card":"summary_large_image","twitter_creator":"@awk256","twitter_site":"@creationline","twitter_misc":{"\u57f7\u7b46\u8005":"lee","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"5\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#article","isPartOf":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569"},"author":{"name":"lee","@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616"},"headline":"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j","datePublished":"2018-12-17T10:01:16+00:00","dateModified":"2018-12-18T04:50:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569"},"wordCount":893,"image":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#primaryimage"},"thumbnailUrl":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png","keywords":["neo4j"],"articleSection":["lee","Neo4j","\u8457\u8005\uff08Author\uff09"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569","url":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569","name":"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","isPartOf":{"@id":"https:\/\/www.creationline.com\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#primaryimage"},"image":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#primaryimage"},"thumbnailUrl":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png","datePublished":"2018-12-17T10:01:16+00:00","dateModified":"2018-12-18T04:50:48+00:00","author":{"@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616"},"description":"lee, Neo4j, \u8457\u8005\uff08Author\uff09 |neo4j-etl\u306f\u3001\u3044\u308f\u3086\u308bCLI\u3067RDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u304b\u3089\u30c0\u30a4\u30ec\u30af\u30c8\u306bNeo4j\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5f0a\u793e\u306e\u6728\u5185\u304cNeo4j ETL","breadcrumb":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#primaryimage","url":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png","contentUrl":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2018\/12\/northwind-meta-graph.png","width":476,"height":568},{"@type":"BreadcrumbList","@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/24569#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"HOME","item":"https:\/\/www.creationline.com\/tech-blog"},{"@type":"ListItem","position":2,"name":"\u30c7\u30fc\u30bf\u200b\u200b\u30de\u30cd\u30b8\u30e1\u30f3\u30c8","item":"https:\/\/www.creationline.com\/tech-blog\/data-management"},{"@type":"ListItem","position":3,"name":"Neo4j","item":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j"},{"@type":"ListItem","position":4,"name":"neo4j-etl\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9(CLI)\u306e\u7d39\u4ecb #neo4j"}]},{"@type":"WebSite","@id":"https:\/\/www.creationline.com\/tech-blog\/#website","url":"https:\/\/www.creationline.com\/tech-blog\/","name":"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","description":"\u30a2\u30b8\u30e3\u30a4\u30eb\uff06DevOps\u3001\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u3001AI\uff06LLM\u306e\u5148\u7aef\u6280\u8853","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.creationline.com\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616","name":"lee","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g","caption":"lee"},"description":"\u30e2\u30c0\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc\u57fa\u76e4\u306e\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c8\u3068\u3057\u3066\u6d3b\u52d5\u3057\u3066\u3044\u307e\u3059\u3002 [\u8457\u66f8] \u30fbAmazon Cloud\u30c6\u30af\u30cb\u30ab\u30eb\u30ac\u30a4\u30c9\u2015EC2\/S3\u304b\u3089VPC\u307e\u3067\u5fb9\u5e95\u89e3\u6790 \u30fbAmazon Elastic MapReduce\u30c6\u30af\u30cb\u30ab\u30eb\u30ac\u30a4\u30c9 \u2015\u30af\u30e9\u30a6\u30c9\u578bHadoop\u3067\u5b9f\u73fe\u3059\u308b\u5927\u898f\u6a21\u5206\u6563\u51e6\u7406 \u30fbCypher\u30af\u30a8\u30ea\u30fc\u8a00\u8a9e\u306e\u4e8b\u4f8b\u3067\u5b66\u3076\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j \u30fbNeo4j\u3092\u4f7f\u3046\u30b0\u30e9\u30d5\u578b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5165\u9580(\u5171\u8457) \u30fbRDB\u6280\u8853\u8005\u306e\u305f\u3081\u306eNoSQL\u30ac\u30a4\u30c9(\u5171\u8457)","sameAs":["https:\/\/x.com\/@awk256"],"url":"https:\/\/www.creationline.com\/tech-blog\/author\/lee"}]}},"_links":{"self":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/24569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/comments?post=24569"}],"version-history":[{"count":34,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/24569\/revisions"}],"predecessor-version":[{"id":24639,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/24569\/revisions\/24639"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/media\/24588"}],"wp:attachment":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/media?parent=24569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/categories?post=24569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/tags?post=24569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}