Reading data from the Neo4j database - 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 tNeo4jInput component to open its Basic settings view.
  2. As in the tNeo4jOutput component, specify the URL of the Neo4j server to connect to, "http://localhost:7474/db/data" in this example.
  3. Click the [...] button next to Edit schema and define the schema for employees information display. When done, click OK to close the [Schema] dialog box and propagate the schema to the next component.
    The defined schema columns automatically appear in the Mapping table.
  4. In the Query field, type in the Cypher query to match the data to read from the Neo4j database. In this example, use the following Cypher query to find employees who are more than 40 years old and are under the manager m6.
    "MATCH (n) WHERE n.age > 40 AND n.managerID = 'm6' RETURN n;"
  5. Fill the Return parameter field for each schema column with a return parameter in double quotes to map the node properties in the Neo4j database with the schema columns.
  6. Double-click the tLogRow component to open its Basic settings view, and select the Table (print values in cells of a table) option to display the retrieved information in a table.