Setting up subJob 1 - 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 Open Studio for Big Data; 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

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 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.
Double-click tNeo4jv4Row_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. Add two rows in the Query field and enter the following two clauses.
```
"CREATE CONSTRAINT uniq_Person IF NOT EXISTS FOR (p:Person) REQUIRE p.id IS UNIQUE"
"CREATE CONSTRAINT uniq_Account IF NOT EXISTS FOR (p:Account) REQUIRE p.id IS UNIQUE"
```
3. Leave the other options as they are.
This component makes sure all the nodes created are unique. For more information about the CREATE CONSTRAINT command, see Constraints.