Importing data from a CSV file to Neo4j and creating relationships using a single Cypher query - 7.0

Neo4j

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Open Studio for Big Data
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Database components > Neo4j components
Data Quality and Preparation > Third-party systems > Database components > Neo4j components
Design and Development > Third-party systems > Database components > Neo4j components
EnrichPlatform
Talend Studio

This scenario applies only to Talend products with Big Data.

For more technologies supported by Talend, see Talend components.

This scenario describes a Job that imports family information from a CSV file into a remote Neo4j database and create relationships between persons and families using a single Cypher query through a tNeo4jRow component.

Below is content of the CSV file to import data from in this example:
Name;Gender;Age;Family
Jenny;Female;24;the Johnsons
Jack;Male;26;the Johnsons
Richard;Male;35;the Blacks
Anne;Female;36;the Whites
Helen;Female;28;the Blacks
Tom;Male;38;the Whites

As MERGE is used with LOAD CSV in this example, to ensure the Cypher query is executed in an efficient way, another tNeo4jRow component is used to create an index on the property to merge.