-
Notifications
You must be signed in to change notification settings - Fork 45
/
neo4j-etl-export.txt
executable file
·213 lines (170 loc) · 8.96 KB
/
neo4j-etl-export.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
NAME
neo4j-etl export - Export from RDBMS and import into NEO4J via CSV
files.
SYNOPSIS
neo4j-etl export [ {--columns | --cols} <Columns>... ]
[ --config-file <Configuration File> ]
[ --csv-directory <csv directory> ]
[ {-d | --database} <RDBMS database> ] [ --debug ]
[ --delimiter <delimiter> ] [ --destination <directory> ] [ {--driver | --jars} <--driver <PATH_TO_YOUR_JAR1> --driver <PATH_TO_YOUR_JAR2>>... ]
[ {--exclusion-mode | --exc} <Tables: exclude|include|none(default)> ]
[ {--exclusion-mode-column-type | --exctype} <exclude|include|none(default)> ]
[ {--exclusion-mode-columns | --excc} <exclude|include|none(default)> ]
[ {--exclusion-mode-tables | --exct} <exclude|include|none(default)> ]
[ --force ] [ --import-tool <import tool path> ]
[ --mapping-file <file|stdin> ] [ {--neo4j:password | --graph:password | --graph:neo4j:password} <neo4j password> ]
[ {--neo4j:url | --graph:url | --graph:neo4j:url} <neo4j url> ]
[ {--neo4j:user | --graph:user | --graph:neo4j:user} <neo4j user> ]
[ --options-file <option file> ] [ --output-mapping-file <file|stdout> ]
[ {-p | --port} <RDBMS port> ] [ --quote <quote> ]
[ {--rdbms:fetch-size | --fs} <fetch-size> ]
[ {--rdbms:password | --password} <RDBMS password> ]
[ {--rdbms:schema | -s | --schema} <schema> ]
[ {--rdbms:url | --url} <RDBMS url> ]
[ {--rdbms:user | -u | --user} <RDBMS user> ]
[ {--relationship-name | --rel-name} <table(default)|column> ]
[ --schemas <Schemas>... ] [ {--tables | --tabs} <Tables>... ]
[ --tiny-int <byte(default)|boolean> ] [ --types <Types>... ]
[ --using <import tool> ] [--] [ <table1 table2 ...>... ]
OPTIONS
--columns <Columns>, --cols <Columns>
Lists all columns to include/exclude by name or pattern
Use '-r' <PATTERN> to filter by regex, ex. '-r .*\.orders\..*_id' or
'northwind\.orders\..*_id' ,
'-g' <PATTERN> for grep syntax, ex. '-g .*\.orders\..*_id' or
'northwind\.orders\..*_id' ,
or '-l' <LIST> to list all columns names ex. '-l
northwind.customers.id,northwind.purchase.id,northwind.orders.id'
--config-file <Configuration File>
Specify the path to a file containing the configuration for the
selected command
--csv-directory <csv directory>
Path to directory for intermediate CSV files.
-d <RDBMS database>, --database <RDBMS database>
RDBMS database.
This option is required if any of the following options are
specified: host
--debug
Print detailed diagnostic output.
--delimiter <delimiter>
Delimiter to separate fields in CSV.
--destination <directory>
Path to destination store directory.
--driver <--driver <PATH_TO_YOUR_JAR1> --driver <PATH_TO_YOUR_JAR2>>, --jars <--driver <PATH_TO_YOUR_JAR1> --driver <PATH_TO_YOUR_JAR2>>
List of additional drivers as a list
--exclusion-mode <Tables: exclude|include|none(default)>, --exc <Tables: exclude|include|none(default)>
Specifies how to handle table exclusion. Options are mutually
exclusive.
exclude: Excludes specified tables from the process. All other
tables will be included.
include: Includes specified tables only. All other tables will be
excluded.
none: All tables are included in the process.
--exclusion-mode-column-type <exclude|include|none(default)>, --exctype
<exclude|include|none(default)>
Specifies how to handle column type exclusion. Options are mutually
exclusive.
exclude: Excludes specified columns types from the process. All
other columns types will be included.
include: Includes specified columns types only. All other columns
types will be excluded.
none: All columns types are included in the process.
--exclusion-mode-columns <exclude|include|none(default)>, --excc
<exclude|include|none(default)>
Specifies how to handle column exclusion. Options are mutually
exclusive.
exclude: Excludes specified columns from the process. All other
columns will be included.
include: Includes specified columns only. All other columns will be
excluded.
none: All columns are included in the process.
--exclusion-mode-tables <exclude|include|none(default)>, --exct
<exclude|include|none(default)>
Specifies how to handle table exclusion. Options are mutually
exclusive.
exclude: Excludes specified tables from the process. All other
tables will be included.
include: Includes specified tables only. All other tables will be
excluded.
none: All tables are included in the process.
--force
Force delete destination store directory if it already exists.
--import-tool <import tool path>
Path to directory containing Neo4j import tool. Mandatory only for Offline Bulk Import mode
--mapping-file <file|stdin>
Path to an existing metadata mapping file. The name 'stdin' will
cause the CSV resources definitions to be read from standard input.
--neo4j:password <neo4j password>, --graph:password <neo4j password>,
--graph:neo4j:password <neo4j password>
Password for login to Neo4j.
--neo4j:url <neo4j url>, --graph:url <neo4j url>, --graph:neo4j:url
<neo4j url>
Url to use for connection to Neo4j.
--neo4j:user <neo4j user>, --graph:user <neo4j user>, --graph:neo4j:user
<neo4j user>
User for login to Neo4j.
--options-file <option file>
Path to file containing Neo4j import tool options.
--output-mapping-file <file|stdout>
Path to the output metadata mapping file.
-p <RDBMS port>, --port <RDBMS port>
Port number to use for connection to RDBMS.
--quote <quote>
Character to treat as quotation character for values in CSV data.
--rdbms:fetch-size <fetch-size>, --fs <fetch-size>
RDBMS Fetch size
--rdbms:password <RDBMS password>, --password <RDBMS password>
Password for login to RDBMS.
This option is required if any of the following options are
specified: --rdbms:url, --url
--rdbms:schema <schema>, -s <schema>, --schema <schema>
RDBMS schema.
--rdbms:url <RDBMS url>, --url <RDBMS url>
Url to use for connection to RDBMS.
--rdbms:user <RDBMS user>, -u <RDBMS user>, --user <RDBMS user>
User for login to RDBMS.
This option is required if any of the following options are
specified: --rdbms:url, --url
--relationship-name <table(default)|column>, --rel-name
<table(default)|column>
Specifies whether to get the name for relationships from table names
or column names.
--schemas <Schemas>
Lists all schemas to include by name or pattern.
Use '-r' <PATTERN> to filter by regex, ex. '-r .*\.north.*',
'-g' <PATTERN> for grep syntax, ex. '-g .*\.north.*' ,
or '-l' <LIST> to list all schemas names ex. '-l northwind,exc'
--tables <Tables>, --tabs <Tables>
Lists all tables to include/exclude by name or pattern.
Use '-r' <PATTERN> to filter by regex, ex. '-r .*\.purchase.*' or
'northwind.purchase.*' ,
'-g' <PATTERN> for grep syntax, ex. '-g .*\.purchase.*' or
'northwind.purchase.*' ,
or '-l' <LIST> to list all tables names ex. '-l
customers,purchase,orders'
--tiny-int <byte(default)|boolean>
Specifies whether to convert TinyInt to byte or boolean
--types <Types>
Lists all column types to include/exclude by name separated by
commas. Valid values:
unknown,
binary,
bit,
character,
id,
integer,
real,
reference,
temporal,
url,
xml,
large_object,
object;
--using <import tool>
Import tool that will be used to load data into neo4j.
--
This option can be used to separate command-line options from the
list of arguments (useful when arguments might be mistaken for
command-line options)
<table1 table2 ...>
Tables to be excluded/included