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 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

Procedure

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.