Auth Notes (numbered steps), documented params, Maven DriverDownloadLinks, extra SQL examples for ODBC apps. Initial version. 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. This Auth sets enableSQLTranslation=true so you can run SQL such as SELECT * FROM Movie from Power BI.
  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.
]]> 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. This Auth omits SQL translation. Use Cypher (MATCH ... RETURN) from the DSN query window.
  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.
]]> 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. This Auth sets enableSQLTranslation=true so you can run SQL such as SELECT * FROM Movie from Power BI.
  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.
]]> 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. This Auth omits SQL translation. Use Cypher (MATCH ... RETURN) from the DSN query window.
  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.
]]> 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.
]]> 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. Same Aura host as SQL Auth, but Cypher only (no 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.
]]> Gets all nodes labeled Movie using SQL translation. Use in Power BI when you want a table-shaped extract.

]]> Gets Movie nodes with Cypher. Use the Cypher Auth (no enableSQLTranslation).

]]> Joins Person, ACTED_IN, and Movie. Relationship columns use the v$ prefix.

]]> Matches (Person)-[ACTED_IN]->(Movie) and returns actor, title, and roles.

]]> (m:Movie) RETURN p.name AS Actor, m.title AS Movie, r.roles[0] AS FirstRole, r.roles[1] AS SecondRole, r.roles AS AllRoles, p {.*} AS ActorAllFields, m {.*} AS MovieAllFields]]> Lists graph labels. Use this in a Linked Server to confirm the catalog before building reports.

]]> Returns how many Movie nodes exist. Works with SQL translation Auth.

]]> Returns movies released in or after 2000. SQL translation Auth.

]]> = 2000]]> Returns the first 100 Movie rows. Useful for Excel preview.

]]>