External Data Source - Oracle

Introduction

This plugin allows you to use an external Oracle database as a data source. It supports Oracle versions >= 11g.

Installation

Install Oracle Client

For Oracle server versions earlier than 12.1, you need to install the Oracle client.

Example for Linux:

bash

apt-get update
apt-get install -y unzip wget libaio1
wget https://download.oracle.com/otn_software/linux/instantclient/1925000/instantclient-basic-linux.x64-19.25.0.0.0dbru.zip
unzip instantclient-basic-linux.x64-19.25.0.0.0dbru.zip -d /opt/
echo /opt/instantclient_19_25 > /etc/ld.so.conf.d/oracle-instantclient.conf
ldconfig

If the client is not installed as described above, you will need to specify the path to the client (for more details, refer to the node-oracledb documentation).

Usage

For detailed instructions, refer to the Data Source / External Database section.