URL to use to connect a neo4j database from Aura to Tableau or Power BI

[saloua_bennani9]

Hi,

I have created a neo4j database in Aura and I need to connect it to Tableau or Power BI to do some reporting. The connexion does not succeed. I'm not sure what is the URL for the neo4j server in case of a database created in Aura.. My url is something like neo4j+s://xxxxx.databases.neo4j.io so I'm a little bit confused.

Thank you for any clue...I'm new to neo4j

[michael_hunger]

That URL should work, what kind of error are you're getting with the BI connector?

Did you follow the BI connector docs?

Neo4j Graph Database Platform

Neo4j Connector for BI

The Neo4j BI Connector delivers direct access to Neo4j graph data from business intelligence (BI) tools such as as Tableau, Looker, TIBCO Spotfire Server and Microstrategy.

Neo4j Graph Database Platform

What Works with the BI Connector - Knowledge Base

This article provides an overview of what third-party applications to expect the BI connector work with. Prerequisites Ensure that you are running Neo4j server 3.5.x or 4.x, and have installed…

Neo4j Graph Database Platform – 24 Mar 20

Getting Started with the Neo4j BI Connector

Learn how to get started with the Neo4j BI Connector, which provides easy access to Neo4j datasets from popular BI tools like Tableau and more.

[saloua_bennani9]

Thank you.

Yeah, I have the Neo4j BI connector under the drivers folder of Tableau. when I try connecting Neo4j, I have the following error

when i try to put the whole url: neo4j+s://xxxxx.databases.neo4j.io i have an error that the driver is not isntalled.

I'm a little bit confused: When i connect a DB from my localhost, the connection is established. Also when i connect a DB with a regular address IP it works.
I'm only facing this problem with a db created in Aura.

Thank you for your help

[david_allen · Accepted solution]

You can find the full documentation here: https://s3-eu-west-1.amazonaws.com/dist.neo4j.org/Neo4j-BI-Connector-1.0.8-docs.pdf

The connection string you should use for JDBC would look like this:

jdbc:neo4j://mydbid.databases.neo4j.io?SSL=true

Note that in JDBC, you always have to start with "jdbc:neo4j" this tells your java layer which driver to use, the JDBC one provided by Neo4j.

[dom]

I also have this exact same issue connecting Tableau to Aura. Same error message

[dom]

@saloua.bennani91 Did you manage to find any solution here?

@michael.hunger Can you replicate this on your end, am I correct to say that BI Connector is currently incompatible with an Aura DB?

[david_rosenblum]

Please Note: This has nothing to do with it being Aura or not. Any ssl protected Neo4j database, whether on-prem, in the cloud, or Aura will need to use SSL=true with the BI Connector.