> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Kinetica Geospatial Visualization for Tableau

*Kinetica* offers a geospatial visualization extension for *Tableau* that allows
users to visualize maps from *Kinetica*-hosted datasets. There are four integral
parts to this extension:

* The manifest file, `KineticaTableauMapExt.trex`
* A *Tableau* instance (*Tableau Desktop*, *Tableau Online*, or *Tableau Server*
  are all applicable)
* A *Kinetica* instance
* An extension server that connects the *Tableau* extension to *Kinetica*

This document will walk through installation and configuration of the extension
within your *Tableau* instance.

<a id="tableau-geo-ext-prereqs" />

## Prerequisites

First, you'll need to decide between using the public or the private/internal
extension server. Whichever is selected, *Tableau* requires that the extension
server be configured for SSL. The public extension server is provided by
*Kinetica*, does not require your own database instance to use, and already has
SSL configured. If using the public extension server, there's nothing to
configure or setup.

The private/internal extension server relies on your own *Kinetica* instance and
database login information.  If using the private/internal extension server,
you'll need to ensure that it's setup for SSL connections. See the
[Private installation instructions](/content/bi/tableau/kin_geo_viz_tableau#geo-viz-ext-install-private)
for more information.

Next, you'll need to make sure the manifest file is available locally. The
extension file can be downloaded from the following locations:

* *GAdmin*
* the *Kinetica* documentation site (click
  [here](https://raw.githubusercontent.com/kineticadb/kinetica-docs/master/content/bi/tableau/KineticaTableauMapExt.trex))
* the *Tableau* extension gallery

Last, ensure you've met the following additional prerequisites:

* Access to a running *Tableau* instance
* Access to a running *Kinetica* instance (if using the private extension
  server)
* (Optional) *JDBC* / *ODBC* connection between *Tableau* and *Kinetica*

  <Tip>
    Download the *JDBC*
    [JAR from GitHub](https://github.com/kineticadb/kinetica-client-jdbc)
    and follow the
    [Tableau connection guide](https://help.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm)
    to set up a *JDBC* connection. Visit the
    [SQL Connector](/content/connectors/sql_guide) page for information
    on setting up an *ODBC* connection. Note that *ODBC* may have better
    performance than *JDBC*, but *JDBC* is compatible with *macOS*
    environments.
  </Tip>

<a id="tableau-geo-ext-installation" />

## Extension Installation

### Public

If using the public extension server, download the
[.trex file](https://raw.githubusercontent.com/kineticadb/kinetica-docs/master/content/bi/tableau/KineticaTableauMapExt.trex) and install the
extension in your *Tableau* environment using the
[Use Dashboard Extensions](https://help.tableau.com/current/pro/desktop/en-us/dashboard_extensions.htm)
documentation.

<a id="geo-viz-ext-install-private" />

### Private

If using the private extension server:

1. Follow the [configuration instructions](/content/security/sec_configuration#sec-config-ssl-components)
   for enabling SSL for *GAdmin*.
2. Download the [.trex file](https://raw.githubusercontent.com/kineticadb/kinetica-docs/master/content/bi/tableau/KineticaTableauMapExt.trex).
3. In a text editor, edit the `.trex` file to update the source location URL
   for the private extension server URL, e.g.:

   ```
   <source-location>
     <url>https://<hostname>/tableau/</url>
   </source-location>
   ```
4. Install the extension in your *Tableau* environment using the
   [Use Dashboard Extensions](https://help.tableau.com/current/pro/desktop/en-us/dashboard_extensions.htm)
   documentation.

<a id="tableau-geo-ext-config" />

## Configuration

Once the extension has been loaded, you may configure it via menu options.
Configuring for demo mode is slightly different than configuring for a
*Kinetica* instance, but you can always switch to the other option as needs
change.

<a id="tableau-geo-ext-demo" />

### Demo Mode

1. Open the drop-down menu for the extension.
2. Click **Configure...**.
3. For the **Demo Mode**, select **Enabled**.
4. Click **Save Configuration**.

### Kinetica Instance

1. Open the drop-down menu for the extension.
2. Click **Configure...**.
3. Add a **Username** and **Password** for a user
   that is able to access the database.
4. Optionally, for the **XYZ Basemap Tile Service URL**, add a
   custom basemap URL.
5. Leave **Demo Mode** as **Disabled**.
6. Click **Save Configuration**.

<Tip>
  You can opt to enable **Demo Mode** even when using a
  *Kinetica* instance to have access to the demo tables.
</Tip>

## Usage

To update the map:

1. Click **Map Settings** in the top right corner.

2. Select a **Table**.

   <Tip>
     If **Demo Mode** was enabled, there will be a few
     demo datasets available for use.
   </Tip>

3. Update the settings as necessary.

4. Click **Update**.

Use the scroll wheel on your mouse or the controls in the top left corner of the
map to zoom in and out. Click the map to see records near that click.

<Tip>
  If using a *ODBC* / *JDBC* connection in conjunction with the
  extension, you can filter the data in the dashboard and see those filters
  reflected in the extension map.
</Tip>