Using Neo4j Desktop 4.0.1
Using Neo4j ETL 1.4.2
SQL Server 2019 and JDBC 7.2.2.jre8.jar
ETL able to test and connect to SQL Server
Able to complete Mapping
Able to Save Mapping and go to Import process
The follow information error occurs when trying to import. Searched for the file neo4j-import.ba but cannot find the file - appears it was not created.
Import your data into Neo4j
Press the button and start import your data
FROM
Connection name:
From database: KMERSQL
Of type: MSSQL
trending_flat
Bulk Import
TO
Instance name: SEQUENCE
Version: 4.0.1 - enterprise (LOCAL)
Status: STOPPED
COMMAND: java -cp "D:\NEO4JDB\graphApps_global\neo4j-etl-ui/dist/neo4j-etl.jar;C:\Program Files\Microsoft JDBC Driver 7.2 for SQL Server\sqljdbc_7.2\enu\mssql-jdbc-7.2.2.jre8.jar" org.neo4j.etl.NeoIntegrationCli export --mapping-file "C:\Users\weberp6\AppData\Local\Temp/mssql_KMERSQL_mapping.json" --destination "D:\NEO4JDB\neo4jDatabases\database-ca3845ba-c9f3-427a-8510-c59ff87ee58f\installation-4.0.1/data/databases/graph.db/" --import-tool "D:\NEO4JDB\neo4jDatabases\database-ca3845ba-c9f3-427a-8510-c59ff87ee58f\installation-4.0.1/bin" --rdbms:password "2020Shadow02291996!" --rdbms:user "sa" --rdbms:url "jdbc:sqlserver://localhost:1433;databaseName=KMERSQL" --csv-directory "C:\Users\weberp6\AppData\Local\Temp" --options-file "C:\Users\weberp6\AppData\Local\Temp/import-tool-options.json" --using "bulk:neo4j-import" --neo4j:url "bolt://localhost:7687" --neo4j:user "neo4j" --neo4j:password "12345" --force - Command failed due to error (IllegalArgumentException: Unable to find import tool: D:\NEO4JDB\neo4jDatabases\database-ca3845ba-c9f3-427a-8510-c59ff87ee58f\installation-4.0.1\bin\neo4j-import.bat). Rerun with --debug flag for detailed diagnostic information.