Connector for Oracle

On this page, you find information about downloading and installing the drivers you need to be able connect to data sources with the connector for Oracle in Spotfire.

Preparations

Before downloading and installing any driver software for use with this connector, read the system requirements for the connector for your version of Spotfire. Make sure that your database version and driver version is supported in your version of Spotfire.

System requirements for connectors

Remember that additional requirements and third party dependencies might apply for using the drivers. Refer to the official documentation from the driver vendor for more information.

Supported data sources

You can use the Spotfire Connector for Oracle to connect to the following data source types:

Amazon RDS for Oracle
Oracle

Driver information (Spotfire 14.5 and later)

You can use the Oracle connector without installing any additional software on your computer.

Driver information (Spotfire 14.4 and earlier)

To use the Oracle connector, you must install the Oracle Data Provider for .NET driver.

The driver is included in the Oracle Data Access Components (ODAC) package, which available for download from Oracle.

Downloading the Oracle Data Provider for .NET (version 19c R1)

Note: This version of the driver is only supported in Spotfire version 10.10.x LTS, 11.4.x LTS, 11.8.0 or later.

On the Oracle downloads page, download the Oracle Data Access Components (ODAC) appropriate for your environment.
With the installation script, install the component ODP.NET4.
In your PATH environment variable, add the following directory: <installation-directory>\bin

After the installation is complete, you must also register the following .dll files that you find in the installation directory:

odp.net\PublisherPolicy\4\Policy.4.112.Oracle.DataAccess.dll

odp.net\bin\4\Oracle.DataAccess.dll

To register the files, open a command-line interface as an administrator and use the following commands:

<installation-directory>\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:<installation-directory>\odp.net\PublisherPolicy\4\Policy.4.112.Oracle.DataAccess.dll

<installation-directory>\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:<installation-directory>\odp.net\bin\4\Oracle.DataAccess.dll

In the command-line interface, complete the configuration with the following command:

<installation-directory>\odp.net\bin\4\OraProvCfg.exe /action:config /product:odp /frameworkversion:v4.0.30319 /providerpath:<installation-directory>\odp.net\bin\4\Oracle.DataAccess.dll

Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.

Downloading the Oracle Data Provider for .NET (version 12c)

Prerequisites

To access the download, you must have an Oracle account, which you can create on the Oracle website.

On the Oracle downloads page, download the ODAC OUI appropriate for your environment.
To install the driver, execute the setup file and make sure you select the component Oracle Data Provider for .NET.

Installing the driver on Linux (Spotfire 14.4 and earlier)

To use the Oracle connector on a Linux system with Automation Services or Web Player services, you must package .dll files from the Oracle.ManagedDataAccess.Core NuGet package in an .spk file and deploy it on the deployment area on the Spotfire Server.

Prerequisites

You need the Spotfire Package Builder console from the Spotfire Developer software.

Get the NuGet package Oracle.ManagedDataAccess.Core.
Create a new .pkdesc package description file for Linux systems.

Tip: You can start from and modify the sample further down on this page.
In the .pkdesc file, include the following files from the NuGet package:

<.NET Version>\Oracle.ManagedDataAccess.dll
Also include any required file dependencies.

Open a command-line interface. To create an .spk file from your .pkdesc file, run the Package Builder console with this command:

Spotfire.Dxp.PackageBuilder-Console.exe /target:"output-directory\oracle-driver.spk" /pkdesc:"input-directory\oracle-driver.pkdesc" /basefolder:"basefolder-directory" /intendedplatform:linux /targetframework:netcore

Deploy the .spk package to the appropriate deployment area on the Spotfire Server.

Sample .pkdesc file

You can modify and use this .pkdesc sample to create an .spk package file. The sample is written based on having included the NuGet package in a C# project and then built it. That downloads the .dll files in the folder structure used in the sample. All file paths in the .pkdesc are relative to the /basefolder parameter that you provide when you run the Package Builder Console.

Note: This sample is based on a specific version of the Oracle.ManagedDataAccess.Core NuGet package. Details such as file dependencies might be different in the version you want to use, so always consult the official documentation for the NuGet package and modify your .pkdesc file accordingly.

<?xml version="1.0"?>
   <PackageDescription xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SchemaVersion="1.0" Name="Spotfire Driver for Oracle NET Core" Version="1.0.0.0" SeriesId="75584b2c-ca88-4e95-b770-ca7824e78a30" IntendedClient="Any" TargetFramework="netcore" IntendedPlatform="linux">
   <File SourceFile="Oracle.ManagedDataAccess.dll" TargetFilename="Oracle.ManagedDataAccess.dll" Type="Assembly" />
   <File SourceFile="runtimes\linux\lib\net6.0\System.DirectoryServices.Protocols.dll" TargetFilename="System.DirectoryServices.Protocols.dll" Type="Assembly" />
</PackageDescription>

What to do next?

If you want to learn more about how to use this connector, see the Spotfire User Guide. There you can find everything from basic instructions to detailed information about how you can load and analyze data in Spotfire.

Spotfire User Guide