Setting up the Job

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here