How to connect to TIBCO Data Virtualization published views using Spotfire Information link

Product:TIBCO Data Virtualization
Versions:All supported versions

Summary:
How to connect to TIBCO Data virtualization published views using Spotfire Information link.

Details:
This article lists the steps to follow to connect to TIBCO Data virtualization published views data via the Spotfire Information link. 

Pre-requisites:
1. Published view is available in TIBCO Data Virtualization.
2. Appropriate TDV JDBC driver (csjdbc8.jar) placed in Spotfire Server location [Spotfire Installation Directory]\tomcat\custom-ext\ directory.
3. Spotfire Server Configuration Tool is used to enable TDV data source template (under Configuration-> Data Source Templates).

Resolution:
1. If TDV data source needs to be enabled, follow this step. Otherwise, skip to step 2.

Launch Spotfire Server Configuration Tool, enter the bootstrap password and navigate to Configuration-> Data Source Templates, then enable TIBCO Data Virtualization. Restart Spotfire Server service.

Documentation reference: https://docs.tibco.com/pub/spotfire_server/14.0.5/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/adding_a_data_source_template_with_the_configuration_tool.html

 
2. Launch Spotfire Analyst and navigate to Data menu-> Information Designer-> Setup Data Source.

3. Select TIBCO Data Virtualization from the drop-down list and enter the Connection URL as appropriate to connect to TDV Published Data Source. For example :

jdbc:compositesw:dbapi@v14Statistica:9601?domain=composite&dataSource=agree_test

Save the new data source with appropriate name in the Library.

4. In Information Designer window, click on Start tab-> Elements-> Multiple Columns. Click on the view in the Elements Pane and click Add the columns from TDV Data Source added in the prior step. Save the columns in a location as shown below : 



5. Click on the Start tab in the Information Designer. Click on 'Create Information Link'.



6. Select Columns created in the prior step and click Add as shown below: 



7. Save the Information Link and click on 'Open Data'. Use in Spotfire Analyst as required. The illustration above shows a data table added to the dashboard.