Skip to main content

Oracle

plan support

Included in all plans

IP Whitelist

Wren AI needs to access your Oracle database via the IP address of the outbound IP of Wren AI Cloud. Please add the IP address of the Wren AI service to the firewall of your Oracle database.

Scroll to the bottom of the data source connection page to find the IP address.

To add an Oracle connection, click on the Oracle option in Connect a data source section. connect

Required Permissions

Minimum Permissions Required

To ensure full compatibility and stability, the Oracle user account used by Wren AI requires the following permissions on your target database:

  • SELECT on tables and views
  • CREATE VIEW
  • DROP VIEW

Wren AI automatically creates and drops temporary views during query execution to support advanced analytics and modeling features.
The views generated by Wren AI will always use unique, system-generated names and will not conflict with or overwrite your existing views.

If your user account is missing any of these permissions, you may encounter errors such as "insufficient privilege" or failures when creating or dropping views.

Connect

Fill in the connection settings: oracle_1

Display name

The display name for the database in the Wren AI interface.

Host

Your Oracle database's IP address or domain name.

Port

Your Oracle database port (default: 1521).

Username

The database username for the account that you want to use to connect to your Oracle database.

Password

The password for the username that you use to connect to the database.

Database name

The service name or SID of the database you want to connect to.

DSN

DSN (Data Source Name) is a connection string that defines how to connect to an Oracle database. When provided, it overrides other connection arguments (except username and password).

Basic DSN Example
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = your-hostname)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = FREE)
)
)
  • PROTOCOL = TCP: Standard connection
  • PORT = 1521: Default Oracle port
  • SERVICE_NAME = FREE: Oracle service name
DSN with SSL
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = db.example.com)(PORT = 2484))
(CONNECT_DATA =
(SERVICE_NAME = FREE)
)
(SECURITY =
(SSL_SERVER_CERT_DN = "CN=db.example.com,OU=DB,O=Example Corp,L=City,ST=State,C=US")
)
)
  • PROTOCOL = TCPS: Secure connection
  • PORT = 2484: Default Oracle SSL port
  • SSL_SERVER_CERT_DN: Certificate details for SSL verification

Click Next to start connection and go to the next step.

Select Tables

All tables of your connected Oracle dataset will be listed in this step. Select which tables you want to use in Wren AI. Each selected table will be created as a data model. See the Modeling documentations to learn more about what is data models. select_table

Define relationships

Define the relationships among selected tables in this step. If you have defined primary keys and foreign keys in your Oracle dataset, we will list suggested relationships based on the information. If not, you can also add relationships by clicking the Add relationships button on the table blocks. define_relationship_1

Define following properties in a relationship:

  • From: Select the left side table and column of this relationship.
  • To: Select the right side table and column of this relationship.
  • Relationship Type: Select the type of relationship. define_relationship_2

Find more information about relationship in Modeling - Working with Relationships

You can also skip this step and finish connection.