# Spotfire

This guide will walk you through how to set up a Spotfire connector in Datalogz. 

{% hint style="info" %}
Datalogz' Spotfire connector directly extracts metadata from your Oracle database. Support for other database types isn't available at this time.
{% endhint %}

### Prerequisites:

1. Hostname, the address at which we access Spotfire.
2. A username and password that can connect to the Spotfire server.
3. A service name
4. (Optional) The Oracle protocol
5. Determine your connection method: via hostname and SID or DNS

### Step 1: Connect to Spotfire in Datalogz' Control Tower

1. Log in to your Datalogz account.
2. Go to **Settings** > **Connector**.
3. Click **New Connector** > **Spotfire**.
4. Enter the connection details.

* For the hostname/SID connection:

<figure><img src="/files/ePXe7HQrB68XzaPr6hBJ" alt="" width="375"><figcaption></figcaption></figure>

<table><thead><tr><th width="182.45703125">Parameter</th><th>Description</th></tr></thead><tbody><tr><td>Username</td><td>The user account credential for logging into the external database (not your Spotfire user). This user must have permissions to access the data Spotfire needs.</td></tr><tr><td>Password</td><td>The secret string associated with the database username, used for authenticating with the external database.</td></tr><tr><td>Hostname</td><td>The network address (domain name or IP address) of the database server where your data resides.</td></tr><tr><td>Protocol</td><td>The specific communication method or standard used by Spotfire to interact with the database server. While often implicit with the chosen connector, it ensures the correct "language" is spoken.</td></tr><tr><td>Service Name / SID</td><td><p>Specific to Oracle databases.</p><ul><li>Service Name: A logical name identifying an Oracle database instance or group of instances (preferred, modern).</li><li>SID (System Identifier): A unique name for a specific Oracle database instance (older, still used).</li></ul></td></tr><tr><td>Is SSL Connection?</td><td>A boolean flag indicating whether the communication between Spotfire and the database should be encrypted using SSL/TLS.</td></tr></tbody></table>

* For the DSN connection:

<figure><img src="/files/5ekCkmTVa7OG1SmYGbyp" alt="" width="375"><figcaption></figcaption></figure>

<table><thead><tr><th width="189.359375">Parameter</th><th>Description</th></tr></thead><tbody><tr><td>Username</td><td>The user account credential for logging into the external database (not your Spotfire user). This user must have permissions to access the data Spotfire needs.</td></tr><tr><td>Password</td><td>The secret string associated with the database username, used for authenticating with the external database.</td></tr><tr><td>Have DSN string?</td><td>Indicates whether Spotfire should use a pre-configured Data Source Name (DSN) on the system to connect to the database. A DSN is a stored configuration that contains all the underlying connection details (hostname, database name, driver, etc.).</td></tr></tbody></table>

Click **Connect**.

### Step 2: Choose Connector Components

1. Select the asset information you want to ingest in Datalogz' Control Tower.
2. Set a synchronization schedule.
3. Click **Next**.
4. Review the setup and click **Confirm and Finish**.

Once you confirm and finish the connector setup, it will run automatically.&#x20;

For more questions, please contact Datalogz support <support@datalogz.io>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.datalogz.io/guides/organizational-setup/bi-connectors/spotfire.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.