August 15, 2023

Configuring data import – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring data import – Docs for ESB 6.x

Configuring data import

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

    components-tneo4jrow_s2-3.png

  2. In the File name/Stream field, specify
    the path to the CSV file that contains the employees data to read.

    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 six columns: employeeID
    (integer), employeeName (String),
    age (Integer), hireDate (Date), salary (Double), and managerID (String).

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

  5. Double-click the tNeo4jRow component to
    open its Basic settings view on the
    Component tab.

    components-tneo4jrow_s2-5.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. 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 nodes with the
    label Employees and six properties, to
    hold the data from the input flow:

    • ID, which will take the value
      of the variable parameter id,

    • Name, which will take the value
      of the variable parameter name,

    • Age, which will take the value
      of the variable parameter age,

    • HireDate, which will the value
      of the variable parameter hire_date,

    • Salary, which will take the
      value of the variable parameter salary, and

    • ManagerID, which will the value
      of the variable parameter manager_id.

  8. In the Parameters table, type in the
    variable parameters in the Parameter field
    in accordance with your Cypher query , and map each of them with an input
    schema column by selecting it from the Parameter
    value     list field.

    components-tneo4jrow_s2-6.png

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