Skip to main content

Oracle data connector is disabled in the TIBCO Spotfire Analyst client

Rich Talbot
  • Created
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

Comments

0 comments

Article is closed for comments.