Procedure
-
Create a Job and add the following components to the Job by typing theirs
names in the design workspace or dropping them from the Palette:
-
a tNeo4jConnection component, to open a connection to a Neo4j database,
-
three tFileInputDelimited components, to read the input information of actors and movies,
-
two tNeo4jOutput components, to write information of movies and actors to the connected Neo4j database,
-
a tNeo4jOutputRelationship component, to create relationship between actors and movies, and
-
a tNeo4jClose component, to close the previous opened Neo4j connection at the end of Job execution.
-
- Link the first tFileInputDelimited to the first tNeo4jOutput component using a Row > Main connection. This subJob will import the actors data into the Neo4j database.
- Link the second tFileInputDelimited component to the second tNeo4jOutput component using a Row > Main connection. This subJob will import the movies data into the Neo4j database.
- Link the third tFileInputDelimited component to the tNeo4jOutputRelationship component using a Row > Main connection. This subJob will create relationship between actors and movies.
- Link the subJobs using Trigger > On Subjob Ok connections.
-
Label the components to better identify their roles in the Job.