The TileDB-Cloud JDBC driver provides seamless integration with popular Business Intelligence (BI) tools such as Tableau and Microsoft Power BI. With the driver, you can connect your BI tools directly to TileDB Cloud and leverage the powerful visualization and analytics capabilities of these tools.

Power BI, in conjunction with TileDB, offers a comprehensive business intelligence platform that enables users to connect, transform, and visualize data stored in TileDB Cloud. With Power BI's intuitive interface and robust analytics features, organizations can gain valuable insights, create interactive reports and dashboards, and make data-driven decisions effectively.

Set up

In order to use the JDBC driver for Power BI, a JDBC-to-ODBC bridge is required. We have used and tested the one from ZappySys. Follow the instructions below:

Then, click ok and your bridge should be set up. Now, open PowerBI Desktop and follow these steps:

1. Click on "Get Data" in the Home tab.

2. Select "More..." and search for "ODBC" in the data connectors list.

3. Choose the "ODBC" option and click "Connect".

4. In the ODBC dialog, select the bridged JDBC driver as a data source from the list.

5. By expanding the "Advanced options" section you can insert a custom SQL query. Otherwise click next and you will be displayed your owned, shared and public arrays from TileDB-Cloud

Tableau is a leading business intelligence and data visualization tool that allows users to create interactive and insightful visualizations, reports, and dashboards. Together with TileDB, Tableau empowers users to connect, explore, and visualize their data stored in TileDB Cloud, enabling seamless integration of advanced analytics and visualization capabilities into their data workflows.

To connect with Tableau, the TileDB-Cloud JDBC driver requires the use of our custom Tableau Connector. Tableau has a built-in store for connectors, however, this TileDB connector is not currently available for download and needs to be manually placed in the appropriate directory.

To do this, copy the connector directory from the repo (ignoring the LICENSE and README files) to the following location:

• MacOS ~/Documents/My\ Tableau\ Repository/Connectors

• Windows C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors

Step 2:

In addition to the connector placement, ensure that you have also placed the TileDB-Cloud JDBC driver (.jar file) in the appropriate directory. If the directory doesn't already exist, create it.

• MacOS ~/Library/Tableau/Drivers

• Windows C:\Program Files\Tableau\Drivers

Step 3:

To launch Tableau, use the following commands:

• MacOS /Applications/Tableau\ Desktop\ [version].app/Contents/MacOS/Tableau -DConnectPluginsPath=/Users/<USER>/Documents/My\ Tableau\ Repository/Connectors

• Windows tableau.exe -DConnectPluginsPath=C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors

Step 4:

Once Tableau launches, choose TileDB-Cloud JDBC, by TileDB from the left sidebar and enter your credentials to login.

Step 5:

Once you login choose All TileDB arrays from the dropdown menu on the top left corner and you will be able to see all your owned and shared arrays. You can also add an array you have access to by using the Custom SQL Query option.