Reference

Authentication Neo4j AuraDB Connection (SQL queries)

Description

No description available [API reference]

Instructions

Neo4j JDBC (full bundle) from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. Copy the Aura connection URI host (something like 1234abcd.databases.neo4j.io). This Auth uses neo4j+s plus SQL translation.
  2. Create a database user in Neo4j Desktop, Aura console, or CREATE USER. Paste user and password.
  3. After Finish, replace the host (e.g. MyHostName) on the DSN Main UI. Aura always uses TLS (neo4j+s).
  4. Do not use a personal employee login for unattended Linked Server or Power BI refresh.
  5. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  6. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Neo4j\neo4j-jdbc-full-bundle-6.3.1.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: UserName

Label: User name

Aura user (often neo4j). Copy from the Aura console. 		YES
Name: Password

Label: Password

Aura instance password from the console. Do not check it into XML or TFVC. 		YES
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.neo4j.jdbc.Neo4jDriver). 		org.neo4j.jdbc.Neo4jDriver