Hello There,
I am trying to import Northwind data (from SQL Server) to neo4j DB, but encountering the Mapping error. The connection seems to be fine but for some reason the json mapping file is empty(mssql_Northwind_dbo_mapping.json). Not sure what I am doing incorrectly. I appreciate any help in fixing this issue.
COMMAND: java -cp "C:\Users\ABC_000.Neo4jDesktop\graphApps_global\neo4j-etl-ui/dist/neo4j-etl.jar;C:\Program Files\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\jre8\sqljdbc42.jar" org.neo4j.etl.NeoIntegrationCli generate-metadata-mapping --rdbms:url "jdbc:sqlserver://XXX.XXX.XXX.XXX:1433;databaseName=Northwind" --rdbms:password "test" --rdbms:user "testuser" --schema "dbo" --output-mapping-file "C:\Users\ABC_~1\AppData\Local\Temp/mssql_Northwind_dbo_mapping.json"
-
Skipping reading import options from file because file doesn't exist.
-
Creating RDBMS to CSV mappings...
-
Using database plugin for
-
Crawling schemas
-
Retrieving all schemas
-
Retrieving all catalogs
-
Processed 13 rows for
-
Retrieved 0 schemas
-
Total time taken for - 00:00:00.070 hours
-
98.6% - 00:00:00.069 -
-
1.4% - 00:00:00.001 -
-
Command failed due to error (SQLException: No matching schemas found). Rerun with --debug flag for detailed diagnostic information.
Thanks.
Karthic