TIBCO SPOTFIRE CLIENT – How to Open Direct Connection to Oracle Database

First time using Tibco Spotfire softwares can be a bit confusing, and the not very comprehensive manuals is not really helping too..

Before you go reading any further, take a note that this How To is for those who want to open data from the “File – Open From – Database” menu on the Spotfire Client.

If you want to open data for developing dashboards you should prefer to create Datasource objects, Column objects, and Information Link objects from the Information Designer menu.

So assuming that there is an Oracle DB server somewhere and you want to connect to that from your Spotfire Client installed on your PC. This means that your PC is a client. Connecting to the DB server from a third party software requires you to install an Oracle Client.

So the first step will be to instal Oracle Client.

  1. Download and Install latest version of Oracle Client, for me its ODAC1120320_x64

Configuring database connection in Spotfire requires a server name so we have to make an alias for the Oracle database host to be connected.

Create an alias in the Oracle Client for a database host:

  1. Create an alias in tnsnames.ora in client folder:
    1. Open C:\oraclexe\app\oracle\product\11.2.0\client_1\Network\Admin\tnsnames.ora, add the following lines:

<tns name> =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = <host  ip>)(PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <SID or service name>))

)

Check connection:

  • Open cmd
  • Sqlplus <user>@<tns name>
  • Enter password

 

Connect using OracleClient Data Provider:

  1. On Spotfire:
    1. Open from Database
    2. Choose OracleClient Data Provider
    3. Open Configuration window, enter the TNS name/alias into Oracle Server Name, enter the Username and Password.
    4. Click OK to save Configuration
    5. Click OK again.

 

Connect using ODBC Data Provider:

  1. Create Datasource:
    1. Open Control Panel – Adminitrative Tools – Data Sources (ODBC)
    2. Add – Oracle in OraClient11g_home1
    3. Define Data Source Name
    4. Type the TNS Service Name
    5. Type the Username
    6. Test Connection
  2. On Spotfire:
    1. Open from Database
    2. Choose ODBC Data Provider
    3. Enter the ODBC object created at step 3
Advertisements

TIBCO SPOTFIRE CLIENT – connecting to MYSQL Datasource

Connecting to an Oracle MYSQL Server from Spotfire Datasource & Information Link objects is easy to do. It requires no installation and and only a few additional settings on the Spotfire Server.

Here is the steps:

  1. Download the latest MYSQL Connector library for java:

mysql-connector-java-5.0.8-bin.jar

  1. Place the library into Spotfire Server tomcat lib folder, in my case it is:

C:\tibco\tss\5.5.0\tomcat\webapps\spotfire\WEB-INF\lib\

3.  Open the “Configure TIBCO Spotfire Server” app:

  • Open Configuration Tab – Data Source Templates
  • Enable MYSQL5
  • Save Configuration

4.  Restart the Spotfire Server. Go to Control Panel – Administrative Tools – Services (or simply type services.msc at the Windows Run window), search for TIBCO Spotfire Server and click Restart.

 

It’s done. Open the Spotfire Client, connect to the server, open Information Designer, Setup Data Source. MYSQL5 Data Source Type will be available on the dropdown list.

Notes:

MYSQL (DataDirect) Data Source Type only supports MYSQL Commercial version, doesn’t work with the Community version.