cancel
Showing results for 
Search instead for 
Did you mean: 

Neo4j ETL Mapping error

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

3 REPLIES 3

Hello,

I have the same problem, did you find a solution? please HELP

Hello,

I am facing the same error. Did y'all find any solution?

Any help would be appreciated. Thankyou!

vedant1966
Node

The solution that worked for me is, give <database_name>.<schema_name> in schema field. And also specify the same in url format of jdbc string.  For example below format works for snowflake database:

jdbc:snowflake://<myorganization-myaccount>.snowflakecomputing.com/?db=mydb&schema=mydb%2Emyschema

In above string, mydb is database name, myschema is schema name.
Note: %2E stands for "." in url parameters.