Configuring a Neo4j database connection and nodes creation - 6.5

Neo4j

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Open Studio for Big Data
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Database components > Neo4j components
Data Quality and Preparation > Third-party systems > Database components > Neo4j components
Design and Development > Third-party systems > Database components > Neo4j components
EnrichPlatform
Talend Studio

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.