While using the Oracle client data provider to connect to Oracle database, below error message is received
====================
Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query for data source "". --->
System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
   at System.Data.OracleClient.OCI.DetermineClientVersion()
   at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at Spotfire.Dxp.Data.Import.DatabaseDataSource.<>c__DisplayClass23_1.<GetPromptModels>b__0()
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)
   at Spotfire.Dxp.Data.Import.DatabaseDataSource.<GetPromptModels>d__23.MoveNext()
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()
   --- End of inner exception stack trace ---
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()
   at Spotfire.Dxp.Data.DataFlow.<ConnectAndGetPromptModels>d__12.MoveNext()
   at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.<GetPromptModelsCore>d__4.MoveNext()
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()
========================

While connecting to an Oracle data source in TIBCO Spotfire Analyst or web client using the Oracle Client Data Provider, you get the error "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater"

All

To resolve this, make sure to install the Oracle ODAC component on the Spotfire Analyst client machine and/or the Node Manager server machine.

Example: ODAC122011_x64.zip can be downloaded from the link: https://www.oracle.com/database/technologies/odac-downloads.html