---
title: "Oracle"
slug: "oracle"
updated: 2025-08-06T20:18:35Z
published: 2025-08-06T20:18:35Z
---

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

# Oracle

**Oracle Database** is a multi-model database management system designed to handle large-scale data workloads and complex enterprise applications. It provides features like data storage, querying, and transaction processing while supporting high availability, scalability, and integration with modern cloud environments.

          **DATADDO TIP**

          

Dataddo supports **Oracle** as both a cloud-managed and an on-premises source or destination.

## Prerequisites

          
          

- You have [created an Oracle user](/docs/oracle#in-oracle-db) for Dataddo.
- You have configured your network firewall to **allow incoming connection from [Dataddo IPs](/docs/network-acl)**.

## Authorize the Connection to Oracle DB

### In Oracle DB

Please keep in mind that this guide provides **general instructions**, and your individual setup might need a different approach or some extra steps. **Always take your organization's security guidelines into account when you're making these changes**. Additionally, it's a good idea to seek assistance from a database administrator or an IT professional to make sure everything is set up correctly.

#### Create User

1. Connect to your database. You will need admin-level permissions to create a user and assign permissions.
2. Use the following statement, replacing `[password]` with the actual password:

```
CREATE USER dataddo
    IDENTIFIED BY [password]
```

          **DATADDO TIP**

          

Usernames are case-sensitive.

For more information, refer to [Oracle's official documentation](https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8003.htm).

#### Set Permissions

To allow the newly created user access to the Oracle database, execute the following statements:

```
GRANT CREATE SESSION TO dataddo;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON <schema>.<table_name> TO dataddo;
```

- For access to all tables in the database, use:

```
GRANT INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO dataddo;
```

For read-only access (for **Oracle only as a source**), use:

```
GRANT SELECT ON <schema_name>.<table_name> TO dataddo
```

- To grant read-only access to all tables in the database, use:

```
GRANT SELECT ANY TABLE TO dataddo;
```

#### Allow Network Connection

If you're using Oracle Cloud, go to your database. Under the **Network** section, find the **Access control list** and click edit. Here, you can add all IP addresses that need to be whitelisted.

You can also configure the network access **at the firewall level**. Here are the general steps:

1. **Identify the firewall** that's protecting your service. This could be a Windows or Linux firewall running on the server itself, or it could be a network firewall.
2. Open the **firewall's configuration settings**. This process will vary depending on the type of your firewall.
3. Look for the s**etting that allows you to define inbound rules or policies**.
4. Create **a new rule or policy** that allows inbound traffic on the port that the service is using (the default is **1433**) from the [Dataddo IP addresses](/docs/network-acl).
5. **Save** your changes and **test the connection from Dataddo** to make sure everything is working as intended.

### In Dataddo

1. On the **Authorizers** page, click on [**Authorize New Service**](https://app.dataddo.com/service/new) and select **Oracle**.
2. You will be asked to fill the following fields
  1. **Server IP or Hostname**: Public IP or Hostname of your Oracle server.
  2. **Database**: Name of the database you will use for writing or reading the data.
  3. **Username**: Username of your Oracle user.
  4. **Password**: Password associated with the Oracle username.
  5. **Port**: Dataddo uses native connection with default port **1521**.
3. [Optional] Configure your destination using an existing SSH tunnel or [create a new one](/docs/ssh-tunnelling).
4. Click on **Save**.

## Create a New Oracle DB Destination

1. On the **Destinations** page, click on the [**Create Destination**](https://app.dataddo.com/destinations) button and select the destination from the list.
2. Select your ***authorizer*** from the drop-down menu.
3. Name your ***destination*** and click on **Save**.

          Need to authorize another connection?

          

Click on **Add new Account** in drop-down menu during ***authorizer*** selection and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).

## Create a Flow to Oracle DB

1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new).
2. Click on **Connect Your Data** to add your ***source(s)***.
3. Click on **Connect Your Data Destination** to add the ***destination***.
4. Choose the [write mode](https://docs.dataddo.com/docs/data-storages#write-modes) and fill in the other required information.
5. Check the **Data Preview** to see if your configuration is correct.
6. **Name** your flow and click on **Create Flow** to finish the setup.

---

## Related Articles

- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)
- [Write Modes](https://docs.dataddo.com/docs/data-storages#write-modes)
- [Implementation of Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Network Access Control List (ACL) Configuration](https://docs.dataddo.com/docs/network-acl)
- [SSH Tunnelling](https://docs.dataddo.com/docs/ssh-tunnelling)
- [Data Transformations](https://docs.dataddo.com/docs/data-transformations)
- [Data Quality Firewall](https://docs.dataddo.com/docs/data-quality-firewall)