Skip to main content

​
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:
  1. Configure your firewall to allow connections on port 1521 (or your custom port)
  2. Verify the listener is configured to accept remote connections
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

FieldDescription
HostDatabase server hostname or IP address
PortDatabase server port (default: 1521)
Service NameOracle service name (e.g., ORCL)
UserDatabase username
PasswordDatabase 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