How to connect to TIBCO Data virtualization published views data via Spotfire Information link?
Article ID: KB0072409
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
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 in TIBCO Data Virtualization
2. Appropriate TDV JDBC driver (csjdbc8.jar) placed in Spotfire Server location [Spotfire Installation Directory]\tomcat\spotfire-lib
3. TIBCO Spotfire Server Access with Bootstrap password (if TDV capability needs to be enabled)
Pre-requisites:
1. Published view in TIBCO Data Virtualization
2. Appropriate TDV JDBC driver (csjdbc8.jar) placed in Spotfire Server location [Spotfire Installation Directory]\tomcat\spotfire-lib
3. TIBCO Spotfire Server Access with Bootstrap password (if TDV capability needs to be enabled)
Resolution
1. If TDV data source needs to be enabled, follow this step - else skip to point #2. Launch Spotfire Server Configuration Tool, enter the bootstrap password and navigate to Configuration>> Data Source Templates, and enable TIBCO Data Virtualization. Restart Spotfire Server service as necessary. For reference: https://docs.tibco.com/pub/spotfire_server/11.8.0/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 the Data tab >>Information Designer >>Setup Data Source
3. Pick TIBCO Data Virtualization from the drop-down list and enter the Connection URL as appropriate to connect to TDV Published Data Source :
Example : jdbc:compositesw:dbapi@v14Statistica:9601?domain=composite&dataSource=agree_test
Save with the appropriate name in the library.
4. 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 the raw table added to the dashboard.
2. Launch Spotfire Analyst and navigate to the Data tab >>Information Designer >>Setup Data Source
3. Pick TIBCO Data Virtualization from the drop-down list and enter the Connection URL as appropriate to connect to TDV Published Data Source :
Example : jdbc:compositesw:dbapi@v14Statistica:9601?domain=composite&dataSource=agree_test
Save with the appropriate name in the library.
4. 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 the raw table added to the dashboard.
Issue/Introduction
How to connect to TIBCO Data virtualization published views via Spotfire Information link?
Additional Information
Feedback
Yes
No
Powered by
