This article describes how to use the BI Connector integration with SQLLine.
Ensure that you are running Neo4j server 3.5.x or 4.x, and have installed at least version 18.104.22.168 or 22.214.171.124 of the APOC library respectively.
Build the SQLLine package from source:
SQLLine comes with a shell script that knows how to launch it correctly. But before we run it directly, make sure that we have our Neo4j BI Connector JAR file in the right place. In this example, we’ll assume it’s in the SQLLine target folder (where the source build placed its JAR files) because that way it will automatically be on the classpath.
Set the environment variables for connection:
Connecting to the database
Perform the connection:
Use the “!tables” command at the SQL prompt to get a list of tables. Perform a select query to verify the connection:
Things to watch out for
For performance reasons ensure that the Neo4j server has adequate resources. The driver may “overfetch” data depending on the query, so adequate resources (especially memory) would make a noticeable impact.