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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s