Skip to main content

Oracle

Oracle Version

Wren AI supports Oracle Database 23ai and above only. Please ensure your Oracle database meets this version requirement.

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

connect

Connect​

Fill in the connection settings:

oracle

Connecting from a local Oracle database

For MacOS and Windows users connecting from a local Oracle database, simply use host.docker.internal as the host to establish the connection.

You can refer to this blog post, which includes detailed steps for your reference.

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. relationship

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. add_relationship

Find more information about relationship in Modeling - Working with Relationships

You can also skip this step and finish connection.