Implementation
This handler is implemented using theoracledb
library. Please install it with the below command before using this handler.
host
is the host name, IP address, or URL.port
is the port used to make TCP/IP connection.sid
is the unique identifier of the database instance.user
is the database user.password
is the database password.
disable_oob
defines whether to disable out-of-bank breaks.auth_mode
defines the database privilege mode: SYSDBA, SYSOPER, or others.
If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the handler’s folder (mindsdb/integrations/handlers/oracle_handler) and run this command:
pip install -r requirements.txt
.Usage
In order to make use of this handler and connect to the Oracle database in MindsDB, the following syntax can be used:sid
or service_name
arguments to target the right database instance.
You can use this established connection to query your table as follows: