July 30, 2023

tNeo4jImportTool – Docs for ESB 7.x

tNeo4jImportTool

Uses Neo4j Import Tool to create a Neo4j database and import large amounts of data in bulk from CSV files to this database.

tNeo4jImportTool Standard properties

These properties are used to configure tNeo4jImportTool running in the Standard Job framework.

The Standard
tNeo4jImportTool component belongs to the Big Data and the Databases NoSQL families.

The component in this framework is available in all Talend products with Big Data
and in Talend Data Fabric.

Basic settings

Neo4j database folder

Enter, or browse to the directory you want tNeo4jImportTool to create a Neo4j database. The name you put in the path is used to name this database.

Nodes files

Complete this table to provide the CSV files that contain the information about the nodes to be imported.

  • Path to CSV file: enter, within double quotation marks, the path to the CSV file to be read.

  • CSV headers: enter, within double quotation marks, the headers used in this CSV file.

When entering values, use the syntax demonstrated by the examples given alongside the column names of this Nodes files table.

Relationship files

Complete this table to provide the CSV files that contain the information about the relationships to be imported.

  • Path to CSV file: enter, within double quotation marks, the path to the CSV file to be read.

  • CSV headers: enter, within double quotation marks, the headers used in this CSV file.

When entering values, use the syntax demonstrated by the examples given alongside the column names of this Nodes files table.

Advanced settings

Neo4j configuration

Add parameters to the table to configure the database to be created.

For further information, see Neo4j documentation: Configuration settings.

When entering values, use the syntax demonstrated by the examples given alongside the column names of this Nodes files table.

Import configuration

Add parameters to the table to configure Neo4j Import Tool.

For further information, see Neo4j documentation: Import Tool usage.

When entering values, use the syntax demonstrated by the examples given alongside the column names of this Nodes files table.

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level
as well as at each component level.

Global Variables

Global Variables

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space
to access the variable list and choose the variable to use from it.

For further information about variables, see
Talend Studio

User Guide.

Usage

Usage rule

This component is to be used standalone in a subJob to load data in bulk
from given CSV files that have been created with specific
structure.

For further information about the CSV structure required by Neo4j Import Tool, see Import.

You can use tFileOutputDelimited to create the CSV files to be used. If so, bear the following configuration in mind:

  • Line separator: "
    "

  • Field separator: ","

  • Do not include headers.

  • File encoding: UTF-8.


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x