How to install IBM DB2 driver to enable IBM DB2 Data Connector option inside TIBCO Spotfire Analyst.

How to install IBM DB2 driver to enable IBM DB2 Data Connector option inside TIBCO Spotfire Analyst.

To enable an IBM DB2 data connector in TIBCO Spotfire Analyst, the corresponding IBM DB2 ODBC CLI driver needs to be installed on the machine where TIBCO Spotfire Analyst is installed. Follow the steps below.

1). Create a folder with a name - "IBM" inside C:\Program Files.

2). Un-compress the downloaded driver file and copy the contents inside the folder created above, i.e. inside C:\Program Files\IBM.

3). Open the command prompt (cmd) with Administrator rights.

4). Run the command -> cd C:\Program Files\IBM\bin

5). Execute the command -> db2cli install -setup 

6). After running the command above, the following message will be displayed - "IBM Data Server Driver for ODBC and CLI" is registered successfully.
See the attached (Filename: IBMDB2.PNG).

Launch Spotfire Analyst and if the IBM DB2 connector option is still not enabled then follow KB Article - 000029189 (IBM DB2 driver installed but Spotfire data connector is still disabled).

• TIBCO Spotfire Connector System requirements:
  • https://docs.tibco.com/pub/spotfire/general/sr/GUID-71EDC198-D037-4A3B-B296-4B3EC2CAA0CC.html
• TIBCO Spotfire® Database Drivers:
  • https://community.tibco.com/wiki/tibco-spotfirer-database-drivers
• DB2 ODBC CLI driver Download and Installation information (IBM Support site):
  • http://www-01.ibm.com/support/docview.wss?uid=swg21418043