Procedure
-
Double-click the second tNeo4jRow
component to open its Basic settings view
on the Component tab.
- From the DB Version list, select Neo4J 2.X.X.
- Select the Remote server check box and specify the URL of the Neo4j server in the Server URL field, "http://localhost:7474/db/data" in this example.
-
In the Query field, type in the following
Cypher query to import family data from the CSV file, create relevant
Person and Family nodes, and create relationships between persons and
families:
"LOAD CSV WITH HEADERS FROM 'file:E:/Talend/Data/Input/families.csv' AS csvLine FIELDTERMINATOR ';' MERGE (family:Family { name: csvLine.Family }) CREATE (person:Person { name: csvLine.Name, gender: csvLine.Gender, age: toInt(csvLine.Age)}) CREATE (person)-[:From]->(family)"