Spotfire to Palantir foundry jdbc connection error

[Prarthana Abhinandan]

We are trying to connect to Palantir foundry using jdbc driver foundry-sql-jdbc-driver-1.62.0-withdep.jar , so that we can consume data in Spotfire.

Right now, the datasource template used is the following, but it does not load the contents from the tables:

 

Palantir

com.palantir.foundry.sql.jdbc.FoundryJdbcDriver

jdbc:foundrysql://<host>

 

We are recieving the attached error message while trying to view the table contents:

We are recieving the attached error message while trying to view the table contents:

 

Error message: Could not get contents of '' from the server.

The path /Palantir_POC//Open Source/Training/ is no longer valid. Try refreshing to pickup any changes from the server.

 

InformationModelException at Spotfire.Dxp.Data:

Invalid data source item. (HRESULT: 80131500)

 

Stack Trace:

at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.ListDataSourceItemChildren(DataSourceItem parent)

at Spotfire.Dxp.Forms.Data.InformationDesigner.Cache.CachedDataSourceItem.d__30.MoveNext()

at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)

at Spotfire.Dxp.Forms.Data.InformationDesigner.Cache.CachedItem.EnsureChildrenLoaded()

at Spotfire.Dxp.Forms.Data.InformationDesigner.VirtualMultiSelectTreeView.TreeItem.Expand()

 

 

InformationModelServiceException at Spotfire.Dxp.Services:

Invalid data source item. (HRESULT: 80131509)

 

Stack Trace:

at Spotfire.Dxp.Services.WcfSoapService`2.InvokeService[T](Func`1 serviceMethod, String customMethodNameForLogging)

at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.ListDataSourceItemChildren(DataSourceItem parent)

[Prashant Ajjannavar]

Hello,

This case got resolved through a support case and below is the default template that was in use.

 

Palantir_DB

true

 

Palantir

com.palantir.foundry.sql.jdbc.FoundryJdbcDriver

jdbc:foundrysql://

]]>

 

Based on the requirement, we asked a user to add the below lines and it worked

true

false

$$table$$

If you come across any issues or concerns, please feel free to contact TIBCO Support anytime.

@prarthana.mysore-abhinandan

Please let us know if we missed any.

Thank you!