Oracle data connector is disabled in the TIBCO Spotfire Analyst client

Oracle data connector is disabled in the TIBCO Spotfire Analyst client

book

Article ID: KB0076025

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

On an installed TIBCO Spotfire client, the TIBCO Spotfire Connector for Oracle (Add Data Table > Add > Connection to > Oracle) is disabled/greyed out even though all the requirements are met per the system requirements:
  • TIBCO Spotfire Data Connector modules are installed.
  • Required database driver is installed on the client machine and is a supported version.
  • Spotfire licenses are are enabled in the Administration Manager.

Issue/Introduction

In this article you will find one configuration to check if the Oracle connector is greyed out but all requirements are met.

Resolution

  1. Open Notepad (or other plain text editor) as an administrator (right click and select "Run as Administrator"
  2. From the text editor, open the machine.config file located C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config. It should have the following entry (For ODAC121024_x64 driver): 
    <DbProviderFactories>
      <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
      <add name="ODP.NET, Unmanaged Driver" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET, Unmanaged Driver" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
  3. Most importantly, it should not have an additional <DbProviderFactories /> tag at the end of the above line. Remove it if it is there and save the file.
  4. After saving, relaunch the TIBCO Spotfire installed client.
If the additional <DbProviderFactories /> tag is not present and you still have issues, then please contact TIBCO Spotfire Support for further assistance.

Additional Information

Doc: System Requirements > TIBCO Spotfire® Connector for Oracle Category
Powered by Wolken Software