Spotfire Connector Setup

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

Datalogz' Spotfire connector directly extracts metadata from your Oracle database. Support for other database types isn't available at this time.

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:

Parameter	Description
Username	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.
Password	The secret string associated with the database username, used for authenticating with the external database.
Hostname	The network address (domain name or IP address) of the database server where your data resides.
Protocol	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.
Service Name / SID	Specific to Oracle databases.<br/>- Service Name: A logical name identifying an Oracle database instance or group of instances (preferred, modern).<br/>- SID (System Identifier): A unique name for a specific Oracle database instance (older, still used).
Is SSL Connection?	A boolean flag indicating whether the communication between Spotfire and the database should be encrypted using SSL/TLS.

• For the DSN connection:

Parameter	Description
Username	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.
Password	The secret string associated with the database username, used for authenticating with the external database.
Have DSN string?	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.).

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.

For more questions, please contact Datalogz support [e-mail]