We recently installed TIBCO Data Virtualization to test the connectivity options between Spotfire and TDV. We prepared some sample views in TDV then published the views. We then tried to connect via Information Link from Spotfire. It is working quite good. But this approach might seem as a rework since we need to create columns, joins and information link elements again after doing some modelling in TDV.
We have tried to connect by using the TIBCO Data Virtualization connector in Spotfire Analyst v7.11.0 HF 001 but it fails giving the same error regardles of the authentication method. I've pasted the error lines from the log file of Analyst:
DEBUG Spotfire.Dxp.Data.Adapters.Composite.CompositeAdapterConnection [(null)] - Failed to open connection.
Composite.Data.Common.SQLException: Unknown connection option: Integrated_Authentication=Disabled.
at Composite.Data.CompositeClient.CompositeConnectionStringBuilder.ParseConnectionString(String connectionString)
at Composite.Data.CompositeClient.CompositeConnection.set_ConnectionString(String value)
at Composite.Data.CompositeClient.CompositeConnection..ctor(String connectionString)
at Spotfire.Dxp.Data.Adapters.Composite.CompositeAdapterConnection.ConnectAndGetDatabaseNames(String connectionString, List`1& databases)
admin [Main Thread] ERROR Spotfire.Dxp.Forms.Data.Access.AsynchronousTaskManager [(null)] - Background task failed.
Could not connect due to an unknown error.
Unknown connection option: Integrated_Authentication=Disabled.
Are there anyone who has managed to connect to TDV via TDV connector in Spotfire? Am I missing some configuration in TDV server?