Description:
Spotfire - Create Linked Resource in Information Designer using AS-JDBC driver.

How to create a Linked Resource in Information Designer using AS-JDBC driver in Spotfire.

Product: TIBCO ActiveSpaces Version: AS 2.1.6/2.2.0 OS: All Supported Operating Systems --------------------

Sample source code for the  AS-JDBC driver (normal connection) is available at AS-HOME/examples/java/JDBCDriver. To be able to connect to a secure metaspace, it is required to update/add two Java source files (UpdatedJDBC-java.zip). Use ANT to build the as-jdbcdriver.jar.

Required steps to add a Spotfire Linked Resource using AS-JDBC driver (supports secure metaspace).

1). Copy new Java source files to AS-HOME/examples/java/JDBCDriver/src/com/tibco/as/jdbc .

2). Build as-jdbcdriver.jar using ANT.

3). Copy as-jdbcdriver.jar to $TIBCO_HOME/tss/<version>/tomcat/lib .

4). Copy all files from AS_HOME/lib to $TIBCO_HOME/tss/<version>/tomcat/lib .

5). Open "TIBCO Spotfire Server Configuration Tool".

6). Create a DataSource Template for the AS-JDBC driver.

Tab Configuration -> DataSource Template -> Button New
- Copy the Contents of the template XML (ASDatasourceTemplateSFWorking.xml), save the template (ASJDBC), enable it and save the changes.
- Restart Spotfire to reload the new settings.

7). Open TIBCO Spotfire (client). Open "Information Designer" (Menu Tools -> Information Designer).
- Create a new DataSource (select ASJDBC driver).
- Add a valid connect string.
 
Note (new JDBC driver supports all metaspace connection types):
- non-secure metaspace: jdbc:tibco:as:[metaspace];discovery=[discoveryURL];listen=[listenURL]
 
-secure metaspace, authentication.
jdbc:tibco:as:[metaspace];security_token=[tokenfile];member_name=[membername];authentication_domain=[domain];authentication_username=[username];authentication_password=[password]
 
- secure metaspace, no authentication.
jdbc:tibco:as:[metaspace];security_token=[tokenfile];listen=tcp://[IP_ADDR];member_name=[membername]
 
See also KB 48205 (AS_infomation_link_guide.zip).

KB 48205