I am Failing to connect with the tNeo4jConnection with below error.
I am using Neo4j 2.3, but don't see this DBVersion listed in Talend, so I am using the Neo4j 2.2.X option in the dropdown.
Also, where do you set the user and password for the Neo4J database?
[statistics] connecting to socket on port 4019
[statistics] connected
Exception in component tNeo4jConnection_1
java.lang.RuntimeException: Error starting org.neo4j.kernel.EmbeddedGraphDatabase, C:\Users\shopp\Documents\Neo4j\Fluid4
at org.neo4j.kernel.InternalAbstractGraphDatabase.run(InternalAbstractGraphDatabase.java:335)
at org.neo4j.kernel.EmbeddedGraphDatabase.<init>(EmbeddedGraphDatabase.java:59)
at org.neo4j.graphdb.factory.GraphDatabaseFactory.newDatabase(GraphDatabaseFactory.java:108)
at org.neo4j.graphdb.factory.GraphDatabaseFactory$1.newDatabase(GraphDatabaseFactory.java:95)
at org.neo4j.graphdb.factory.GraphDatabaseBuilder.newGraphDatabase(GraphDatabaseBuilder.java:176)
at org.neo4j.graphdb.factory.GraphDatabaseFactory.newEmbeddedDatabase(GraphDatabaseFactory.java:67)
at fluidactions.importneo4j_0_1.ImportNeo4j.tNeo4jConnection_1Process(ImportNeo4j.java:400)
at fluidactions.importneo4j_0_1.ImportNeo4j.runJobInTOS(ImportNeo4j.java:2089)
at fluidactions.importneo4j_0_1.ImportNeo4j.main(ImportNeo4j.java:1942)
Caused by: org.neo4j.kernel.lifecycle.LifecycleException: Component 'org.neo4j.kernel.impl.transaction.state.DataSourceManager@1ee7a188' was successfully initialized, but failed to start. Please see attached cause exception.
[statistics] disconnected
seems like the best work around for version 2.3 Talend Neo4j imports is placing the LoadCSV cypher into a tNeo4jRow. This does of course involve an extra step of generating .csv files from the SQL server, but is still faster than using tNeo4jOutput component as per below.
When using tNeo4jOutput the import is incredibly slow, and then you need extra 2 cypher steps to actually label the nodes, and remove the NodeType field used for labelling the nodes. See this chaps work around https://lucidwebdreams.wordpress.com/2014/07/24/import-data-into-neo4j-from-ms-sql-server-directly-using-talend/