Bulk-writing the movies data into Neo4j - Cloud

Bulk-writing the movies data into Neo4j - Cloud - 8.0

Neo4j

Version

Cloud

8.0

Language

English

Product

Talend Big Data

Talend Big Data Platform

Talend Data Fabric

Talend Data Integration

Talend Data Management Platform

Talend Data Services Platform

Talend ESB

Talend MDM Platform

Talend Real-Time Big Data Platform

Module

Talend Studio

Content

Data Governance > Third-party systems > NoSQL components > Neo4j components

Data Quality and Preparation > Third-party systems > NoSQL components > Neo4j components

Design and Development > Third-party systems > NoSQL components > Neo4j components

Last publication date

2024-02-20

Double-click the second tFileInputDelimited component to open its Component view.
In the File name/Stream field, enter the path or browse to the CSV file that describes the movies' IDs, names, release years and their labels to be used in Neo4j.
The input CSV file used in this example reads as follows:
```
tt0133093,"The Matrix",1999,Movie
tt0234215,"The Matrix Reloaded",2003,Movie;Sequel
tt0242653,"The Matrix Revolutions",2003,Movie;Sequel
```
The double quotation marks on the movie names are not mandate.
Click the [...] button next to Edit schema to open the schema editor, and define the input schema based on the structure of the input file.

In this example, the columns are id, title, released and label.
Click OK to close this editor and accept the propagation of the schema to the next component.
In the Field separator field, enter a comma (,) to replace the default semicolon (;).
Double-click the second tNeo4jBatchOutput component to open its Component view.
Select the Use an existing connection check box to reuse the Neo4j database connection opened by the tNeo4jConnection component.
Verify that the Shutdown after Job check box is clear.
From the Field that contains the label list drop-down list, select the column that provides labels.
In the Index name field, enter the name of the index to be created for the nodes.
From Import identifier drop-down list, select the column that provides IDs.