Hi Sandeep, please use the native Spotfire connector for Salesforce. The ODBC driver needed to activate the connctor is downloded as part of the Spotfire Server software. If you are using TIBCO Cloud Spotfire there is a download section where you download the driver and Spotfire Analyst client. More information is available here.
This is in response to your query to me directly to me so it can stay in this thread:
JDBC drivers (the JAR file used[sforce-jdbc.jar]) can be used to enable data sources in Tools> Information designer.
In order to use a specific JDBC driver you need to use a data source template of salesforce,so can you provide the datasource template if youo have or if you know any source where i can finmd this salesforce template. ?
what we have done till now :
1) we have installed the TIB_drivers_salesforce_188.8.131.529_odbc_64 driver in spotfire TEST environment.
2)we have downloaded the sforce-jdbc.jar file also and placed it in the spotfire server under tomcat/lib folder .
still we can not see this salesforce connection in the spotfire client/analyst.
The TIB_drivers_salesforce_184.108.40.2069_odbc_64 driver needs to be installed on the client machines, so Analyst and Node Managers. I would recommend against using JDBC to connect to Salesforce.com and use the Spotfire Connector for Salesforce.
In addition to the driver, you may need to enable the Salesforce.com Connector license for the groups of users that should have access to that Connector. This can be done in the Administratoin Manager in Spotfire Analyst:
(1) Open Spotfire Analyst as a Spotfire Administrator
(2) Open Tools->Administration Manger-> Groups and Licenses tab
(3) Select the Group that needs access to Salesforce
(4) Select "Edit" to edit the licenses
(5) In the Edit dialog either enable all the Connectors or just specific Connectors by checking the boxes to enable. Then Click OK to save the updated license selections.
If the Salesforce.com Connector is not even appearing in the Add Data Tables dialog, then the license needs to be enabled. If the Salesforce.com Connector is appearing but is disabled, then the ODBC driver needs to be installed on the client.