Problem with data connector Oracle

[Giuseppe Verardi]

When I use Tibco Sportfire Analyst 7.7 I have this error with Data connctor Oracle:

 

ImportException at Spotfire.Dxp.Data:

The 'Oracle' data connector is not available.

Reason:

To use this connector, a driver is required. See Spotfire system requirements for details.

Data connection:

TIS-Liv1 (7)

Unavailable connector:

The 'Oracle' data connector is not available.

Reason:

To use this connector, a driver is required. See Spotfire system requirements for details. (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.CreateView(CxxSession session, GlobalMethodRegistry globalMethodRegistry, NotificationService notificationService, Int32 rowLimit)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.GetColumnsAndProperties()

at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(DataColumnProducer producer, Boolean forceUpdate)

at Spotfire.Dxp.Data.Persistence.DataPool.GetDerivedData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

at Spotfire.Dxp.Data.Persistence.DataPool.GetData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.PoolReferenceCompute_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(RuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass9.b__4()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithGenerationDependant(ILimitationTarget generationDependant, Executor executor)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.LookupOrEvaluateValue(StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.GetValue(StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass8.b__6()

at Spotfire.Dxp.Framework.DocumentModel.DocumentView.Use(DocumentView documentView, DocumentViewExecutionState documentViewExecutionState, Action action)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.b__4()

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.LoadData()

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__16.MoveNext()

at Spotfire.Dxp.Data.DataTable.d__5e.MoveNext()

 

What can I do

[Harshith Reddy Musku]

Hello,

 

Oracle connector requires ODAC to be installed on the client machine. Please go through the following document and install ODAC on the machine where spotfire client is installed.

 

https://docs.tibco.com/pub/spotfire/general/drivers/index.htm#t=data_sources%2Fconnector_oracle.htm

 

https://docs.tibco.com/pub/spotfire/general/sr/GUID-D1E24F86-9458-4DF9-986D-F5E553838A13.htmlscroll=GUID-D1E24F86-9458-4DF9-986D-F5E553838A13

[Prashant Anand]

Hello Giuseppe,

The supported ODAC driver can be installed from the following link.

=====

https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

=====

Following are the supported verisons of ODAC driver.

 

ODAC (ODP.NET) 12c

ODAC (ODP.NET) 11.2.0.x (11.2.0.0 or higher)

[Giuseppe Verardi]

I solved, thanks a lot.