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
... View more
