Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Oracle data connector is disabled in the TIBCO Spotfire Analyst client

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Oracle data connector is disabled in the TIBCO Spotfire Analyst client


Solution:

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.
  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. Doc: System Requirements > TIBCO Spotfire® Connector for Oracle Category

Related articles