Setting up the Job - Cloud

Setting up the Job - 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 Open Studio for Big Data

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

Procedure

Double-click tNeo4jv4Connection_1 to open its Basic settings view and do the following:
1. Enter the connection URI of the Neo4jv4 database server in the Connection URI field ("neo4j://localhost:7687" in this example).
2. Enter the username and the password in the Username and Password fields.
  To enter the password, click the [...] button next to the Password field and enter the password in the dialog box that appears.
3. Leave the other options as they are.
This component establishes a connection to the Neo4jv4 database.
Double-click tFixedFlowInput_1 to open its Basic settings view and do the following:
1. Open the schema editor by clicking the [...] button next to Edit schema and add three columns in the schema editor: id , type Integer; name, type String; and position, type String.
2. Select Use Inline Content(delimited file) and enter the following in the Content field.
```
1;"Gerald White";"HR directory"
2;"Jimmy Black";"Sales manager"
```
3. Leave the other options as they are.
This component sets the properties for the nodes to be created.
Double-click tNeo4jv4Output_1 to open its Basic settings view and do the following:
1. Select the Use an existing connection option and select tNeo4jv4Connection_1 from the Component List drop-down list.
2. Click the Sync columns button to make sure the component had the same columns as those of the tFixedFlowInput_1 component.
3. Enter the following statement in the Query field.
```
create (a:Managers{id:$id,name:$name,position:$position})
```
4. Leave the other options as they are.
This component creates nodes and sets the properties (that is, id, name, and position) for the nodes using the data received from the tFixedFlowInput component.
Double-click tNeo4jv4Input_1 to open its Basic settings view and do the following:
1. Select the Use an existing connection option and select tNeo4jv4Connection_1 from the Component List drop-down list.
2. Open the schema editor by clicking the [...] button next to Edit schema and add three columns in the schema editor: id , type Integer; name, type String; and position, type String.
3. Enter the following statement in the Query field.
```
"MATCH (n:Managers) RETURN n"
```
This component retrieves the properties of all the nodes with the label of Manager and passes the properties to the corresponding columns.
Double-click tLogRow_1 to open its Basic settings view and do the following:
1. Click the Sync columns button to make sure the component had the same columns as those of the tNeo4jv4Input_1 component.
2. Select Table (print values in cells of a table).
3. Leave the other options as they are.
This component shows the node properties retrieved by the tNeo4jv4Input_1.