Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Instructions to create a new Data Source Template to be used from Information Designer.
Solution:
Description:
Instructions to create a new Data Source Template to be used from Information Designer
1). Get the JDBC driver JAR file from the respective Database Vendor and copy it to "<TIBCO Spotfire Server Installation Path>\tomcat\lib" folder/directory .
2). Create a Data Source template XML for the Database. Only the following three settings are mandatory.
type-name A unique name for the configuration.
driver The JDBC driver Java class used for creating connections.
connection-url-pattern A pattern for the connection URL. The URL syntax is driver specific.
Place all the XML settings along with the above three inside <jdbc-type-settings> ... </jdbc-type-settings>
Example: XML for Oracle DB
-----------------
<jdbc-type-settings>
<type-name>oracle</type-name>
<driver>oracle.jdbc.OracleDriver</driver>
<connection-url-pattern>jdbc:oracle:thin:@<host>:<port1521>:<sid></connection-url-pattern>
</jdbc-type-settings>
------------------
Where Oracle JDBC driver class : oracle.jdbc.OracleDriver
Oracle Connection URL : jdbc:oracle:thin:@host:port:sid
Go through the TIBCO Spotfire Server Installation manual (Section "Handling Data Source Templates") for more details on different available XML settings.
2). Create a new data source template with the above XML using the TIBCO Spotfire Configuration Tool.
- Using TIBCO Spotfire Configuration GUI Tool:
============================================
a). Run <TIBCO Spotfire Server Installation Path>\tomcat\bin\uiconfig.bat .
b). Enter Tool Password when prompted.
c). Go to Configuration Tab -> Data Source Templates. Click New .
d). Enter a unique Name and copy the XML created earlier into the Data Source Template section (Step 1). The Open button can also be used to open the above XML file if saved locally.
e). Click on OK.
f). Click on the Checkbox located next to the New template to enable it. Make sure the status bar at the bottom shows "XML Parsed OK" which means the driver is present in the tomcat\lib folder and the XML is valid.
g). Save the configuration into the database.
Note: Use uiconfig.sh on UNIX/Linux OS. The display needs to be exported to an external X11 system to render the UI on UNIX/Linux Environments. Refer to the attached (Filename: "Adding a New Data Source Template using TIBCO Spotfire Configuration GUI Tool.pdf").
- Using TIBCO Spotfire Configuration Command Line Tool:
=====================================================
a). Open a command prompt or Shell and navigate to "<TIBCO Spotfire Server Installation Path>\tomcat\bin\" folder/directory.
b). Run following command to export the currently running configuration to configuration.xml file. Replace the string toolpassword with the correct Tool Password.
./config.sh export-config -f -t "toolpassword"
OR
config.bat export-config -f -t "toolpassword"
c). Run the following command to add a new template with the above XML (Step1).
./config.sh add-ds-template -n "NewDBTemplate" -e true <Path to above XML template file>
OR
config.bat add-ds-template -n "NewDBTemplate" -e true <Path to above XML template file>
d). Run the following command to import the updated configuration into database. Replace the string toolpassword with the correct Tool Password.
./config.sh import-config -c "Added New Hive Template" -t "toolpassword"
OR
config.bat import-config -c "Added New Hive Template" -t "toolpassword"
Note: Go through the TIBCO Spotfire Server Installation manual for more information on "add-ds-template" command. Refer to the attached (Filename: "Adding a New Data Source Template using TIBCO Spotfire Configuration Command Line Tool.pdf").
3). Restart the TIBCO Spotfire Server service/process.
https://docs.tibco.com/pub/spotfire_server/7.0.0/doc/pdf/TIB_sfire_server_7.0.0_installation.pdf