Oracle Database - BonData Documentation

Oracle Database is an enterprise-grade relational database management system known for high availability, scalability, and advanced security features. With BonData, you can connect directly to your Oracle Database to read, enrich, and act on your data within Agent workflows.

Database Connection

BonData connects directly to your Oracle Database using standard connection credentials.

Step 1: Prepare Your Database

Ensure your Oracle Database is accessible from BonData’s IP addresses. You may need to:

Configure your firewall to allow connections on port 1521 (or your custom port)
Verify the listener is configured to accept remote connections

Step 2: Create a Read-Only User (Recommended)

For security, create a dedicated read-only user for BonData:

-- Create a user for BonData
CREATE USER bondata_user IDENTIFIED BY your_secure_password;

-- Grant basic connection privileges
GRANT CREATE SESSION TO bondata_user;

-- Grant select access on specific tables
GRANT SELECT ON schema_name.table_name TO bondata_user;

-- Or grant select on all tables in a schema
BEGIN
  FOR t IN (SELECT table_name FROM all_tables WHERE owner = 'SCHEMA_NAME') LOOP
    EXECUTE IMMEDIATE 'GRANT SELECT ON SCHEMA_NAME.' || t.table_name || ' TO bondata_user';
  END LOOP;
END;
/

Step 3: Gather Connection Details

Collect the following information:

Host: Your database server hostname or IP address
Port: Usually 1521
Service Name: The Oracle service name (e.g., ORCL)
User: The username created above
Password: The password for the user

Step 4: Connect in BonData

Enter your connection details in BonData to establish the connection.

Required Fields

Field	Description
Host	Database server hostname or IP address
Port	Database server port (default: 1521)
Service Name	Oracle service name (e.g., ORCL)
User	Database username
Password	Database password

For Oracle Autonomous Data Warehouse (ADW), see the dedicated Oracle ADW integration which uses wallet-based authentication.

Available Data

Once connected, BonData can sync:

Tables - All tables the user has SELECT access to
Views - Database views accessible to the user
Custom Queries - Run custom SQL queries to extract specific data

MariaDB

SQL Server

​Database Connection

​Step 1: Prepare Your Database

​Step 2: Create a Read-Only User (Recommended)

​Step 3: Gather Connection Details

​Step 4: Connect in BonData

​Required Fields

​Available Data

Database Connection

Step 1: Prepare Your Database

Step 2: Create a Read-Only User (Recommended)

Step 3: Gather Connection Details

Step 4: Connect in BonData

Required Fields

Available Data