Tibco Spotfire/Phoenix Integration

[#1]

Tibco/Spotfire JDBC Connection to Phoenix on Kerberized Cluster

Versions :

Tibco Spotfire : 7.5

Phoenix: 4.4

HDP : 2.4.x

Issues: Phoenix Client Jars from HDP cluster has dependency conflicts with Spotfire Jars.

Step 1: Use the Phoenix core jar with below dependencies to avoid the conflicts

1) hbase-client

2) phoenix core

3) betty-all

4) zookeeper

5) hbase-protocol

6) commons-lang

7) commons-configuration

😎 protobuf-java

9) hbase-server

10) guava

11) hadoop-auth

12) hadoop-common

13) commons-collections

14) htrace-core

15) phoenix-core

16) hbase-common

Step 2: Add the krb5.conf file from the cluster to JDK_HOME/jre/lib/security/ that Spotfire is using. The JDK could be embedded in tomcat of spotfire or external.

Step 3: Add hbase-site.xml, core-site.xml & hdfs-site.xml to a folder on the spotfire server. And add the folder to the class path in tomcat startup script. In Windows, this is tomcat service bat file.

Step 4: On Windows, service has to be removed and installed again using the below

Through command line go to <TIBCO_HOME>\tss\7.6.0\tomcat\bin

a) service remove

b) service install

Step 5: In Spotfire add the Data Source using the below JDBC url and save the connection

Jdbc:phoenix:<zookeeper_quorum>:2181:/hbase-secure:<principal>:<local_path_to_keytab_file>/hbase.headless.keytab

[#2]

For Spotfire 7.6 and HDP 2.6, Below are the Jars required.

phoenix-core-4.7.0.2.6.0.3-8.jar

netty-all-4.0.23.Final.jar

hadoop-common.jar

hadoop-auth.jar

zookeeper.jar

htrace-core-3.1.0-incubating.jar

commons-collections-3.2.2.jar

hbase-server.jar

commons-configuration-1.6.jar

hbase-common.jar

hbase-protocol.jar

hbase-client.jar

twill-discovery-api-0.6.0-incubating.jar

twill-zookeeper-0.6.0-incubating.jar

tephra-api-0.6.0.jar

tephra-core-0.6.0.jar