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.

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

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.

1. On the Oracle downloads page, download the Oracle Data Access Components (ODAC) appropriate for your environment.

2. With the installation script, install the component ODP.NET4.

3. In your PATH environment variable, add the following directory:
   <installation-directory>\bin

4. 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

5. 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.  

1. On the Oracle downloads page, download the ODAC OUI appropriate for your environment.

2. To install the driver, execute the setup file and make sure you select the component Oracle Data Provider for .NET.

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.

Installing the driver on Linux (Spotfire 12.0 and later)

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.

Procedure

1. Get the NuGet package Oracle.ManagedDataAccess.Core.

2. Create a new  .pkdesc package description file for Linux systems.
   
   Tip: You can start from and modify the sample further down on this page.

3. In the .pkdesc file, include the following files from the NuGet package:
   
   <.NET Version>\Oracle.ManagedDataAccess.dll

4. Also include any required file dependencies.

5. 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

6. 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.

Important: 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>

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.