Configuring a Neo4j database connection and nodes creation - 7.3

Neo4j

EnrichVersion
Cloud
7.3
EnrichProdName
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
EnrichPlatform
Talend Studio
task
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

  1. Double-click the tNeo4jConnection component to open its Basic settings view on the Component tab.
  2. From the DB Version list, select Neo4J 2.X.X to enable node labeling support.
  3. In the Database path field, specify the directory for your data files, "E:/Talend/DB/Neo4j/data" in this example.
    In this example, you will use Neo4j in embedded mode; to connect to a remote Neo4j server via REST, click the Use a remote server check box and specify the URL of the Neo4j server.
  4. Double-click the tNeo4jRow component to open its Basic settings view on the Component tab.
  5. Select the Use an existing connection check box to reuse the Neo4j database connection opened by the tNeo4jConnection component, which is the only connection component used in this example.
  6. In the Query field, type in the Cypher query to be executed by the component.
    In this example, type in the following query to create two nodes with the label Managers and three properties - id, name, and position:
    "CREATE (a:Managers { id: 1, name: 'Gerald White', position: 'HR directory'})
    CREATE (b:Managers { id: 2, name: 'Jimmy Black', position: 'Sales manager'})"
    As this component does not have an input flow, leave the schema and the parameter settings blank.