The TileDB Cloud JDBC library can be configured programmatically in your Java code. The configuration options include:

• apiKey(String): Your TileDB-Cloud API Token. (recommended)

• username(String): Your TileDB-Cloud username

• password(String): Your TileDB-Cloud password

• rememberMe(boolean): Whether the JDBC driver will remeber your login credentials in the future.

• verifySSL(boolean): Whether the JDBC driver will use SSL

• overwritePrevious(boolean): Whether the JDBC driver will overwrite existing credentials. This option can be combined with rememberMe.

Here's an example of configuring the driver where NAMESPACE is your TileDB-Cloud namespace

You can also include your API Token in the connection String like this:

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.

Once you have established a connection, you can execute SQL queries against the TileDB Cloud database. To do so, create a Statement object and call the executeQuery method with your SQL query.

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM `tiledb://TileDB-Inc/quickstart_sparse`");

You can then handle the results like this:

while (rs.next()) { 
int rows = resultSet.getInt("rows"); 
// Process the retrieved values 
}

TileDB-Cloud-JDBC is a type 4 Java Database Connectivity (JDBC) driver that allows you to connect to and interact with TileDB Cloud using the JDBC API. It provides a seamless integration between your Java applications and TileDB Cloud, enabling you to perform various database operations and execute SQL queries.

This documentation will guide you through the installation process, configuration options, and usage examples of the TileDB Cloud JDBC library.

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.

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

To use the TileDB Cloud JDBC library, follow these steps:

1. Ensure you have Java Development Kit (JDK) version 11 or higher installed on your system.

2. Download the latest release of the TileDB Cloud JDBC library from the .

3. Add the tiledb-cloud-jdbc-x.x.x.jar file to your project's classpath. Replace x.x.x with the version number of the library.

4. To load the driver at runtime write Class.forName("io.tiledb.TileDBCloudDriver")

• Query results are limited to 2GBs in size.

• This JDBC driver uses our custom Mytile MariaDB storage engine which comes with it's limitations as well. For more info see here.