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