Configure Spotfire Analyst with Apache Spark using Information links

[Dustin Mobley]

Hello.

Has anyone successfully configured Spotfire Analyst information Links with Apache Spark

[Prashant Anand]

Hello Dustin,

You can set up any jdbc data source as long as you have the correct data source template and the correct jar files in Spotfire library.

Please use the link to create a data source template for Apache spark.

=====

https://community.spotfire.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-2

=====

 

The following JDBC template format can be used.

=====

 

name

driver class

url

 

=====

 

You can try downloading the spark jdbc jar file from one of the following links and put it in the"/tss//tomcat/lib" folder.

=====

https://mapr.com/docs/61/Spark/SparkJDBCODBCDrivers.htmlhttps://www.simba.com/drivers/spark-jdbc-odbc/

=====

[Dustin Mobley]

Could I use the template that i am currently using for "Apache Cassandra" Here is what I have for "Apache Cassandra"

<jdbc-type-settings>
  <type-name>Cassandra</type-name>
  <driver>com.github.adejanovski.cassandra.jdbc.CassandraDriver</driver>
  <connection-url-pattern>jdbc:cassandra://10.5.12.24:9042/sme</connection-url-pattern>
  <metadata-provider>com.tibco.spotfireps.server.is.CassandraJDBCMetadataProvider</metadata-provider>
  <sql-runtime>com.tibco.spotfireps.server.is.CassandraSQLRuntime</sql-runtime>
  <supports-catalogs>true</supports-catalogs>
  <supports-schemas>true</supports-schemas>
  <supports-procedures>false</supports-procedures>
  <table-types>TABLE, VIEW</table-types>
  <table-expression-pattern>[$$schema$$.]$$table$$</table-expression-pattern>
  <ping-command></ping-command>
</jdbc-type-settings>

[Dustin Mobley]

Ok. I will start with the template you suggest.

 

<jdbc-type-settings>

 

  <type-name>name</type-name>

 

    <driver>driver class</driver>

 

  <connection-url-pattern>url</connection-url-pattern>

 

</jdbc-type-settings>

 

When I look at the link you provided  of https://community.spotfire.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-2

 

I dont see an Apache Spark Example.

 

 

 

 

 

 

[Prashant Anand]

Dustin,

 

Not sure about using Apache cassandra template but there are some customers who were able to use Hive data source template and driver to connect to spark data source. You can try that. Below is the link for hive data source.

 

https://community.spotfire.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-9