This article describes how to use the BI Connector integration with Tableau Desktop.
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.
Install BI Connector on Tableau Desktop
The first step is to ensure the JAR file has been installed on Tableau Desktop as the data source must be published from Desktop to Server. Install the plugin by dropping the JDBC JAR file in to the appropriate driver directory depending on the platform:
Windows: `C:\Program Files\Tableau\Drivers` Mac: `~/Library/Tableau/Drivers` Linux: `/opt/tableau/tableau_driver/jdbc`
Create datasource to connect to a Neo4j instance
Using Tableau’s “Other JDBC Connection” option, you need to create a datasource connected to a Neo4j instance using the appropriate JDBC connection string. For example:
Enter the appropriate credentials in to the connection dialog and you should be able to connect.
Query for some data
Once connected, select the appropriate database on the left side of the screen, following by the appropriate schema (“Node” or “Relationship”). This should present a set of found tables. You can drag these tables to create join queries to pull data from Neo4j.
The driver provides for a number of additional options. See the BI Connector user guide (packaged with the JAR file) for details.
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. ”’
- Last Modified: 2020-09-15 13:07:09 UTC by Shashi Dookhee.
- Relevant for Neo4j Versions: 3.5, 4.0.
- Relevant keywords jdbc, sql, tableau, visualization, bi-connector.