Tableau

Tableau is a leading commercial BI platform. It connects to ArcadeDB via the built-in PostgreSQL connector.

Setup

  1. In Tableau Desktop, go to Connect > To a Server > PostgreSQL.

  2. Enter the connection details:

    Server

    localhost

    Port

    5432

    Database

    Your ArcadeDB database name

    Username

    Your ArcadeDB username

    Password

    Your ArcadeDB password

    Require SSL

    Unchecked

  3. Click Sign In.

Usage

For the best experience with ArcadeDB, use Custom SQL rather than dragging tables:

  1. In the Data Source tab, click New Custom SQL.

  2. Enter your query:

    SELECT name, age, city FROM Person

    Or with graph traversal:

    SELECT name, out('FriendOf').size() AS friendCount, city
FROM Person

  3. Click OK. Tableau executes the query and shows the result schema.

  4. Drag fields to rows/columns to build visualizations.

Cypher queries work via the language prefix in Custom SQL:

{cypher}MATCH (p:Person)-[:FRIEND_OF]->(f:Person)
RETURN p.name AS person, p.city AS city, COUNT(f) AS friendCount
Use Import mode (extract) rather than Live Connection for large datasets or when ArcadeDB-specific SQL extensions cause issues with Tableau’s query rewriting.

Known Limitations

  • Schema discovery may show incomplete table/column lists - prefer Custom SQL

  • Tableau may rewrite queries using PostgreSQL-specific syntax that ArcadeDB does not fully support

  • Relationships between tables must be defined manually via Custom SQL

  • No built-in graph/network visualization type

  • SSL is not supported - ensure "Require SSL" is unchecked