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 user name and 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 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) RETURN n"

    This component retrieves the properties of all the nodes in the Neo4jv4 database and passes the node properties to the corresponding columns.

  3. 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.
  4. Double-click tNeo4jv4Input_2 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 two columns in the schema editor: name, type String and position, type String.
    3. Enter the following statement in the Query field. 
      "MATCH (n) where n.id=2 RETURN n.name as name, n.position as position"

    This component retrieves the name and position properties of the node with the id of 2 and passes the properties (that is, name and position) to the corresponding columns.

  5. Double-click tLogRow_2 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_2 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_2.