Spotfire Analyst: Oracle Connector is disabled

Oracle data connector is disabled in the Spotfire Analyst client.

On an installed Spotfire Analyst client, the 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:

• Required Oracle ODP.NET database driver is installed on the client machine and is a supported version.
• Appropriate Spotfire licenses are enabled in the Spotfire Server's Administration Manager (in Analyst) or under Groups > Licenses in Spotfire Server's web admin console.

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:

   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 Spotfire Analyst installed client.

If the additional <DbProviderFactories /> tag is not present and you still have issues, then please contact Spotfire Support for further assistance.