How can we connect SQLite datasource with Sharpoint in Spotfire?

I have used the below template  for making SQLite connection with external drive from Spotfire and it works

<jdbc-type-settings>

  <type-name>SQlite</type-name>

  <driver>org.sqlite.JDBC</driver>

  <connection-url-pattern>jdbc:sqlite:\\datasource;</connection-url-pattern>

   <table-types>TABLE, VIEW</table-types> 

   <ping-command>SELECT 1</ping-command> 

   <supports-catalogs>false</supports-catalogs> 

   <supports-schemas>false</supports-schemas> 

   <use-ansii-style-outer-join>true</use-ansii-style-outer-join>

</jdbc-type-settings>

 

 

and the connection URL used is jdbc:sqlite:\\\\xxx.net\dfs\common\chinook.db

Now it works with external drive and not from the sharepoint. Could you please help us how can we make connection from Sharepoint with SQLite?

 

1 Comment

As a follow up question here:

Which credentials does Spotfire Server use when accessing the SQLite database file specified in the URL field of the Data Source? It is clearly not passing SSO credentials of the user, acessing the Information Link which is based on that Data Source. I am guessing it is using some sort of admin account, or the Windows credentials of the user running the server. Whatever the case, it does not seem TIBCO has ever anticipated that 1) file-base data sources will be used or that 2) database files can be places somewhere other than the server location.

The example for AccessDB here (https://community.tibco.com/wiki/tibco-spotfirer-jdbc-data-access-connec...) is also referencing a local file (on C: drive). 

Could TIBCO please confirm that you guys never anticipated accessing network locations through Connection URL field in the Data Source dialog and therefore did not implement passing of SSO from Information Link to Data Source.

dmyp - Dec 07, 2017 - 2:40pm ::
+ Add a Comment
Login