---
title: "Oracle Database Connector | Lansweeper Platform"
slug: "oracle-database-connector"
description: "Use the Oracle Database connector in Lansweeper Flow Builder to query an Oracle relational database from your automated workflows."
updated: 2026-07-17T16:06:50Z
published: 2026-07-17T16:06:50Z
canonical: "docs.lansweeper.com/oracle-database-connector"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lansweeper.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle Database Connector

Note on third‑party tools

              

We aim to provide accurate and helpful details about third‑party tools, but we can’t guarantee that this information is always complete or up to date. If you notice any discrepancies, feel free to share them in the feedback section below. For the most reliable information, please always refer to the third‑party tool’s official documentation.

[Oracle Database](https://www.oracle.com/database/) is a popular relational database system. This component allows querying an Oracle database.

## API Documentation

This component was built using [Node.js for Oracle Database](https://node-oracledb.readthedocs.io/en/latest/user_guide/introduction.html#getting-started).

## Connections

### On-Premise Connection

Authenticate requests to an OracleDB server.

Create a connection of type **On-Premise Connection** to authenticate with an Oracle Database server using a direct connection with host, port, and database credentials.

#### Prerequisites

- An Oracle Database instance accessible from the network
- Database user credentials with appropriate permissions

#### Configure the Connection

- **Host**: The hostname or IP address of the Oracle Database server (e.g., `192.168.0.1`)
- **Port**: The port the database server is exposing (default: `1521`)
- **Database**: The Oracle database SID to connect to (e.g., `xe`)
- **Username** (optional): The username for authenticating with the Oracle Database server (omit when using OS authentication)
- **Password** (optional): The password for authenticating with the Oracle Database server (omit when using OS authentication)
- **Connection Timeout** (optional): The amount of time in seconds to wait for a connection to be established before timing out (default: `10`)

| Input | Comments | Default |
| --- | --- | --- |
| Host | The host name or IP address of the Oracle DB server. |  |
| Port | The port of the Oracle DB server. | 1521 |
| Database | The database SID in Oracle DB. |  |
| Username | The username used to authenticate to the Oracle DB server. |  |
| Password | The password used to authenticate to the Oracle DB server. |  |
| Connection Timeout | The amount of time (in seconds) to wait for a connection to be established before timing out. Default is 10 seconds. | 10 |

## Actions

### Query

Returns the results of an OracleDB database query.

| Input | Comments | Default |
| --- | --- | --- |
| Connection | The OracleDB connection to use. |  |
| SQL Query | The SQL statement to execute against the database. Use named parameters (e.g. ':name') to safely bind values supplied through the parameter inputs. | SELECT * FROM mytable WHERE name = :name AND company = :company_id |
| Named Parameters | Optional named parameters to insert into a query. Ensure the keys of these parameters match parameters in the query. For example, if the query contains ':company_name', give this parameter the key 'company_name'. Values specified here are merged with values supplied from the 'Named Parameters Object' input. |  |
| Named Parameters Object | Optional named parameters to insert into a query. Ensure the keys of these parameters match parameters in the query. For example, if the query contains ':company_name', the object should contain a key 'company_name'. Values in this object are merged with values supplied from the 'Named Parameters' input. |  |