Spotfire

This guide sets up the Spotfire connector. Datalogz extracts Spotfire metadata directly from the underlying Oracle repository database; support for other repository database types is not available at this time. Datalogz reads metadata only.

Before you start

Have the following ready, and decide whether you will connect via hostname and Service Name/SID or via DSN:

• The hostname of the database server.

• A database username and password with access to the Spotfire repository.

• The Oracle Service Name or SID (for hostname connections) or the DSN.

• Optionally, the Oracle protocol (TCP or TCPS for SSL).

Create the connector in Control Tower

1. Sign in to Datalogz Control Tower and go to Settings > BI Connectors.

2. Click New Connector and select Spotfire.

3. Enter the connection details for your chosen method (see the parameter reference below), then click Connect.

4. Enter a Connector Name and select the snapshot frequency (for example Daily or Weekly).

5. Click Next, then Confirm and Finish.

Parameter reference

Parameter	Description
Username	The database user for the Oracle repository (not your Spotfire user). Must have read access to the Spotfire metadata.
Password	The password for that database user.
Hostname	The network address (domain name or IP) of the database server.
Protocol	The communication method used to reach the database. TCPS enables SSL/TLS encryption.
Service Name / SID	Oracle identifiers for the database instance. Service Name is the modern, preferred option; SID is the older form.
DSN	For DSN connections: the data source name configured for the repository database.
Is SSL Connection?	Whether communication with the database is encrypted using SSL/TLS.

For questions or help with this setup, contact [e-mail].