August 15, 2023

Importing the actors data into Neo4j – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Importing the actors data into Neo4j – Docs for ESB 6.x

Importing the actors data into Neo4j

  1. Double-click the first tFileInputDelimited component to open its Basic settings view on the Component tab.

    components-tneo4joutputrelationship_s1-3.png

  2. In the File name/Stream field, specify
    the path to the CSV file that describes the actors’ names, the years they
    were born in, and their roles in the movies.

    The input CSV file used in this example is as follows:
  3. In the Header field, specify the number
    of rows to skip as header rows. In this example, the first row of the CSV
    file is the header row.
  4. Click the […] button next to Edit schema to open the [Schema] dialog box, and define the input schema based on
    the structure of the input file. In this example, the input schema is
    composed of two columns, name and
    born, both of type String.

    When done, click OK to close the
    [Schema] dialog box and propagate the
    schema to the next component.
    components-tneo4joutputrelationship_s1-4.png

  5. Click the first tNeo4jOutput component
    and select the Component tab to open its
    Basic settings view.

    components-tneo4joutputrelationship_s1-8.png

  6. 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.
  7. Double-click the tNeo4jOutput component
    or click the Mapping button on the
    component’s Basic settings view to open the
    index and relationship mapping editor.
  8. With the name column selected from the
    schema panel, click the Index creation tab,
    click the [+] button to add a row in the
    table, and create an index named name on
    this column:

    • In the Name field, enter
      name between double quotation
      marks.

    • In the Key field, enter name between double quotation marks to
      give the index a key name.

    Then click in the schema panel to validate your index creation, and click
    OK to close the mapping editor.
    components-tneo4joutputrelationship_s1-9.png

  9. Select the Use label (Neo4j > 2.0) check
    box and enter Actors between double
    quotation marks in the Label name field so
    that the nodes to be created will be labeled Actors.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x