Making an ODBC Connection to Neo4j from Excel (on macOS)
Neo4j’s BI Connector returns tabular data over JDBC, using the SQL-92 query language.
OpenLink Software’s ODBC-to-JDBC Bridge Driver extends accessibility of that same data to ODBC-Compliant applications, such as Microsoft Excel for macOS.
Prerequisites
- Working ODBC Data Source name that refers to a Neo4j BI Connector JDBC URL (Guide)
- Microsoft Excel for macOS
Setup
- Launch Microsoft Excel; create or open a Workbook; and drill down to Data → Get External Data → From Database.
2. Select your Neo4j ODBC DSN, and click OK.
3. Enter your Neo4j username and password, and click OK. This is required even if the JDBC Connection URL for your ODBC DSN contains your username and password.
Querying and Returning Data
A successful connection will bring up a new Microsoft Query window. The JDBC Server navigation menu shows each graph that has been translated to a SQL table.
- Build or paste your SQL query and click Run. Do not include a semicolon (
;) at the end of your query; it will result in a syntax error, or no data being returned.
2. Click Return Data, select where the imported data should be placed in your workbook, and click OK.
3. Your query will be re-run, and returned query results will be imported to your selected destination.
